Question: this is my tsql query that will be used in a powershell parameter, can someone please help with resolving the error USE master GO if
this is my tsql query that will be used in a powershell parameter, can someone please help with resolving the error
USE master GO
if not exists(select * from master.sys.server_principals where name like '%ForcePointSQLSVC')
begin
USE master GO CREATE LOGIN [ForcePointSQLSVC] FROM WINDOWS WITH DEFAULT_DATABASE=[master] GO USE $server GO CREATE USER [ForcePointSQLSVC] FOR LOGIN [ForcePointSQLSVC] GO USE $server GO EXEC sp_addrolemember N'db_datareader', N'ForcePointSQLSVC' GO
end
else begin
use $database go if not exists(select * from sys.database_principals where name like '%ForcePointSQLSVC') begin USE $database GO CREATE USER [ForcePointSQLSVC] FOR LOGIN [ForcePointSQLSVC] GO USE $database GO EXEC sp_addrolemember N'db_datareader', N'ForcePointSQLSVC' GO
end
else
begin USE $database GO EXEC sp_addrolemember N'db_datareader', N'ForcePointSQLSVC' GO end
end
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
