OP using SQL 2014 - m0st likely syntax used won't work

Frederico,

on the other post you suggested my code would actually FAIL "if you are one of those that puts comments BEFORE the create procedure command"

So now you are...

yes... but....

DO NOT restore directly from prod to any other environment. where you do need to have production data always setup a process on another server (restricted, to be treated...

it is a matter of opinion.

on my own opinion I enforce them to be after the create.

one of the reasons is that if I ever need to do a automated...

It's not like I can just install Visual Studio on the server that is hosting the databases without discussing with higher ups.  Additionally I believe this requires a coding...

why don't you do what I said and install Visual Studio (SSDT) - you can then generate a VS solution/project with all objects on your database, do the global replace...

T-SQL in a Stored Proc would be better than SSIS 🙂

you can't blindly replace all "create" by an "alter".

Replace ((REPLACE(definition,'subscriptonguid','subscriptionguid')),'ALTER','create')

you need to replace the above bit of code with

• find procedure name position - split code in...

yes until you do the REVERT you are not a sysadmin as you are the OTHER user

have a look at the examples I gave here -  it is very clear...

as per my previous examples you need to REVERT the execute once you are finished with the impersonation.

and you never told us that your login was a AD group -...

have a look at https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15

There are a few differences that can affect performance - you may or not suffer from them as it will depend on the type of usage...

as you were advised on other threads you created here over the last 2 years you either use a third party tool to monitor and log this type of events...

• This reply was modified 5 years, 6 months ago by frederico_fonseca.
• This reply was modified 5 years, 6 months ago by frederico_fonseca.

sometimes GUI does that - if you can get your hands on ntrights.exe (https://www.microsoft.com/en-us/download/details.aspx?id=17657 try using it

see https://littlekendra.com/2009/11/12/automating-sql-local-security-policy-rights-posh-and-ntrights/

you do need to learn how to read then - it is very clear the steps to do it post install.

To grant an account the Perform volume maintenance tasks permission:

On the computer...

did you follow the instructions here https://docs.microsoft.com/en-us/sql/relational-databases/databases/database-instant-file-initialization?view=sql-server-ver15