Where in ms sql server is ’100’ equal to ‘0’?
What is difference between cte and view?
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?
Explain insert into select statement?
what is DTS what are tasks available
What is the difference between truncate and delete commands?
Find columns used in stored procedure?
What the different components in replication and what is their use?
is there a column to which a default can't be bound? : Sql server database administration
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
what happens on checkpoint? : Sql server database administration
How many databases Microsoft SQL server provides?
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?