That will probably be fine then. Just wanted to be sure that Field2 wasn't a char(500) or something like that.

What datatypes are Field1 and Field2? If 2 is a wide type then it's better if it isn't in the cluster. The wider a clustered index key, the wider all...

Run DBCC CheckDB to see if you have any data corruption.

Since you say the users connect as SA, are you sure someone didn't accidentally drop the tables? That's the most...

Thanks. Forgot about that one.

I know there was a discussion panel at PASS last year regarding new certifications. I got an invite but didn't attend.

Sounds interesting.

If you're planning to do cross database queries, make sure you're not using application roles.

Also watch for broken ownership chains

Wow. This looks really good.

Vry good timing too, seeing as I'm writing 441 on Friday.

Does the table testwidth have a trigger?

there's another problem with your trigger. The way it's written, you will get some very odd behaviour if multi-row updates are done.

If an update...

What I'd do is restore the db and the tran logs to another server. Use STOP AT to stop the restore just before the bad transaction started, then copy the...

I've never been much for team sports, watchng or participating.

I do enjoy getting out onto the archery range on the weekends and into the dojo some evenings.

Restore the latest database backup you have and any transaction log backups since then.

You do have a backup?

What errors are you getting and where?

Checkpoint will only return the 'command completed successfully' There's no more details than that.

You really don't want to run CLEARPROCCACHE & DBCC DROPCLEANBUFFERS on a production server, especially not on...

Yeah, but it's not going to throw a syntax error. Just won't do as he's expecting, which he probably didn't notice.

Yes, but i do think an UPDATE locks the table itself, not just the row being updated.

It depends. If you're updating the entire table, a table lock is very likely...

If you don't have a backup then fixing a corruption problem (if you do have one) will be unpleasant. Is this a production database?

Run the following. (replace <dbname> with the...