The servers were clean installs with only SQL 7 installed - no SQL 6.5.

I've found out that all the servers were given a new installation of SQL 7 rather than upgrading to it from 6.5. Nobody is aware of any reason why...

Hi Gail,

I ran the DBCC CHECKDB this morning and it came back completely clean. I restarted the server (had to use WITH NOWAIT as the checkpoint was still throwing...

Are you after the gaps in the EmpNo column?

If so, without giving you the actual code, one way to do it would be to:

select the values

from your tally/numbers table (or...

I can't remember the details - I think you can only change the default db for your own login unless you are sysadmin - it should tell you in BOL.

You can set this using sp_defaultdb, or by opening the login's properties window in EM.

HTH,

Simon

Is the remote server running Windows Server 2003 or XP SP2?

(I realise you said that you were running NT5 but I wasn't sure if you might have meant 5.1 or...

Hi Jez,

Could you provide some details about the OS of both servers and the SQL version of both?

Cheers,

Simon

Are you wanting to compare them as strings or are you trying to find whether the numerical part of MSD1558017 falls between the numerical parts of col_1 and col_2?

I'm a...

Jeff Moden (21/09/2007)

Last, but not least... security... everybody can make a table in TempDB... might not be true on the "given" DB for whatever user the sproc is logged in...

We may move to 2005 at some point in the near future but at this point in time I have been tasked with getting our 7 servers to 2000 asap.

I...

Seems like Friday probably wasn't the best time to work on this because looking at it again today I realised that the setup.iss file I took from the upgraded virtual...

In response to your points, most of our servers are identical builds (both hardware and software). While I appreciate this doesn't for one minute mean the installations will all...

Thank you for the response. Unfortunately, 2 of the links refer to SS2005 and the other is for Analysis Services.

Nevertheless I'll take...

Have you tried doing a refresh when viewing the alerts in EM? I know I often have to do that to see any changes!