What should we do to copy the tables, schema and views from
one SQL Server to another?
Answer Posted / kmbkrishnan
Copy Database wizard is one of the option to copy a
Database to another Database.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How many types of triggers are there?
Difference between group by clause and having clause in SQL?
What is the difference between locking and multi-versioning?
Can foreign key be deleted?
Explain alternate key, candidate key and composite key in sql server?
Where do you find the default Index fill factor and how to change it?
What is clustered vs nonclustered index?
What is meant by indexing files?
What is an index in a database?
What are scalar functions in sql?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is change data capture (cdc) feature?
Can you explain what is indexed view? How to create it?
What is dirty page?