IMO you should alter key :

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\instancename\MSSQLServer\SuperSocketNetLib\Tcp]

"TcpHideFlag"=dword:00000000

"TcpPort"="1433"

"TcpDynamicPorts"=""

or

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib\Tcp]

"TcpHideFlag"=dword:00000000

"TcpPort"="1433"

"TcpDynamicPorts"=""

I hope this helps

print 'Free Space'

print '----------'

exec master.dbo.xp_fixeddrives

print 'Memory'

print '------'

exec master.dbo.xp_msver

print 'Database Configuration'

print '----------------------'

exec master.dbo.sp_configure

print'DB Size'

print'-------'

exec master.dbo.sp_databases

print 'Linked Servers'

print '--------------'

exec master.dbo.sp_helplinkedsrvlogin

print 'Windows info'

print '------------'

exec master.dbo.sp_server_info

in addition to Steve's responce:

If you're running sql2k sp3 standard edition on a multi-proc-box, you might encounter this bug (fix available) : FIX: A Parallel Query with a COUNT Aggregate...

check sp_pkeys and sp_fkeys in books online

Keep in mind your restore-time will depend on your network speed / availability !

maybe this site can help you calculate the needed time :

http://www.homenethelp.com/web/explain/about-network-speeds.asp

use master

go

alter database tempdb modify file (name=tempdev,filename='E:\MSSQL\DATA\TEMPDB.MDF')

go

alter database tempdb modify file (name=templog,filename='E:\MSSQL\DATA\templog.ldf')

go

-- RESTART SQL SERVER !!!!!!!!

SHUTDOWN

Startup sqlserver with sqlserver service manager (don't forget sqlagent !)

Cleanup old files !

use tempdb

go

exec sp_helpfiles

go

check...

is autostats enabled ?

run sp_updatestats / dbcc updateusage once in a while (even with autostats on)

Check again.

Still differences ?

Is your sql2k on sp3a and on a multi-proc box ? if...

check your sqlserver logs. If sa-password has been altered, it records a line in the sqlserver errorlog.

Don't get confused with windows authentication !

If you login using windows authentication, there is...

Restore database yourdb

 from DISK = '\\UNCservername\path\backupfile.bak'

Check restore in books online

for this you don't need "case" but correlated subquery 

select * from dyna.dtaTenant t

where not exists

(

SELECT 1

FROM dyna.dtaTenant

 INNER JOIN dyna.ctlLinks

 ON dyna.dtaTenant.DyKey =...

One of our customers stated he didn't need backups copied to a safe place.

When he tested his backup-power-system there was this litle problem where in stead of 220V the...

only one client ?

The more stupidities they produce, the more they'll need people like us

Make it...

trivial, but overlooked it

Nice...

how about using transactions to get isolation ?

Offcourse everything has a price !

CREATE PROCEDURE GetColor

    @OutRowID INT OUTPUT

AS

BEGIN

-- print statements added for debugging

    SET NOCOUNT ON

declare @trancount int

set @trancount...

firts : ALTER DATABASE yourDB  Set [RESTRICTED_USER , ]

                READ_only  WITH ROLLBACK IMMEDIATE

then perform your restore.

After restore, the db will be in the same state as it was when...