Viewing 6 posts - 1 through 6 (of 6 total)
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...
August 30, 2005 at 7:07 am
This was a trick question 🙂 The snapshot agent does not apply snapshots, it generates them. Snapshots are applied by the distribution or merge agent.
April 27, 2005 at 5:48 am
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...
April 8, 2005 at 6:18 am
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...
May 10, 2004 at 7:02 am
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...
August 29, 2003 at 7:20 am
Unless I misunderstand your wish, SQL Server already does what you want. It can use an index forward or backward.
Cindy Gross
August 25, 2003 at 7:08 am
Viewing 6 posts - 1 through 6 (of 6 total)