I noticed the same differences since I'm a "weekend warrior" with the government and work in the private sector during the week.  The best theory I can come up with...

LOL I was wondering what was up with that table design when I read the question.  The guy that designed that table needs to be fired, Trump-style!

You want to start by looking at turning off "Automatic Key Management" with the ALTER MASTER KEY statement.  Take a look here:  http://msdn2.microsoft.com/en-us/library/ms174433.aspx, http://msdn2.microsoft.com/en-us/library/ms186937.aspx

Hi Peter,

Private message me your email address and I'll send it to you as soon as I can - either late tonight or sometime tomorrow.  I'll also send to Steve...

Thanks Scott and all,

I tried to keep the example simple for the article, but I might take your suggestion a step further and assign the "Is Commission Eligible" indicator to a...

I agree, and that's why I recommend learning how to use NULL properly and using it in moderation. Saying "Get rid of all the NULLs!" is easy; actually doing it...

As long as you reference the XP's correctly in the master database, I don't see a problem.  If you look through the Stored Procedure and UDF code, you'll be able to...

Extended Stored Procedures, by definition, can only be installed in the master database.  The other functions, procedures, and tables can be modified to work from another database, but they must still...

FYI to Everyone:

Steve has made the source code (VC++ 7.1 solution) for this project available in a ZIP file from http://www.sqlservercentral.com/products/mcoles/default.asp.

Compilation of some parts requires Boost Library source (in particular...

FYI to Everyone:

Steve has made the source code (VC++ 7.1 solution) for this project available in a ZIP file from http://www.sqlservercentral.com/products/mcoles/default.asp.

Compilation of some parts requires Boost Library source (in particular...

FYI to Everyone:

Steve has made the source code (VC++ 7.1 solution) for this project available in a ZIP file from http://www.sqlservercentral.com/products/mcoles/default.asp.

Compilation of some parts requires Boost Library source (in particular...

FYI to Everyone:

edtited: Contact the webmaster for the source.

Compilation of some partsrequires Boost Library source (in particular the Regular Expression extended procedures require Boost). Boost source is available for free...

The functions can be modified to run from a different database from master; however, I don't know that you will get much of a performance improvement because the key_vault tables...

Hi Anukul,

This particular issue is noted in the documentation.  Usually it means that SQL Server could not load one of the supporting DLL's:  MSVCR71.DLL or OPENDS60.DLL.  The most likely reason...

I notice a lot of people still using OPENXML to shred XML documents.  I've only done light testing, but it appears there are definite resource advantages (much less memory), and there...