nope there's no way, AFAIK.

your options are to use a trusted connection with their windows login so you don't need the username and password at all,, or to use EXECUTE...

--edited, as a duped answer that does not work....

i think his new "SQL Spackle" which is code used to fill in the cracks counts as one....

For reference, this is readily consumable data: Anyone can copy and paste this sample data into SSMS and then start working.

i changed all your column names.

SELECT 1 As OrderID,1 As...

at our shop, it's still starts with the basics:

backup...restore.

then a custom script we wrote munges the data....deletes records and child records based on FK hierarchy...which can be a real pain....

it might take a bit of work, but this article teaches you how to read the transaction log that is in full recovery, but no backups to recover with:

http://www.sqlservercentral.com/articles/Transaction+Log/71415/

the author...

no, you read it right...my attention deficit order only let me read the first eight words of the thread before i came to a conclusion...

Thansk Paul!

to get preceeding zeros, you have to decide on the length you want(you said 3 digits in this example)

and do something like this:

SELECT RIGHT('00000000' + CONVERT(VARCHAR,(8 + 1)),3)

Kevin it has to do with datatypes; '008' is not numeric, it's a string, same as 'abc', but when you add it to an integer, it might get converted to...

linked server syntax:

Once you have the Linked Server in place I have found a few different ways of interacting with the mysql database:

Select Statements:

select * from mysql5...country

select * from OPENQUERY(mysql5,...

i think the recommended way is to connect via a dedicated admin connection (DAC);

I belive when you do that, all procs are decrypted automatically when you view them, to assist...

the function below is for SQL 2000 only; if you run it on 2005/2008/R2, all it does is drop teh encrypted procedure, but does not recreate it.

bjhogan (12/15/2010)

---

Check out this...

the error is your data types in your first table variable, and the way you are doing your case statements.

your first table is declared all as varchar(20), but then your...

you'll have to show us the procedure; the error itself is not descriptive enough to point out anything obvious.

the onlything i can offer is that if you are storing that...

I'd...