December 14, 2009 at 7:22 am
is there a way to automate transferring of logins using sp_help_revlogin. can we get the output automatically transferred to a folder using sql agent etc?
December 14, 2009 at 9:07 am
bcp out the syslogins table in master database
December 14, 2009 at 7:01 pm
Try by using sqlcmd [-o output_file] parameter.
http://msdn.microsoft.com/en-us/library/ms162773(SQL.90).aspx
MJ
December 15, 2009 at 4:13 am
I did it using a SISS package that seperately migrated/copyed the NT accounts and SQL accounts.
Quite tricky but good pratice.
Have fun.
Adam Zacks-------------------------------------------Be Nice, Or Leave
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply