Try This

sp_MSforeachdb 'use ? SELECT  TOP 20 db_name()[Database], OBJECT_NAME(id)[Table], Rows

FROM  sysindexes

WHERE  indid < 2

 AND id in (SELECT OBJECT_ID(NAME) FROM [sysobjects] WHERE type = ''U'')

 AND rows...

does dbo.DensityGrad have SET NOCOUNT On ?

Export registry for following key.

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X

and import it opn other machines.

i am not sure about authentication.

Can you open a Query Analyzer session to targeted linked server from console of this particular server ?  

http://www.sqlservercentral.com/columnists/RDyess/traceflags.asp 

What was the result of this contest ?

do not forget to add

SET XACT_ABORT OFF

I came across a simm. situation as well.

At that time, I issued a

ALTER DATABASE <DBANME> SET SINGLE_USER WITH ROLLBACK IMMEDIATE

ALTER DATABASE <DBANME> SET MULTI_USER WITH ROLLBACK IMMEDIATE...

use "DBCC UPDATEUSAGE" on those database / tables / indexes.

also

if any of those tables has undergone a ALTER TABLE and dropped varchar, text columns then use "DBCC CLEANTABLE"

And...

If it is only Data migration from one SQL 6.5 server to another SQL 2000 box, you could use DTS or BCP.

I would have done following.

1. Generate Script for...

Not direct command in TSQL to alter a identity column.

Even EM does a DROP and RECREATE (and a rename) internally.

To confirm this, go to design view of a table...

I use dSQLSRVD

http://www.geocities.com/d0mn4r/dSQLSRVD.html

I am not sure, how you thought of a table read in master.

Query Plan shows only constant scan for this type of query.

select CAST(DATEPART(yyyy, '2003-01-10') AS VarChar(4))

   ...

Upgrading Databases from SQL Server 6.5 (Upgrade Wizard)

You can convert data from Microsoft® SQL Server™ version 6.5 to the formats for SQL Server 2000 using the SQL Server Upgrade...

see if this helps ....

http://www.microsoft.com/sql/techinfo/administration/2000/scalability.asp