I think the reason you don't find much is that there isn't much. With SQL2K you can publish your publications to AD, that's about it. If you're using AD, then...

Nope. You could use upper, lower, and substring to accomplish the same thing. You'd have to put it inline in 6.5/7.0, but in SQL2K you could create a function called...

I would agree that a copy of the data is better, but sometimes not practical. I think the read only linked server is not bad, but maybe unworkable depending on...

DTS started with SQL 7. Running the SQL2K setup should give you the option to upgrade. I did the upgrade from 6.5 to 7.0 using the MS wizard, worked fine....

Hi Percival,

If you post what you have, we'll try to help. What you're trying to do is pretty straight forward I think, something like this:

Create proc usp_DoSomething as

--Sample proc to...

Clustering or some type of load balancing, or even log shipping/replication are ways to avoid the eggs in one basket situation. My main production stuff runs on a 8 way...

I use the MS Visual Installer that generates MSI packages. It parses the project file to find the dependencies - why figure it out when it can?:-) Unless you need...

Karen, basically there are only a few things you CAN'T be doing during a backup, like the ones in this list! I would suggest just trying again - if you...

Steve, you have links to any? We'll have to see what we can find and put in the FAQ maybe, not an uncommon question.

Why not the answer you expected?

For those who may be interested, try this link: http://www.microsoft.com/certpartner/

Andy

Lots of servers is a lot of hassle in my opinion. Hard to justify in cost as well. You have to look at HOW you'll be growing. Just more data?...

I'd have to look to find the table name, but I KNOW Access stores the workstation ID for linked tables in a system table. I'll try to find time to...

Two premium cert holders needed to make the cut to be a bottom level solution provider. It's $1500 a year, you get 5 Visual Studio development licenses (worth about $2k...

Interesing. Have you considered log shipping or replication as an alternative? For once a day, snapshot replication would work well.

Andy

Please send us any suggest you have for topics (post here, or email us directly). We gauge articles by the hits of course, but also by the amount of feedback...