use SCOPE_IDENTITY( ) 

According to books online :

• IDENT_CURRENT returns the last identity value generated for a specific table in any session and any scope.

• @@IDENTITY returns the last identity...

Here is a nice article regarding SQL Server UPDATE STATISTICS Tips :

http://www.sql-server-performance.com/statistics.asp

Maybe it helps in solving this problem.

If your sql-column is defined nullable (. gets null), there should be no problem with SAS.

This is what we use to bulkload data using SAS.

%let sqlDWH =

   provider="sqloledb"

   properties=('data source'='mysqlserver' 'Initial Catalog'='mydb'...

Check Autostats db-setting !

sql7 and sql2k pre sp3 exec sp_dboption N'yourdb', N'auto create statistics', N'true'  --

sql2k sp3 : ALTER DATABASE yourdb SET AUTO_CREATE_STATISTICS ON...

msdb is a systemdb. I don't know if #-version restore is supported

Personaly I would script the sql7 jobs, alerts, .... and then implement...

don't add these keys if your sqlserver works !

search for a "TcpPort"-key. It has to be there and then you know you'll adjust...

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