sp_change_users_login

Double click the right line of the text column

Bingo!

CD

Duoble check your permission of every db object inside the DTS packages and jobs.

select getdate() as Currenttime

select GETUTCDATE() as CurrentUTCtime

select dateadd(hour, 5, getdate()) as CurrentUTCtime

Hope that these samples could help u

sp_helplogins

sp_helpuser

sp_helprotect

audit

1>Use excel or word to convert the login to match the SQL server login and user requirments, including login, password, default database, username etc.

2>Import it to a database as...

security of server properties

It is very important to make sure that the data format matches ecah other between the source and the distination before importing.

Good, good, good...

SQL server 2000 licensing setup of control panel

Thanks,Calvin. Index is the first job, what is ur suggestion for the next steps?

Thanks for all of u. Very good ideas. Creating a SP to access this large table and binding it to cache also can be an asset.

If it occurs in ur...