It's interesting that my co-worker was able to complete this by just dropping the PK and the PK constraint in the parent table, and it is working just fine. The...

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

So of the answers here, although good info, don't really pertain to my topic.

My question was if I would have to drop the dependencies on the PK, and I don't....

• This reply was modified 3 months ago by stevec883.

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 6 months, 3 weeks ago by stevec883.
• This reply was modified 6 months, 3 weeks 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 6 months, 3 weeks 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 8 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.