You can set up a trace to capture deadlock events. Have you tried doing that?

Do you know how to write a Select statement?

I don't generally bother with installing client tools on the server. I install the server stuff on the server, and the client tools on workstations where I'll be running...

I guess it depends on what the relationship is between all the inserts and the selects.

What kind of data is it and how is it used?

Are people querying it (reports...

Can you re-create the problem with another copy of Express?

I'm sure you already checked this, but did anything unusual happen to the server about 3 days ago? A patch maybe?

I think I understand what you're trying to do.

A user adds a column to a table, and then adds values to that column. You want to take the values...

Yeah, I think I mixed two answers into one statement. Wasn't very clear.

It's a lock-timeout error. If it's happening in msdb, then it's probably something to do with...

The reason for it to lock and hang is if some other process is accessing that table. It can't drop it while something else is accessing it.

It looks like if you add GroupID to index IX_File, on table dbo.File, you'll probably solve your speed problem. Not a certainty, but it sure looks like it would...

It's not a custom made event of some sort is it? (Is there such a thing in SSRS?)

Very cool milestone. Very cool site. Very glad to be a part of it.

And I totally agree with the people who've already said this is the best SQL...

The data in the inserted table can be used quite easily for dynamic SQL, same as any other data. If what you want is the new columns, I think...

Jeff Strom: That's basically the same as what I did, you just have it in two tables where I had it in one, and you have a time-sensitivity that...

That error means that a lock was requested in msdb and timed out. Usually, that's going to mean it's a big transaction on a big temp table or a...