What is the default schema of your login session in ms sql server?
Can we call future method from trigger?
what is diffrent between store procedure and trigger
Explain “@@rowcount” and “@@error” in sql server?
How will u test the stroded procedures and functions? difference between SP and Triggers
How do you use DBCC statements to monitor various aspects of a SQL server installation?
Do you know how to store and query spatial data?
How many types of system privileges are there, Can we add or delete privileges?
Why use “nolock” in sql server?
What is lock escalation and what is its purpose?
How do I connect to sql server database?
Why is the need for data conversion transformations?
Can I run multiple instances of sql server 2000 at the same time on one computer?