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...

Thanks for the comments.

The thing to keep in mind is that this isn't for every company, or every app, but it has a place in the future. If you look...

Ha, very little. Haven't developed against Oracle since v7, no admin since v9

The wrong answer was marked correct. This has been fixed and points awarded back.

If you don't have a support contract, you won't get support for SQL 2000 anymore (or W2K). They will still release security patches, and try to help you with support...

OK, I'm lost again. I'll pick up the Flo story when someone posts a link.

John,

I think you might have hit the exception that proves the rule. Slowing someone down in that case might be a good use for encryption, or it might not be....

And Jeff, don't think about canceling a book because someone found a different solution. There needs to be multiple ways to do things, and even if it's not the most...

Two ten hour flights aren't bad, providing they in different years and the plane needs to make a couple stops along the way 🙂

Ugh, 20 hours. I wouldn't bother. Don't...

Unlike ORacle, SQL is not optimized for cursors. It's optimized for set based operations, and as Gail mentioned, it is far slowed working with cursors.

http://www.twitter.com/way0utwest

You don't have to subscribe, and you can sign up for twitter without getting updates no your phone.

I actually have updates turned off on my phone completely, just use the...

I keep trying to get them to let Robin to a podcast. No luck so far.:-P