DURETTE, STEVEN J (ATTASIAIT) wrote: > My issue is that we have a user, who for political reasons we can't just > boot out of the db, who we were forced to grant access to our database. > He is using Access XP to connect to our database, he then proceeds to > download two of our largest tables into his access database. He does > this multiple times a day, and each time it takes out Table locks and > all of our pages back up and other users can't access the data. I've > already limited what tables he has access to and what he can do to them > (select only), but I still need a way to put his requests as a low > priority on the database.
Don't: http://en.wikipedia.org/wiki/Priority_inversion What would work better is an upgrade to MS SQL Server 2005 and switching the database to snapshot isolation so that reads don't block writes anymore. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
