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

What do you mean by an execution plan? Why is it used?

0 Answers  


How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,


How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,


hi... this is charan.I persued btech in 2010 looking for a job on database/back-end as freehser. can any seggest me which course or back-end tool i have to learn

0 Answers  


What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,






How to encrypt Strored Procedure in SQL SERVER?

0 Answers  


What is primary key, unique key, and foreign key?

0 Answers  


How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  


as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

0 Answers  


What are the different types of replication are there in sql server 2000?

0 Answers  


What are the properties and different types of sub-queries?

0 Answers  


What number aggregate functions are accessible there in sql?

0 Answers  


Categories