How to create database with physical files specified in ms sql server?

Question Posted / sanjeev saxena

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

What is a unique key constraint?

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

How to stop log file growing too big?

What do you understand by replication in sql server?

What is a subquery in a select query statement in ms sql server?

What is the default Port No on which SQL Server listens?

What is the difference between dbcc indexdefrag and dbcc reindex?

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

What is partition index in sql server?

What is temporary stored procedure?

what is the importence of the trigger in sqlserver2000?

For more SQL Server Interview Questions Click Here