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 …

Transfering Cluster Nodes

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