The developer edition of SQL Server 2000 supports clustering. If your company hasn't provided you with a copy, buy one, they're very inexpensive. For a robust production system you need...

This was a trick question 🙂 The snapshot agent does not apply snapshots, it generates them. Snapshots are applied by the distribution or merge agent.

The answer was a bit too brief 🙂 RebuildM rebuilds all the system datbases. It's not just logins you have to add back (and sync with your users). You have...

You don't need to use the database name, but without the owner name the cached object is only reused after SQL Server takes some additional steps to verify that the...

Why do you need to lock down access through Query Analyzer/Enterprise Manager? If it's to prevent users doing things outside the application, then that's exactly what user roles are designed...

Unless I misunderstand your wish, SQL Server already does what you want. It can use an index forward or backward.

Cindy Gross

http://cindygross.tripod.com