I don't think there is any easy way if you are talking about preventing multiple logins from a program like SQL Server Management Studio.
I think the latest version of SQL Server, either 2005 sp2 or 2008 lets you attach triggers to the login process. So in the trigger you could check if the user is already logged in and abort the process with an error message if that is the case. -Mike Chabot On Thu, May 15, 2008 at 6:07 PM, Bruce Sorge <[EMAIL PROTECTED]> wrote: > Hello all, > Is there a way to prevent simultaneous logins on a SQL Server (2K5)? I > am not talking about preventing simultaneous web application logins > using DB authentication, but rather the server itself. > > > Thanks, > > Bruce > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3076 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
