To use Windows NT domain accounts (mapped to themselves) with linked servers you have to configure security account delegation. Your server has to be Windows 2000 (or 2003) in domain...

It should not be any problem. We did it and all accounts were OK. Make sure that netbios domain name will be the same and accounts SIDs not changed (on upgrade...

Seems to be true for Standart Edition:

"Licensing for a Multi-Instance Configuration

.................... SQL Server 2000 Enterprise Edition Processor Licenses and Server Licenses allow you to install multiple instances of SQL Server...

I think this is a name resolution problem. Check all network settings, WINS, DNS ect. Try to ping from both servers each other by the name. If ping will not be...

Also, you can query syscomments table to find if there is table name in procedure code:

SELECT o.name FROM SYSCOMMENTS c JOIN SYSOBJECTS o ON c.ID= c.ID WHERE c.text LIKE '%YourTableName%'

Check your Windows 2003. DTC is not installed by default on W3k. And you need DTC to run distributed query. Add DTC through Add/Remove Windows components ("Application..." -> "DTC").

Is there reindexing job in your maintenance plan? Mmaintenance plans reindex  with  DBCC DBREINDEX. And Microsoft recomend to use DBCC INDEXDEFRAG insted of...

This is called "dynamic SQL" when you use sp_executeSQL to execute string . It's slows down query, because it parced on every execution. I think this is the main reason.

>This normally occurs after our database reindexing job.  Very odd.

This is the answer, why log grows. Maintenance plan reindex with  DBCC DBREINDEX. And here is...

If your servers will participate in remote queries - add one of the Windows components - DTC (Distribution Transaction Coordinator is not installed by default in Windows 2003).

If you are using the Database Maintenance Plan Wizard, instead of using the Reorganize Pages with the Original Amount of Free Space option, choose the Change Free Space Per Page...

You also can create your stored procedure from this VB script (result is in file C:\disk_log.txt) or use this script in DTS package to fill your report table:

Const HARD_DISK =...

Yes, you can do it with stored procedure:

sp_renamedb [ @dbname = ] 'old_name' ,

    [ @newname = ] 'new_name'

or in Enterprise Manager.

Hi!

You can use this articles:

http://support.microsoft.com/default.aspx?scid=kb;en-us;241643

http://support.microsoft.com/default.aspx?scid=kb;en-us;834124

Also, check SQL Server and Agent startup account in Services (Admin. Tools). In Windows 2003 this account can couse errors - 'DOMAIN\SQLPROD'. We have,...

To use Windows NT domain accounts (mapped to themselves) with linked servers you have to configure security account delegation. Your server has to be Windows 2000 (or 2003) in domain with...