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, 1 month ago by frederico_fonseca.

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

Thanks Steve - issue is sorted now

Adding to what Grant said (I do use SQL Monitor and also other similar monitor tools).

one of the most important things is the ability to correlate different metrics that happened...

by the way you explain things it really looks like you know nothing of SQL Server permissions as this particular case is the most basics of access to any user.

Please...

that being the case then there is nothing preventing you from changing the stored procedure to behave better. May or not be possible but I have seen many cases of...

Steve said the essential - but...