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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain identity in sql server?

0 Answers  


What is co-related sub query?

0 Answers  


What is a partition key?

0 Answers  


What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,


When do u use clustered index and non-clustered index?

3 Answers   IBM,






What are the restrictions that views have to follow?

0 Answers  


How you can get a list of all the table constraints in a database? : Sql server administration

0 Answers  


How to sort query output in descending order in ms sql server?

0 Answers  


Can we call SP inside a query?

5 Answers   CA, CarrizalSoft Technologies, Wipro,


Can anybody explain me cold backup and hot backup?

3 Answers   TCS,


What are the character string functions supported by sql server 2005?

0 Answers  


Explain about builtinadministrator?

0 Answers  


Categories