Template Script: Service Broker\Create Service Account Logins.sql

SELECT DISTINCT  'USE [master]
GO
CREATE LOGIN ['
 + SQLServerServiceAccount + '] FROM WINDOWS WITH DEFAULT_DATABASE=[DBA], DEFAULT_LANGUAGE=[us_english]
GO
ALTER LOGIN ['
 + SQLServerServiceAccount + '] WITH DEFAULT_DATABASE=[DBA], DEFAULT_LANGUAGE=[us_english]
GO
USE [DBA]
GO
CREATE USER ['
 + SQLServerServiceAccount + '] FOR LOGIN [' + SQLServerServiceAccount + ']
GO
USE [master]
GO
CREATE USER ['
 + SQLServerServiceAccount + '] FOR LOGIN [' + SQLServerServiceAccount + ']
GO

'
FROM util.dbo.Servers

Description for Template Script: Service Broker\Create Service Account Logins.sql

Todo
Site Map | Printable View | © 2008 - 2012 NuRoN Consulting, INC | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund
Share This Using Popular Bookmarking Services