If you read SQL Books Online search for Renaming a Server and it explains what to do.

By the way this should be posted in the Administration section...

Try the utility ODBCPING.EXE on your SQL Server install CD. Use it with xp_cmdshell like this:

exec master.dbo.xp_cmdshell 'odbcping /DodbcDSN /Uremoteuseracct /Pwhatever'

Try running select @@servername. If the result is not the same then you need to drop the name using sp_dropserver and then re-add using sp_addserver with local option -...

If your job gets killed and you are using a utility like bcp.exe you will leave it as an orphaned process on the SQL Server machine. If you look...

There is a kb article explaining the use and limitations of filegroup backups.

Look at Q281122 on MS Technet.

You would be better off using Differential backups between Full backups.

It might be that you didn't map the old NT sid's on the new PDC.

For trusted security SQL Server stores NT security sid's in its local Windows Registry and then...

Check out my FAQ on this topic. It is very simple to do.

It sounds related to the error I had when I installed SQL 2000 SP2.

I made a note of it in the service packs section of this forum.

Use the BII.exe utility that comes with SQL Server. You can read about its use in Books Online.

You should be using the BII.exe utility for text and image bulk copies.

It is documented in BOL.

We were advised by Microsoft to revert to the SP1 version of the SQLMAP70.DLL.

This fixed the problem.

Of course you should keep a backup of any DLL you want to swap.

...

I was planning on writing another article about partitioned views to provide a guide for getting the most performance from them.

My article on the speed of partitioned views was intended...

Don't forget you need to modify the SQL Server configuration of each instance running on an AWE enabled machine. e.g.

sp_configure 'awe enabled', 1

go

RECONFIGURE WITH OVERRIDE

go

I added some user defined functions for working with dates.

Check out:

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=175

and

http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=174

I am writing the article. Takes time, dependent on resources e.g. server availability. The test db I am working with is 120 GB.