I am assuming you have a non-clustered covering index. Does it makes a difference if you change it to CLUSTERED.

It happened to me once

GO to EM

Right Click on your server Select properties and on the security tab update the password!

Try replacing ALL "#" by "[0-9]"

ex:

"###" ---> "[0-9][0-9][0-9]"

OR

at the end of your query you could use

DECLARE @qry varchar(8000)

SELECT @qry = COALESCE (@qry, ' ') + "SELECT TOP " + LEFT(RowCnt,1) + "...

quote:

---

OK... Does that mean that if I create a basic SP with an insert I will still always be returned this "@RETURN_VALUE"...

quote:

---

You can try to do something like this:

If exists(select * from table where key = @key)

insert into table (key,...)

...

MAKE sure the values you are saving are in the right order on the US server,

I mean = mmddyyyy AND NOT ddmmyyyy

an easy way to check will...

It is A LOT easier to use DTS for this!

I have try xp_sendmail using the @separator=',' and @attachments = 'file.csv' and even though it send the Formating abilities of this...

If you are going to do this in DTS you will:

1. Create

a) Access DB Connection

b) Execute SQL Task

...

What's the Problem with the Message Queue Task within DTS?

is it not good for your purposes?

This is a nice thought:

You CAN'T HAVE YOUR CAKE AND EAT IT TOO!!

If you think about performance only then

1. FK are indeed afecting you insert and...