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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!