I can not add procs or any other actual object. I can add the field that I need to, naturally. And after the import I will grab the NEW Identity...

spaghettidba,

Ok same thing here. I THINK It is really close. I copied your code exactly. I changed your @sql names to what I am using.

I get the following...

SSCarpal Tunnel Trying now.

I believe I am closer sir.

I did the following outside my proc:

DECLARE @SQL1 nvarchar(4000)

SET @SQL1 = 'ALTER TABLE ' + 'Node '

+ ' ADD ' +...

It is being called from a SPROC. The call is going to a Linked Server so that wont work unfortunately .

Agreed but I can not. We are ETL'ing data from 100 + databases, servers. And I can not add anything to those (client machines). I Can add them as a...

This did not work or I don't know the context in which to use it.

I am setting the statement to a variable. then executing that variable.

Example:

DECLARE

🙂 So true.

Roy Ernest (5/22/2008)

---

Hi Matija,

I liked the way you kept your cool. I am not sure why you say that you should not try to Update the Alias?...

I can not get to article it says to many redirect loops??

OMG. Are you kidding me right now?? Now THAT is embarrassing. I can not believe I missed that.

Fixed and working, thank you so much.

(shaking head in disbelief)

Thank you for the replies. I am using the exact example from this link"

https://msdn.microsoft.com/en-us/library/ms365420%28v=sql.110%29.aspx

And the decrypted field looks like Chinese writing.

I made database called 'Encrypt'

A single table...

Honest answer, because I have not messed with encryption before and I don't know what I am doing with this, trying to figure it out. Here is the example...

Thank you, I will play with this. I have not used the OUTPUT clause yet.

Actually the mistake was on my part and it was so completely stupid I would rather forget about it lol.

Thank you, I'm all set