Maximum Capacity

Workgroup Edition features

Workgroup Edition features

Workgroup Edition

RE: Auction and table locking

quote: Two users could be setting the flag to locked at the same time, they would both read the flag as being zeroed, set it then try to update You can update/attempt to update the row in a single statement, then check the result: update bid_table set lock_bit = 1, lock_user = @Current_User, lock_time = […]

RE: Error 17052: SQL Server has been optimized for 8

This is personal, i.e. a desktop edition. It is not for lots of people to connect to and run queries. It's mainly for developers working on their machine. You need to install the standard or enterprise edition if you need more connections running at once. Steve Jones sjones@sqlservercentral.com http://www.sqlservercentral.com/columnists/sjones www.dkranch.net

RE: Error 17052: SQL Server has been optimized for 8

Sure can! Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 3)

RE: How to get sql server agent running

What program is this that allowed you to install sqlagent.exe as a service?