Wouldn't need any scripting.

Set up snapshot replication from the 2005 machine to a 2000 machine. Snapshot copies the entire database across, structure and data. Then back that 2000 database...

Here's a way out idea.

How about replication to a 2000 server that you control? Then you can take a backup of that and send it off. Even if you just...

The underlying structure of the code to create the databases is basically the same.

The code may be basically the same, but the structure of the database, specifically around the system tables...

What's the server's collation and what's the database's collation?

You can get these errors wen those two are different and a temp table is used, or a query uses a worktable...

What's the error you get?

What are the specs of the prod and dev servers? how much memory is allocated to SQL on each of them? Is there anything else running on those servers?

I'd run...

What are you trying to create an endpoint for?

According to Books Online, the syntax for a TSQL endpoint is

CREATE ENDPOINT endPointName [ AUTHORIZATION login ]

[ STATE = { STARTED | STOPPED...

I'll dig into schemas, if I get a chance. See if I can figure anything out. XML is not something I've worked much with though.

I would advise against automating a kill script. I've been in that situation. Best thing is to resolve the cause of the problem, not to have an automated process to...

2) Use of both distinct and union - each require tempdb and sorting --> inefficient.

the optimiser is smart enough not to do both. In cases I've seen like this there's...

If you have a deadlock, SQL's own internal deadlock detector will detect the deadlock, pick a victim and kill that connection. You don't have to do anything.

Or are you talking...

When I tried it, with the schema I got no rows, without it your query returned one row.

Is the xml column bound to a schema?

-- Test code

CREATE

...

Best this is to run the query in management studio withn the execution plan enabled and look at where the high costs are. That should give you some indication where...

Please don't cross-post

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=65&messageid=371682

You have both union and distinct. With union, distinct is redundent, since union removes duplicates anyway.

Do the views retrun duplicate data? If not, you can remove the distincts

Is there any chance of...