Nope. The statement that my sql creates, if I copy paste it into a command prompt it deletes the file.

Furthermore the same proc actually creates that file to begin...

Good grief guys! Look I pulled a late one, running on about two hours sleep. You know i didn't even see the link) until now). Time for...

I just read it. And basically my question is already in this format. My question I believe is pretty detailed. I tell what I'm trying to do,...

I like your tag-line for one.

Secondly what other information would help you help me? I explained the issue, supplied my code and the output.

LOL. OR you could add the N..

Thanks Gail.

Thank you so much. You got me there. Took that error, parameterized the command and it worked.

Here is what I ran:

DECLARE @sql as nvarchar(4000)

SET @sql =...

Good idea, when I read it...

I run this:

EXEC adasdb.master.sys.sp_executesql 'RESTORE DATABASE ETLNewTest FROM DISK = ''g:\MSSQL11.MSSQLSERVER\MSSQL\ETL_663.bak''';

Get this:

Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

Can you give a full example of what this would look like?

Well the CLEANTABLE function is for varchar columns and SUPPOSEDLY does not do anything for int's.

Tried it... He shoots, he scores... It worked.

I considered this however knowing that it...

And yes the math works but in the heck is that overhead coming from

Well i created the table, new name. Added column fine. Tried original table still same problem.

Sooooooooo. I drop fk constraint, copy data to...

I prefer to code it and yes I tried that, good thought.

I am a contractor and have been at this site for a few weeks. The table has several...

LMAO...

You have no idea the relief. I just could not get this. Thanks again!

spaghettidba

ARE YOU KIDDING ME RIGHT NOW??? Dude if you were here I would hug you and give you a big sloppy kiss (glad your not here)..

It worked!!! I have...

Perhaps there is a better approach? So the part of my sproc that copies the data from one server / db/ table to another is working fine, no problem.

The...