Friends, Exists some way to get the server names of the MS OLE DB of each DTS?

Friends ,Exists some way to get the server names of the MS OLE DB of each DTS? Thanks ...........

Transfering SQL instances from one cluster to another

  Hello, has anuone done this and has a suggestion to do it in a particular way? Situation: Ru…

SQL Management Studio

I have SS 2000 and am not planning to go to SS 2005 in near future. However, I would like to instal…

Deploying a DTS package

Hi, I have DTS package ( SQL 2k) on the test server. I need to deploy the same on to PRO server. I…

varibles

sortorder on varchar datatype column containing numeric values

Hi Sorting a column ascending with varchar data types that contain numeric values returns unexpect…

ASNI NULLS and ANSI Warnings error

I'm trying to save a query inside a sproc that selects from a specified linkedserver. On check synt…

install CE on same server with MSDE instances

Is it ok to install SQL Server CE on the same server that already 2 instances of MSDE as well as so…

WHERE IN help needed

I have a list of employeeids in a comma seperated string (688,708,87,88). I'd like to be able to pa…

Why Generic Error Handling?

I see a lot of code with generic error handling for every insert, update, or delete statement.…

Windows 2003 SP1 and 401 errors

I installed SP1 and now I am not able to access my reports. I am getting a 401 Unauthorized error. …

Trace a log file and check the statement that is executed in SQL Server on a specific time

Dear All, How can we do log mining in SQL SERVER2000.   I did not create a SQL  trace and…

How can i Trace the log and identify the DML stmts on specific time

Dear Users How can we do log mining in SQL SERVER2000.   I did not create a SQL trace and I ne…

Compare Databases

Hi, I need to compare two databases between different server, and I want to know if exist a instruc…

Problems Migrating Database

Hi, I'm moving several databases between Sql Servers that are running Sql 2000, my problem is that …