I noticed that part 3 of this series is published here http://www.sqlservercentral.com/articles/Stairway+Series/69927/, but still listed as "coming soon." Thought you might want to update this. I...

I must not have checked one of them then... I think I may have visually skipped over the autoshrink operation one. Makes more sense than a machine/web error.

That's odd, I checked these two answers:

A DBCC SHRINKDATABASE statement is executed., An autoshrink operation occurs. , A DBCC SHRINKFILE statement referencing a log file is executed.

And it told...

If you simly save the package rather than executing it in the Import Design Wizard, then open the dtsx file with Visual Studio or the Business Intelligence Development Studio, then...

Good article, but may I suggest having someone go through and edit it for proper spelling, grammar and clarity? I noticed that the same phrases were repeated one after...

A couple of things left out here are CLR assemblies, User Defined Datatypes, and the Service Broker. It's a good practice to ensure the proper dll versions for the...

Thanks, I guess I could do a local build of the dev database on my box and set up remote sp debugging on it (we don't want to open things...

Oh and I really didn't know for certain where the error was happening; I was just making an assumption.

I get it. I knew it had to be something small that I was overlooking. Thanks!

Just checking to make sure I receive any replies to this thread via email.

I think PATH is really a great alternative to doing some simple nesting versus EXPLICIT. I'd like to see an article on PATH vs EXPLICIT to see where PATH...

Aaron Ingold is right... Use this as a template...

DECLARE @t tinyint

SET @t = 1

IF (@t = 1)

begin

BEGIN try

SELECT @t

END try

BEGIN catch

PRINT error_message()

END catch

end

I never did experience this again, so I am sorry I don't have an answer for you. I wasn't sure what even caused this to begin with other than...

I have this occurring on a Server Standard 2003 x64 box with Developers 64 bit SQL 2005 sp 1. I wonder if this is fixed in SP2?

Thank you for posting that link; it's a very good summary of the DbE changes between 2000 and 2005. This would seem to explain the problem, but here are...