Thanks guys ...... Got it to work!!! The nvarchar column is part of a different table and basically this update is used in a stored procedure where multiple columns are...

Jared I know you have commented on one of my other posts about this same procedure so we will see if this code looks familiar, but here is the code...

Jeff I think this is just being used within the company to protect some of the more sensitive client information from employees within the company that may have "devious agendas"....

Jared, believe me you are not the only person that is asking that same question. If I had to guess, I would say that this is something relatively low priority...

Jared,

The data is being used in a production environment and the purpose of this data obfuscation is just to prevent any sensitive data from being seen by people that...

Thank you for your response. I ran it and it seems to work great thanks! ..... That being said, it doesn't seem to be "jiving" with my procedure that the...

if(@aud_flag = 1)

begin

Print @STR

EXEC (@str)

Print convert(varchar(10),@@rowcount) + ' rows updated for ' + @database_name + '.' + @schema_name + '.' + @table_name

end

else

begin

set @aud_str = 'select count(*) from '...

I used the pseudocode that Cindy posted to solve my @@rowcount issues and was able to achieve the desired output. I started getting various other errors when I added the...

FINALLY!!! ....... I got it to work and it was a problem with the @@rowcount. Also there was some setting in SSMS that was disabled or something that's why I...

@@rowcount returns the number of rows affected by the last statement so this could be an issue, but I'm pretty sure count(*) should return the number of rows in a...

Ok here is the entire procedure, but keep in mind that the script runs just fine and I am not interested in any performance related stuff, "Why did you do...

Alright got it!!! Thanks everyone for the help

Sorry I posted it ^^ but it went to a new page. The procedure itself executes successfully, but when I try to execute it using the statement exec insert_table_column('dbo', 'test1',...

In my code I had quotes around it (typo when I posted). Putting quotes around it does not help. Same error ... same place.

Thank you all for your responses ..... I was able to get the procedure to run, but now when I call the procedure it gives me an error. It's just...