What is implicit mode in sql server?
What do you mean by data integrity?
What are the types of table?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How do I know if localdb is running?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What are security principals used in sql server 2005?
can a database be shrunk with users active? : Sql server administration
What will be query used to get the list of triggers in a database?
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
Creating Tables Using SELECT
Explain different types of self contained sub query?
Define Check points and End Points?