Streamline Object ownership chain

Refresh view automatically when underline objects changed.

Cleanup job / maintenance history

Remove old differential backup after certain period

Recommaend index rebuild

You have to wait for database be recovered.

"So if I drop and recreate the index in the middle of the operation the users go for a toss."

Your create index command will be blocked if the index is being...

sp_configure 'allow updates', 1

reconfigure with override

use msdb

update sysjobs set originating_server = 'new server name' where originating_server = 'old server name'

sp_configure 'allow updates', 0

reconfigure with override

You may create your own version of sp_help_job.

Do you want to be notified before going to next step? What do you try to achieve?

Unfortunately, You can't.

The client has to input their application name is the DSN connection string. Otherwise, It wouldn't show up in sysprocesses.

1. To move databases, use backup/restore or sp_detach_db/sp_attach_db

2. Move logins, http://support.microsoft.com/default.aspx?scid=kb;en-us;246133&Product=sql2k

3. To move jobs, script all jobs and apply it to new server.

4. Open each DTS package at source...

Yes. It does. Drop and receate each indexes are an alternative.

Check "set ansi_nulls" setting.

Run dbcc dbreindex again after dbcc checktable.

Or drop all indexes and rebuild them.

Something more.

Patch upadte.

Run SQL Server service as local sysytem a/c.

Disable MSDTC if you don't need it.

       Disable the Windows guest account.

·       Rename the administrator account....

http://support.microsoft.com/default.aspx?scid=kb;en-us;269587&Product=sql2k

It looks like you have problem with database integrity. Run dbcc checkdb to your database and dbcc checktable to 'FinlAvgCalc2' to try to fix it.

For details, See BOL DBCC CHECKDB...

Here is the script I used to trace the user access to my system. I schedued it to run every one minutes. It may not complete statisfy your requirement.

declare @host...