Part of wording the questions is that I have to limit the scope. One way to do that is exaggerate a bit to get you to focus on that one...

Thanks, Johan. I also pulled it down over the weekend and installed it. No issues on my SS2K8 VM

Sounds backwards, symmetric key should encrypt data for specific column.

Asymmetric key should encrypt symmetric key.

What I've seen is that reencryption can be change the asym key, reencrypt the sym key...

First, please format your post into paragraphs so it's a bit more readable.

If it's a large transaction, it's possible that there are memory issues with that transaction. Adding more memory...

Very strange, Wayne.

Are you sure the ODBC connections haven't changed? I'm guessing they're NT auth, perhaps some strange connection item?

How are the admin reports run?

I would add another statement to reset the errorlevel. a

select 1

ought to do it.

Strange. I might recommend that you grab the file and process tools from sysinternals and use them to watch what happens when you execute xp_deletefile. I wonder if there are...

First, please separate the clauses so it's easier to read. It helps us, and I bet it will help you with coding.

Second, I'd suggest that you use ANSI joins, which...

You should have experience on the platform. Which one have you worked with? If it's 2005, get that cert. If it's 2008, get that.

Achieving the certification without using the...

If you are trying to do this from some application, you could just run a .sql script with the proc code.

If you are building the proc dynamically, why?

Salesforce.com (and similar entities)

Lots of online payroll companies.

It can, and is working. For every system no, but it does make sense in places.

Are you setting max mem in Express? It might default to a lower value on install.

I'd be sure that this is set to 1GB

Be aware that if you set up a DDL trigger like this, and you don't restrict it to this user, no one will be able to drop a trigger. Possibly...

I'd go with ALZDBA's solution, but you should define what 1 year and a half means to you.

If it's early Sept and you go back a year and a half,...

I'm not sure encryption ever protects IP. If the computer needs to execute it, someone can decompile it. Those rules are well understood, and IP protection is usually through the...