What I want to know is the story behind that dump truck.

One correction - you mention that PK violations can be handled using the DTSLookup feature, but FK violations can't.  Actually, you can, and I have some packages that do just...

It seems that some people assume that being wired means being connected to work.  For some, being wired is part of their leisure.  I personally enjoy what I do, and...

I believe there is no difference.  The lock timout setting is at the connection level - on the server.

I can thank Kalen Delaney for my knowing the answer to this one.  I learned it in a seminar that she gave recently.  Why do I mention it?  I don't...

Ok, I'll admit I wasn't aware of that (truncate not allowed with foreign key constraint in place), but I'm not giving up yet.  (Yes, I'm pretty stubborn.)

First, as far as...

I humbly submit that I think the answer given is incorrect.  The question asked for the best statement for solving the problem.  I think the best statement would be TRUNCATE...

Actually, if you SP3, there's a new function - ::fn_get_sql, that returns much more accurate information.  I think it has a limit on number of characters, but its a lot...

I don't have a lot of experience with using Profiler to look at locking, but it seems to me that if it is set up right, you will get what...

Where do you find the specs for the PDF format?

I would also like to make a suggestion. I personally think that code that is shared with others should be...

Personally, I like TextPad. As far as I know, it does evrything that Steve's article says EditPlus does. I couldn't find a tool for commenting a block of...

I have a BS in Computer Science, and I am an MCP for SQL Server (I passed on exam). I would like to obtain an MCDBA, and I'm...

My biggest project of the last 2 years has been a process that automatically logs and imports files that are uploaded to our server from stores. This process...

I've personally never seen a rollback take longer than the original transaction, although I've seen them take much less time. The only exception was when I had the...

Since I was just reminded of this thread, I thought I'd post the solution that I discovered, since things have been working for a while now.

The problem had...