no. i have found no soultion. incase you do please let me know..

thanks

kevin,

i created the login as foloows

under security - logins - new login - test (name of login)

added the db creator role

default db master

gave all the d/b roles to master...

i guess you are talking about orphaned logins.

you can chek it using

sp_change_users_login 'report'

sp_change_users_login 'update_one', [ , [ @UserNamePattern ] 'user' ] [ , [ @LoginName...

and also this problem arise when we are transferrign data from as400 system to sql server. so anything needs to be chnaged at the package level. there soes nt seem...

logshipping will work with your maint plan....

all your transcation logbackup iwll be tkane on the priamry server which will then be copied to our stnadby server and applied there....

how you...

mike please can you explain with examples to make it more clear

you can also change your sa passwords on regular basis to keep the security in palce.

thanks a lot for your help. i was just going round and round assuming that there must be another secret to this

thanks philips for your help. i will dig more into it.

thanks for the info but are there any 3rd party tool that can do this ?