If you're running SQL Server 2000, you should be running SP4. (I apologize for leaving that out of my original post.) It never occurred to me that someone wouldn’t...

I'm not sure what the issue could be, we go from 32bit 2000 to 64bit 2005 based servers (and vice versa ) and from 32bit 2005 to 64bit 2000 servers...

You are correct, you will only want to load this on a SQL Server 2000 that is SP3 or higher.

The reg entries can be changed at:

Local Machine\Software\Microsoft\MSSQLServer\MSSQLServer\Parameters

The method I described was for SQL Server 2000 only. You DON'T load 2000 scripts into a SQL Server 2005.

Assuming you’re installing the script(s) on a SQL Server 2000 based...

Am,

You have to open the file first in QA, and then press F5. (File|Open|Find the file|Press Open)

You can't execute the script using the DOS path - Which your post seems...

Igor,

Idera has released a new version that works on both SQL Server 2000 and 2005 (and they added native 64bit). We're running SQL Safe in both 2000 and 2005 (32bit...

I agree with Mike, the first step is to get your transaction logs under control.

Here are the basic steps (at least in my opinion)

1 .Create a job that runs to...

The fix is to install the file [Instcat.sql] from the SQL64bit CD on the 32bit server.

This file is located in the folder: Setup\IA64\Install (remember IA64 can different depending on...

The fix is to install the file Instcat.sql from the SQL64bit CD on the 32bit server.

None of the answers are correct. (Unless you had given the domain admins rights)

I think this question should be thrown out.

Correct answer should have been:

Default instance:

HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode

Look at this...