VIVEKANANDHAN_PERIASAMY
asked on
Need Powershell script to take syslogins backup
Need Powershell script to take syslogins backup and should save the syslogins in the remote server(UNC)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Take a look here and put these in your master database:
http://support.microsoft.com/kb/918992
Then you can run the following script and get your information out.
$server = New-Object Microsoft.SqlServer.Manage
$db = $server.Databases["master"
$ds = $db.ExecuteWithResults("EX
$ds.Tables[0] | Export-CSV "c:\temp\logins.csv"
or something like that.