Thanks Phil, I will give that a shot. Just curious, why did you set @var1 to NULL?

Wow, thanks Jonathan. That works perfectly with a small exception that I have decimals in column 2. But the result set for column2 is correct, except for the 0's, exactly...

• This reply was modified 3 weeks, 6 days ago by  stevec883.
• This reply was modified 3 weeks, 6 days ago by  stevec883.

I didn't include the full "CREATE" statement, sorry to throw you off. I just listed what it contains at the beginning of my post:

This is the function oracle.xxxfloat

BEGIN

IF @first IS...

• This reply was modified 3 weeks, 6 days ago by  stevec883.

I'm trying to eliminate the function by rewriting the code where it is used. The listed function, Oracle.xxxfloat, I would like to remove from the column2 statement; (These functions were...

Thanks LOL - couldn't resist the pun. The code does not have any remarks to clarify. I can't understand what it is doing either -- just trying to get into...

Sorry Phil, I had to correct my statement. When I redacted our names, I redacted too much. I guess you could say I over redacted.

I see. So the @SINGLE_RETURN variable is just for formating/separating the messages (which is what I thought might be concactenating the strings.). Thanks for clarifying.

Maybe this is enough info without the whole cursor;

DECLARE @SINGLE_RETURN char(2) = ISNULL(char(13), '') + ISNULL(char(10), '')

Inside the cursor:

SET @msg += 'Encryption was found disabled and then enabled on database [' +  @database_name +  ']' + @SINGLE_RETURN

Outside the cursor:

IF @msg <>''  EXECUTE msdb.dbo.sp_notify_operator @profile_name=N'ABC',@name=N'ABC',@subject=@msgSubject ,@body=@msg

To clarify...

Thanks for the replies.

I have clarified my question below and added additional code.

• This reply was modified 2 months, 3 weeks ago by  stevec883.

Understood - thanks.

So I can use it within a statement, and the focus change works. Such as;

EXEC(@sql + 'SELECT * FROM hr.employees')    ---hr.employees in Database1 which my window is...

Hello Orange - yes I did. There were tons of queries that were not parameterized. Developers for years had structured their apps to pass literals into the queries rather than...

SS Crazy: I am testing the script; it actually shows my ID and the script (which would makes sense), but I am connected via SSMS with a TestUser account and...

Thanks Grant, I'll try that as well.

Thanks SSCrazy Eights - this is exactly what I needed. I will also give profiler a shot as well.

Table stats is the first thing that came to mind as well. It's kind of amazing that there is no feature in SSMS to get more details of which logons...

• This reply was modified 3 years, 5 months ago by  stevec883.