SQL Server Performance Forum – Threads Archive
restrict the number of rows to be entered into sqlhey,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!
Microsoft SQL Server MVP