What should we do to copy the tables, schema and views from
one SQL Server to another?
- 3 Answers
- 9443 Views
- I also Faced
- E-Mail Answers
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
What are wait types?
Explain system functions or built-in functions? What are different types of system functions?
What are the different types of subquery?
What is a scheduled job or what is a scheduled task?
What are different types of constraints?
How to rebuild the master database?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What is standby servers? Explain types of standby servers.
If any stored procedure is encrypted, then can we see its definition in activity monitor?
Disadvantages of the indexes?
Does view occupy space?
How can we solve concurrency problems?
What are the source of constraints?
What is subquery? Explain the properties of a subquery?
