A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

Explain why variables called the most powerful component of ssis?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

what is Data Transformation Services (DTS) ?can u explain me in detail?

5 Answers   TCS,

---

What is normalization according to you and explain its different levels?

0 Answers  

---

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---

What is store procedure? How do they work?

0 Answers  

---

How to create an identity column?

0 Answers  

---

How to list all field names in the result set using mssql_field_name()?

0 Answers  

---

Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?

1 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---