Hi all, Here is an interesting OT for you. Is there any way to restrict how much bandwidth, how many rows, or how high a priority a user has when connecting to a MSSQL2K server? 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. Thanks, Steve Steve Durette 586-466-7654 [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
