Hi

You should consider defragmenting the indexes and only rebuilding indexes as needed as rebuilding indexes has a large penalty on the transaction logs you may also consider setting your database...

Hi SteveV

How was the training?

1.The linked server setup for impersonation or remote security?

Don

Try run the UPDATE STATISTICS command as the reference types mentioned above relate to the stats built by the query optimizer on the indexes as query hints.

Thus if the index...

---login failed for user (null).

I would use a explicit SQL account for the primary purpose of the linked servers with minimalistic rights applied for best practise.

I could not have said that better .... Touche'