How to create new databases with "create database" statements?
how to find number of columns in a table in sql server 2000 and 2005 also
What is an execution plan? How would you view the execution plan?
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
What are different types of constraints?
What is similarity and difference between truncate and delete in sql?
How to connect sql server management studio express to sql server 2005 express?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What to check if a User database is locked?
what r steps to we need to fallow b4 kill the process?
What are page splits? : SQL Server Architecture
What is a Stored Procedure?