Set up a SQL Express server for him with nightly (?) replication, when it won't affect performance so much. Let him beat the crap out of that to his heart's content. Bonus points if you put it on his workstation, so he's dragging down his own workstation.
--Ben "don't mess with my servers" Doom DURETTE, STEVEN J (ATTASIAIT) wrote: > 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:291877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
