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, 5 months ago by frederico_fonseca.
• This reply was modified 5 years, 5 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

If a third-party tool is an option, you can consider using our SSIS Productivity Pack. Within the Productivity Pack, our Premium ADO.NET component will allow you to...

to go from 2012 to 2008 your only option is to recreate the package from scratch.

you can go higher easily, sometimes without even doing a package upgrade, but not lower

have a look at https://stackoverflow.com/questions/6921105/given-a-filesystem-path-is-there-a-shorter-way-to-extract-the-filename-without

from your code above "path" is not a System.IO object but rather a string - so you should even just be getting an error on the...

as I told you above you need to test your system and see if they are required.

Nothing we may say should influence you on that - we may tell you...

google is your friend - sadly most people don't use it.

https://stackoverflow.com/questions/4095627/blank-lines-at-end-of-ssrs-csv-export