Since you are worried about licensing, but you correctly are trying to avoid Access... This is hardly and optimal solution, but what about another instance on the same server. You...

The Performance & Tuning book from the Inside SQL Server series is extremely good. Tips and best practices from some of the best people in the industry. It's kind of...

I remember running SQL Server 6.5 and having to reboot the server once a week whether we wanted to or not.

But no, with SQL Server 2000/2005/2008, I would not suggest...

That's a managed stored procedure. That means it's a procedure written in CLR code, not TSQL. Here's a link on how to write one. So that's not going to help...

Do you mean encryption? Here's the entyry in the Books Online.

RBarryYoung (4/26/2009)

---

(copied from my blog):

For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from...

Here's the documentation on it from Microsoft

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

If you still have the old version of the database online, why not just take a backup of it and then restore it to the new location?

But, prior to attempting to run 2000 scripts on 2005, you need to be sure that they're compatible. Certain TSQL behaviors that worked in 2000 no longer work in 2005....

No. You can't use mysql code IN SQL 2000. You could install mysql along side SQL 2000 on the same server, but you can't run one inside of the other.

I...

WayneS (4/25/2009)

---

Bad code stories? Okay, how's this.

Company hired a VB developer to rewrite an application from Delphi to VB, but gave him rein over SQL. The rewrite was supposed to...

Oh, yeah, I wasn't at all clear. I meant that you upgrade to a test server first, of course.

Yeah, it actually would be fun just to tear through the servers...

Sorry I didn't back sooner. Gail has already suggested the two things I would have, snapshot isolation and tuning the query & indexes. I'm pretty sure this is the answer....

I don't believe there's a way to hint table access. You can supply hints to the queries that access this database, but if you have ad hoc queries or client...

From the upgrades I've done, follow Gail's advice. The Upgrade Advisor will identify all the coding issues on the database side of the upgrade.

However, it's possible to have written a...