SQL Server Workgroup Edition

Technical Article

RE: Auction and table locking

  • Reply

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 = […]

2003-05-29

1 reads

Technical Article

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

  • Reply

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

2003-05-14

1 reads

Blogs

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Things to look out for while TDE is encrypting existing data

By

Monitoring for Problems The encryption of your existing data occurs as a background process...

Read the latest Blogs

Forums

Perhaps the biggest drawback of this type fifa 23

By anqilan456

Perhaps the biggest drawback of this type of formation is that two strikers will...

Adam Sandler film for every Madden NFL 23 player

By anqilan456

In Goodell's announcement on domestic violence earlier in the week: A few of the...

what are the best books to become a SQL developer?

By vpmaciel

what are the best books to become a SQL developer?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers