There is no config switch that treats a real table as if it were a temp. If you're doing a select into a permanent table, it's a permanent table.

Are there...

Excuse me?

SQL absolutely has the ability to lock rows been modified. It's an essential part of a relational database, isolation, the requirement...

That's internal objects (worktables, table spools, index spools, etc), not temp tables

Jack Corbett (1/7/2009)

---

GilaMonster (1/7/2009)

---

SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may...

sampathsoft (1/8/2009)

---

i'm making transaction base software using sql 2000 . In my program i want to stop insert,update and delete when another user modifying same record set at same...

Can you please post exactly what you get by running the following:

DBCC CHECKDB('msdb') WITH NO_INFOMSGS, ALL_ERRORMSGS

Correct, all the info is in the index.

if this is the only index on...

What does the error log say? It should have some info about the shutdown, and it will have a lot of info about why the service won't start up.

Turn traceflag 1222 on (DBCC TRACEON (1222,-1))

Any deadlocks that occur will have the deadlock graph written to the error log. The deadlock graph will have enough information to locate...

sys.tables, sys.columns, sys.foreign_keys, sys.foreign_key_columns, sys.indexes where is_primary_key=1, sys.index_columns

It's a nasty, very large query, but those are the tables needed. If you get stuck, post the query that you have.

One other...

To add on to what Barry said, there is no way to take a backup of a 2005 database and restore it on 2000, nor is it possible to detach...

Peter D (1/7/2009)

---

It may be hard to change this one as there are many jobs and Online processing using the tables and current indexes. Not much was...

Yeah, probably.

Eeep. That's a lot of execution plans.

I'm not looking at all of them. That'll take hours.

A few highlights:

Exec plan 3:

The country table needs an index. CountryID INCLUDE name, or,...

Lynn Pettis (1/7/2009)

---

Sorry, caught a couple of the Star Wars movies on...