restrict the number of rows to be entered into sql | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

restrict the number of rows to be entered into sql

hey,i am archana. we are creating such a utility that targets to limit the number of users on LAN(local area network)using a particular software.That i mean to say that ,we want to allow only 4 users at a time ,to use a software. if more than 4 useres try to use software,,,it will deny last user untill any user(already using software ,,logs off). we can do so this by creating a text file containing maximum number of users(4) or storing the value in a separate table. But the problem is,,we want to restrict the number of rows to be entered into sql table (only 4 rows to be entereded containg the details of lan users).but we re not able to do so. is that possible through coding or at the time of table designing in sql server 2005 0r 2000.
Please help us properly.
Please avoid duplicate postings!
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19367 —
Frank Kalis
Moderator
Microsoft SQL Server MVP
Webmaster:http://www.insidesql.de
]]>