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? : Sql server administration

0 Answers  

---

How can I enforce to use particular index?

1 Answers   Symphony,

---

What is nonclustered index with included columns ?

0 Answers  

---

How to create a Master database in SQL server ?

0 Answers   MCN Solutions,

---

In what three ways is the return statement used in a stored procedure?

0 Answers  

---

---

wat is mean by normalization?......programing defination i need...(i know basic defination)

4 Answers   Wipro,

---

If any stored procedure is encrypted, then can we see its definition in activity monitor?

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

What is mean by candidate key?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

---