- Assign the id to be searched to the $searchid variable
- Open the Powershell ISE Editor or Powershell command line.
- Execute it . It will tell you if your login is there in the SQL Server or not.
#This script will help you to find out whether a particular id is present in the SQL Server
#Using foreach you can use this to find the ids in multiple servers as well.
Clear-content 'D:\logfile.txt'
[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO') | out-null
$logfile='D:\logfile.txt'
$searchid='Give the ID here to search'
foreach($server in $servers)
{
$srv = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $server
#This sets the connection to mixed-mode authentication
$srv.ConnectionContext.LoginSecure=$true;
$dbs=$srv.Logins
if($dbs.contains('$searchid'))
{
$server+','+'ID found' | Out-File $logfile -Append
}
else
{
$server+','+'Nil'+',' | Out-File $logfile -Append
}
}
Using a CData DataCmdlet and sqlps to replicate data from Google Spreadsheets to a SQL Server database in PowerShell
2017-06-01
773 reads
Use Powershell to create a single script that checks over your server and every SQL instance on it to help pinpoint problems.
2014-04-11 (first published: 2011-04-04)
12,469 reads
In the first article, we learned how to move data into SQL Server. This time Chad Miller shows us how we can use Powershell to extract data out of SQL Server.
2009-01-02
21,305 reads