Can someone help me with a power shell skript to update username in database? Please read instructions $ServerName = "_ServerName_" $DatabaseName = "_DatabaseName_" $Query = "SELECT * FROM Table WHERE Column = '" #Timeout parameters $QueryTimeout = 120 $ConnectionTimeout = 30 #Action of connecting to the Database and executing the query and returning results if there were any. $conn=New-Object System.Data.SqlClient.SQLConnection $ConnectionString = "Server={0};Database={1};Integrated Security=True;Connect Timeout={2}" -f $ServerName,$DatabaseName,$ConnectionTimeout $conn.ConnectionString=$ConnectionString $conn.Open() $cmd=New-Object system.Data.SqlClient.SqlCommand($Query,$conn) $cmd.CommandTimeout=$QueryTimeout $ds=New-Object system.Data.DataSet $da=New-Object system.Data.SqlClient.SqlDataAdapter($cmd) [void]$da.fill($ds) $conn.Close() $ds.Tables ServerInstance = "VCOM " $Database = "VCOM " $ConnectionTimeout = 30 $Query = "SELECT COUNT(*) FROM [VCOM_Comm].[dbo].[COMM_ConfigStore]" $QueryTimeout = 120 $conn=new-object System.Data.SqlClient.SQLConnection $ConnectionString = "Server={0};Database={1};Integrated Security=True;Connect Timeout={2}" -f $ServerInstance,$Database,$ConnectionTimeout $conn.ConnectionString=$ConnectionString $conn.Open() $cmd=new-object system.Data.SqlClient.SqlCommand($Query,$conn) $cmd.CommandTimeout=$QueryTimeout $ds=New-Object system.Data.DataSet $da=New-Object system.Data.SqlClient.SqlDataAdapter($cmd) [void]$da.fill($ds) $conn.Close() $ds.Tables DATABASE queries to run from skript [Takes username semork] Use aba SELECT * from [dbo].[Users] where UserDBMnkr LIKE '%ram%' [Inactivates the user (Get the UserId from the previous query) Use abc UPDATE [dbo].[Users] SET UserStat = 'I' WHERE UserID= 142 Use abc UPDATE [dbo].[Contact] SET CntctStts = 'I' WHERE CntctID= 161