ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
What should we do to copy the tables, schema and views from
one SQL Server to another?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What should we do to copy the tables, schema and views from one SQL Server to another?
Answer
# 1
We have to write some DTS packages for it.
 
Is This Answer Correct ?    1 Yes 0 No
Guest
 
  Re: What should we do to copy the tables, schema and views from one SQL Server to another?
Answer
# 2
Copy Database wizard is one of the option to copy a 
Database to another Database.
 
Is This Answer Correct ?    4 Yes 0 No
Kmbkrishnan
 
 
 
  Re: What should we do to copy the tables, schema and views from one SQL Server to another?
Answer
# 3
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
Guest
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
As a part of your job, what are the DBCC commands that you commonly use for database maintenance? HCL1
What is row by row processing ?  1
How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables? TCS3
Alternative way to DetDate() function?  4
What is SQL server agent? SAP-Labs2
Which virtual table does a trigger use?  3
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance.... Siemens6
Can a stored procedure call itself(recursive). If yes what level and can it be controlled.?  2
What is the difference between SSAS 2000 and SSAS 2005? APX1
what is the query and condition to delete datas in sql server.  2
I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000  11
What are the type of joins? When do we use Outer and Self joins?  3
What is Schema? and why we use schemas?  1
What is the difference between distinct clause and group by clause? Value-Labs1
What is the use of MOVE keyword in restore command IBM2
What is INTVAL( )and where we use Plz any body help me  1
which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM Wipro4
what are default? Is there a column to which a default cant be bound?  1
can you any body tell me the difference between candidate key and primary key  4
what is Constraint? How many types of constraints in SQL ? NIIT7
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com