Running snapshot replication is like your nightly backup/restore and easy to implement too than your backup and restore as there is a chance that your restore may fail if a...

Rebuilding master is like rebuilding the SQL Server. Once you rebuild master database you will lose all information like the user database, logins, etc. So before you rebuild the system...

SQL Server 2000 reaalises the name of the computer dynamically so there is no need to update manually after network name change.

Check what is the type of authentication that is being used. Might be you are running in windows mode and trying to use sql ids.

You should add the acutal server name that you serverproperty command return using the sp_addserver sql. This should solve your issue.

You can also try the is null option available.

ISNULL ( check_expression , replacement_value )

Somewhere it impersonating and fails. Check if you are accessing anyother sql server or resources other than the network path in the bcp command.

Jsut add the sql server entry using the following and then use the @@servername

sp_addserver [ @server = ] 'server'

    [ , [ @local = ] 'local' ]

If you still...

There seems to be lot of problems with 64 bit installation this is the third post i am seeing in this site for the very same issue. better log a...

Just replace the server name with [local] or . so that it will point to  the current database server. in your case it might be a QA or PROD server.

Also read on server side tracing that might help you more.

Access to network resources needs the SQL Server service accounts to be  a domain account. And also you should use a windows account with proper permissions to access the network...

Default system schemas can be altered or modified.

For jobs script them and run against your 2005 server. For user DBs - detach and attach and change the mode to 90 to have full features of SQL 2005....

Brain,

Can we have the hotfix number. I still face the same issue with SP2. Might be i dint set the trace flag as you mentioned. Can you let me know...