You don't want to join in the where clause. It's an old join style and outer joins (which you need here) are not supported any longer.

Does this work?

SELECT entity_id,...

Where are you based in the world?

Should work. It definitely exists on SQL 2000. Maybe try prefixing with the master DB, though that shouldn't be necessary on SQL 2000, only on 2005 and higher.

select * from...

Massive waste of...

From the looks of the diagram, that database has very few primary keys and no foreign keys. How are you planning on enforcing data integrity?

In simple recovery the log shouldn't grow large as old log records are automatically discarded when they are no longer necessary. If the log is growing in simple recovery, then...

Restore the full backup somewhere, apply the log backups until just before the table was dropped, then copy the table from there into the real database.

If you had a database...

It might (if you ran it) be in the plan cache. If not, and there wasn't a trace running, then no.

select * from syscacheobjects

Well if you know the databases, you could hardcode the names in the insert statements. If you don't want to do that, then this should work, providing the login that's...

Robert (9/22/2008)

---

It's not the query that takes time, but fetching all data. 60% is a lot, sqlserver will use index if the resultset is a small part of table, 15%...

Still possible. Do you know which DBs have that table (is it fixed), or does that change over time?

Sure, providing your login has rights to the other databases. You just need to use the 3 part naming - database.schema.object, so

insert into database1.dbo.user_table ...

SQLBOT (9/21/2008)

---

Another good solution that was not mentioned before is to use database mirroring and a snapshot of the mirror. Depending on how current the data needs to be,...

Sure. It's just a text file. You won't be able to save it, but then you shouldn't make changes to it.

Typically deadlocks are the result of poorly written code or poor indexing, but then so is bad performance in general.

Are the deadlocks recurring? If so, turn traceflag 1222 on (DBCC...