It's both. We've had one incident when one of my colleagues detached the database that the trigger...

Yup. Petty much.

I'd definitly suggest you see if she can get some SQL training, formally or informally. How long's it going to be before she does something like write an...

No. It's a query hint. It must be applied to a query, not a storedProc. It only applies to the query it's part of.

SELECT Lots, of, columns

FROM ReallyBigTable

WHERE...

A small nonclustered index (like what I suggested) shouldn't take too long. A clustered index will take a while. Depends on the hardware and the memory available how long

If you...

You could insist that she adds OPTION (MAXDOP 1) to the end of each of her queries. Not ideal, but it might work.

You can use the governor that's in SQL...

No indexes and 2 million rows. Ouch. Does the table have a primary key?

I can suggest an index that is almost guaranteed to make this view faster. However, it's not...

Possibly someone formerly or currently on the dev team would know. There doesn't seem to be much available on the internals of statistics

Conor Cunningham[/url] indicated he might be writing on...

Please don't post in caps. It's the online equilalent of shouting, and it's kinda hard to read.

Could you please post the definition of the view, the schema and indexes of...

May I ask why you're interested?

In SQL 2005, all the implementation details of stats are hidden. On SQL 2000 it was possible to see the statsblob (an IMAGE column...

How about just

update header set Siebeltransnumber = CONVERT (char(6),h.trans_date,12)

+substring (h.trans_number, patindex('%[^0]%', h.trans_number), 20)

where Siebeltransnumber IS NULL

The reason you're getting errors is that SQL was trying to evaluate the subquery...

Placing hints without using WITH is deprecated syntax. SQL 2000 does allow hints to be placed without using WITH. SQL 2005 does not

Refer to OP's other post on this please- Reindexing and defragmentation (SQL 2000)

Apparently server is 2000, post was initially in wrong forum.

Can you post the update statement that you're trying to run?

Transactions by themselves don't cause locks or force locking modes. They just mean that a number of statements are treated like a single statement.

Temp table names don't clash with other...

If you're on SP2, use a login trigger. I've got one on my main server to prevent exactly this - users logging in using accounts they're not supposed to.

Short sample...