System crashes are by definition...

I'm not sure there is a way. You can get the currently executing statement from the sys.dm_exec_sql_text funtion, getting the sql_handle from sys.dm_exec_connections or sys.dm_exec_sessions, but that will just show...

Last time I saw that message it was because an online rebuild of the index wqas occurring at the same time. Check that.

As a first pass, that the query is using index seeks, not scans and there are no lookups.

I notice that all but one of the indx operations are full scans.

Some of those sound familiar.

The table in question also had 34 NC indexes, all with the same leading column, 80% with the same second column. The leading column of all...

All of them please. Zipped and attached it they're that big.

I'm less interested in the indexes it did use than the index it might not be using that could be...

Please post the table and index definitions.

I'll move my comment from the other thread, to keep everything together.

What you have there is a cross join. With no join conditions between the tables, each row in the...

As far as I know, the info about After/Instead of is just in the script of the trigger in SQL 2000.

SQL doesn't have a before trigger

You posted in the 2005 forums, hence I assumed you are using SQL 2005.

Please use the appropriate forum...

Reliability. Modifying system objects cause assorted problems in SQL 2000 due...

Checkpoints happen automatically and just write dirty data pages to disk. It's BEGIN TRANSACTION that allows data...

shiwani2002sg (7/18/2008)

---

if by chance i run a delete command ,n sme rows from some table get deleted ,then what is the command to rollback the command or immediate command. so...

SELECT OBJECT_NAME(object_id), name FROM sys.columns WHERE is_identity = 1

No. Neither the system tables nor the system procedures can be modified in any way

Manipulating system...