We have to write some DTS packages for it. Copy Database wizard is one of

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

Question Posted / guest

Answer Posted / guest

We have to write some DTS packages for it.
Copy Database wizard is one of the option to copy a
Database to another Database.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can a synonym name of a table be used instead of a table name in a select statement?

1010

Show Practically Sql Server Views are updatable?

1099

Indexes are updated automatically is the full-text index also updated automatically?

1002

Do you know the cursor types?

1145

What is a scheduled job or what is a scheduled task?

944

What is a view and what are its advantages?

1095

What is spid in sql server profiler?

1082

Explain primary key and foreign key constraints?

1009

What is difference between sql and sql server?

974

Explain different backup plans?

919

What is the report model project?

141

What is onf in normalization form?

1036

Tell me what is difference between clustered and non clustered index?

931

What language is sql server written in?

1012

How will you find out if there are expensive SQL statements running or not?

1002