What should we do to copy the tables, schema and views from
one SQL Server to another?

Answer Posted / guest

We have to write some DTS packages for it.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would we use distinct statement? What is its use?

785


What is faster join or union?

797


Do you know what is lock escalation?

771


Can you use order by when defining a view?

734


Explain transaction server implicit?

690






Data table as parameter in sql server?

721


Where is my database stored on the hard disk in ms sql server?

773


Do you know nested transaction?

682


What is failover clustering overview?

765


What are locks in sql?

708


Is foreign key unique?

750


Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

751


wat wil hapn if we give the both read and deny read permission to user?

1864


Can we perform backup restore operation on tempdb? : sql server database administration

753


What sql server means?

740