@homrebrew01

you are right. Even same 2019 versions giving me an error on some servers and some servers it's working fine and sending an alert. something fishy going with the...

Yes and no - majority of cases the merge by the second developer will be without conflicts - only in a few cases will the developer be required to manually...

one way of doing it

Merge manager should decide (within team) which change should go first

developer A
--> Local          ...

regarding SHA1 - it is deprecated for crypt functions - for this type of uses and because it will be on SQL for a very long time I would not...

you need to parse the output - and ensure that you deal with the quirks of different versions of servers/locales as you are now finding out

also fsutil needs administrator privs...

Attempting to restart SQL Server instance is a quite common mistake...

depending on what the process is it can either take awhile or require a SQL Instance restart.

Multiple possible reasons depending on what the session was executing.

did you look at the contents of the string as I stated?

did you count the characters and see if your substring matches that output?

are the separaters a "," or a...

that likely has different output on the server with sql 2019 - you should be able to figure out yourself what the issue is as the convert is happening on...

look at

https://sqlquantumleap.com/2018/02/15/safely-and-easily-use-high-level-permissions-without-granting-them-to-anyone-server-level/

and

https://sqlrambling.net/2018/04/24/using-a-certificate-to-sign-a-stored-procedure/

one way of allowing particular functions to work while not granting the permissions directly.

depending on number of columns on that table you may need (and it may be advisable) to resort to have a hash column added and make this column...

depending on number of columns on that table you may need (and it may be advisable) to resort to have a hash column added and make this column the single...

this may help you https://itsalljustelectrons.blogspot.com/2017/05/Installing-Multiple-Instances-Of-SSRS.html

this is executing Ola Hallagren scripts - commented out code was for version 2008 or lower, the uncommented can be used for higher versions.

it is setup to use nearly the...

• This reply was modified 4 years, 2 months ago by frederico_fonseca.

tricky as based on the way it was phrased there are 2 right answers