Interesting theory.  I attempted and the sqlcmd variables cannot be set to tsql variables.  So :setvar server @replicaName does not resolve to the value of @replicaName, it just puts the...

Thanks so much for the quick replies, much appreciated.

I questioned the vendor on the need for extended stored procedures, and they respond that they sent me outdated information but insist...

Found out my own answer.

info on sys.database_files growth * 8 / 1024 = 4096

Here is the issue in more detail. Some of our databases are creating excessive amounts of VLFs when the logs grow. Then when the cluster fails over, the...

I cannot claim credit for this solution, but it is what I needed.

Create trigger addLoginToServerRole on ALL Server

for CREATE_LOGIN

as

declare @data xml

declare @loginname nvarchar(1000)

declare @altercode nvarchar(1000)

set @data = eventdata()

select @data

select @loginname...

You are correct, I do want to add a login to a server role. This is due to the new STIGs.

The extra line of code that you mention is...