Have to admit I didnt try it, mainly because I use SQL2K exclusively these days. Could be that the code would have to be tweaked, but I think the basic...

Sticking to the SQL92 standard is interesting. Not compelling to me, but interesting! We're SQL Server only with no plans of changing, so I don't feel bad at all about...

We have a workstation set up with personal edition that we use mostly for the scheduler, but TS runs on servers (we're not using XP yet). Our admin has been...

Decent plug for a decent book!

Profiler is not nearly as bad in SQL2K. In SQL7 it could load the box pretty heavily. Definitely start with just a few events and...

Notification services might be overkill from what I saw of it. It's a sound idea, one place for all alerts & messages to originate from, just not simple to implement....

Getting the error where? In VB code? Have you changed your connection string to use the Jet 4 driver?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Steve A,

Not sure that is right, dont have my Inside SQL book here. You can index it, as far as SQL allowing you to do it. Whether it uses the...

Oooh, that pricing model isnt fun. I have a couple hundred db's as well. Might be fun to test it to see if it really could fail them all over.

Andy

http://www.sqlservercentral.com/columnists/awarren/

What will you be using the rowid for?

Andy

http://www.sqlservercentral.com/columnists/awarren/

Its a tremendous headache. I guess I understand why its that way, but it causes no end of issues. Package gets designed against shares that dont exist on the server...

One other thought - only real issue we had was a couple places where were concatenating a string with a null. In 65 you get a string, in 70/2k you...

I agree. Moving from 65 to 2k isnt too bad, but best to get it out of the way first. If you've got your data/logs separate from the OS, you...

I typically use a stored proc to return data. Functions to package reusable code. I know that sounds the same, but its different to me! If Im returning a single...

One note - it most cases you want Union All, not Union. Can lead to some subtle bugs!

Andy

http://www.sqlservercentral.com/columnists/awarren/

I doubt you could get a query to go much faster than replication, especially once you build in all the required fault tolerance. Log shipping moves changes in bulk, the...