I tried all day to reproduce the error, by running the exact SQL that the SQL job runs in a query window and can't. I have also tried running...

Interesting. I'd never heard of the REMOTE join hint.

I just tested it, and the speed of the query didn't change much.

Then something occured to me...when I run this...

There aren't any new triggers that I can see. We really don't use them very much.

I didn't mess with read uncommitted.

One of the things BOL says about it is: "This option has the same effect as setting NOLOCK on all tables in all...

But even if NOLOCK did work, that solves the opposite problem of what I have doesn't it? I would expect nolock to allow the select statment to run even...

Another strange thing... I tried to reproduce it on another server by changing my query from:

[PROD-SERVER-NAME].DBNAME.dbo.TableName to [DEV-SERVER-NAME].DBNAME.dbo.TableName and I can't reproduce the locking behavior.

What types of...

I wish we could do that, but the servers involved here are scattered all over the country and can't really be combined.

That's interesting. I would expect that to allow the select statement to run if something else was in the middle of a transaction and that was preventing the select...

Yes, there are lots of joins, but with that collation setting shouldn't those all be done remotely and not on the calling server?

I'm still fighting with this thing. I...

I tried playing with that, but it didn't seem to make a difference.

I finally gave up and made a stored procedure on the server that gets hit, and just execute...

Do you know if there is a way to make SQL not create these dump files?

Some of the ones it creates are 0.5GB+ and they take up a lot of...

From BOL:

FORMATMESSAGE looks up the message in the current language of the user. If there is no localized version of the message, the U.S. English version is used.

If you still can't get it, post the new script you are trying to run and the error you are getting. Might help someone troubleshoot and get you some...

nailosuper (8/14/2008)

---

Hi , can anyone help me about dynamic sql. I try to write an automatic restore script. But i don't know the syntax and i get always errors.

i don't...

What syntax do you use to run that before it is attached?