Let me clarify:

If you have servers S1 and S2. Let us say S2 is defined as a linked server on S1. I am assuming you have selected the windows user...

Thanks. All of them just work fine.

From my experience, use cursors only when there is no set based solution. And trust me, there are quite a few where there is just no set based solution (for...

Were you running the query from the source server (ie the server where linked server is setup) ? If you are running from a client then delegation needs to be...

Once you rename the source table A to A_bk, do not create a new table A yet. Just say

Select * Into A From A_bk.

This will create a table A...

When a linked server is down the TSQL batch exits and there is no way to trap the error. If you expect the code to handle this issue, use a...

Thank you every one for your feedback and those using MOM please post any gotchas. I used sitescope in the past and found that to be fairly easy to setup...

Defragmenting within the database (ie at the table level) has almost always solved our performance issues, so never had to go to the extent of OS defragmentation. One of the...

Does the account have "logon as a batch job" user rights?

One of the Microsoft articles suggests that changing the SQL Server or agent account should be done through the SQL EM, since the account needs some registry and file system...

You can declare a global variable, assign values from the ini file to the global variable and then read the global variable from the ActiveX script. Would that be acceptable?

This is what I came up with. Any better SQLs out there?

DELETE pl FROM sysdtspackagelog pl

WHERE lineagefull NOT IN ( SELECT TOP 10 lineagefull FROM sysdtspackagelog pl2

WHERE pl.name...

The space Overhead for the clustered index is so small, that it is never a factor. It depends on the number of fields in the key,  their lengh etc, but...

The database and log files should be on separate arrays / raid volumes. There is no exception to that rule. But, I usually place all my indexes (clus and non-clus)...

Is the MS Distributed Transaction Coordinator service running on the remote server?