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?


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

Post New Answer

More SQL Server Interview Questions

How to find the date and time of last updated table?

6 Answers   Teledata,


What is dirty page?

0 Answers  


What are data resources?

0 Answers  


Can Somebody tell me the difference between Clustered & Non- Clustered Index??

5 Answers   Progressive,


What is the distinction amongst delete and truncate?

0 Answers  






What is a full text index?

0 Answers  


What do you know about normalization and de- normalization?

0 Answers  


What is indexed views? plz explain with example?

2 Answers  


Explain intellisense for query editing

0 Answers  


What are subqueries in sql server? Explain its properties.

0 Answers  


What stored by the tempdb ? : sql server database administration

0 Answers  


Explain basic SQL queries with SELECT from where Order By, Group By-Having?

3 Answers   TetraSoft, Wipro,


Categories