Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the best way to move n number of DTS package from
one SQLServer to another SQLServer?

Question Posted / sandeep.rohila


What is the best way to move n number of DTS package from one SQLServer to another SQLServer?..

Answer / pratik

transfer data from sysdtspackages of msdb database to
another SQL Server

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SQL Server Interview Questions

A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?

2 Answers   Sapient,

optimization techinques

0 Answers   Wipro,

What is the difference between having clause and where clause in sql server?

0 Answers  

What are the types of subquery?

0 Answers  

What is an identity column in insert statements?

0 Answers  




What is subquery? Explain the properties of a subquery?

0 Answers  

What is the difference between HAVING clause and the WHERE clause?

7 Answers  

What are statistics?

0 Answers  

How many database files are there in sql server 2000?what are they?

0 Answers  

Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY

5 Answers   TCS,

Explain the third normal form(3nf)?

0 Answers  

plz send every query in sql server2000

1 Answers   Infosys,

For more SQL Server Interview Questions Click Here
Categories