Viewing 15 posts - 1 through 15 (of 34 total)
What I want to know is the story behind that dump truck.
June 4, 2007 at 2:29 pm
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...
December 20, 2006 at 7:28 pm
I believe there is no difference. The lock timout setting is at the connection level - on the server.
March 24, 2004 at 1:19 pm
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...
March 23, 2004 at 11:26 pm
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...
March 22, 2004 at 3:07 pm
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...
March 18, 2004 at 4:55 pm
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...
January 15, 2004 at 12:19 pm
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...
January 14, 2004 at 11:40 am
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...
August 27, 2003 at 5:46 pm
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...
July 21, 2003 at 1:29 pm
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...
October 31, 2002 at 3:50 pm
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...
October 31, 2002 at 3:10 pm
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...
October 17, 2002 at 2:30 pm
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...
September 6, 2002 at 10:29 am
Viewing 15 posts - 1 through 15 (of 34 total)