Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-11 : 09:48:56
|
| jfrost10 writes "Hey guys. I'm downloading the online book now, but if its anything like the help in SQL Server, it won't have what I'm looking for. Here are my development specs:SQL Server 2000Windows XPASP.NET developmentWe've come up with our own locking scheme. What we do is add a field to certain tables called Locked. When a user accesses a record to edit, their username is written to the Locked field, otherwise its null. However, if a user's computer freezes up, or they leave the page we need a way to reset all those values so others can access that record.So here's what we've come up with: a stored procedure that will go through each table looking to see if the Locked column can be found. If it is, it will search out for any fields that match the userid thats passed and update it to null. Then it will continue on to the next table.We're not sure though how to access the table collection of the database. The select, update, blah blah blah part of the Transact-SQL code we can figure out, its just actually going through the colletion that we're not sure of.Thanks in advance guys,Jack" |
|
|
|
|
|
Tables Collection