adspace


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

What is an indexed view?

1023


What is the difference between upgrade and migration in sql server?

1185


What is normalization and what are the advantages of it?

1057


How can I check that whether automatic statistic update is enabled or not?

1113


Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1024


What is in place upgrade in sql server?

1127


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1300


What are the kinds of subquery?

1109


Is it possible to have clustered index on separate drive from original table location?

1041


What are the source of constraints?

1010


When should you use an instead of trigger?

1054


How can we solve concurrency problems?

1123


Can we do dml on views?

1039


What is a view in sql?

1043


Can you index views?

955