http://sqlserver.ro/forums/16/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/7093.aspxTue, 05 May 2009 10:14:09 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7093xmldeveloper0http://sqlserver.ro/forums/thread/7093.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7093Pe langa solutia eleganta propusa de Razvan, o solutie ce nu implica folosirea de cod este "Pausing the SQL Server Service":<br><BLOCKQUOTE><div><br>When you pause an instance of Microsoft SQL Server, users that are connected to the server can finish tasks, but new connections are not allowed. For example, you can pause an instance of SQL Server for a few minutes and send a shutdown message to connected users before shutting it down. You can also resume a SQL Server service. <br></div></BLOCKQUOTE><br>http://sqlserver.ro/forums/thread/7089.aspxMon, 04 May 2009 08:37:04 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7089rsocol0http://sqlserver.ro/forums/thread/7089.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7089Cu un trigger de login care interzice accesul (eventual, pe baza unei configurari dintr-o tabela). <br /> <br />Vezi: <br /><a href="http://technet.microsoft.com/en-us/library/bb326598(SQL.90).aspx">http://technet.microsoft.com/en-us/library/bb326598(SQL.90).aspx</a> <br /><a href="http://www.simple-talk.com/sql/sql-server-2005/logon-triggers/">http://www.simple-talk.com/sql/sql-server-2005/logon-triggers/</a> <br /> <br />Razvanhttp://sqlserver.ro/forums/thread/7088.aspxMon, 04 May 2009 08:28:03 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:7088Alex0http://sqlserver.ro/forums/thread/7088.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=16&PostID=7088<P>salut, cum pot bloca accesul userilor de sql pe o baza de date in sql server 2005</P> <P>dar nu single user mode....adica cei existenti (conectati deja) sa-si poata continua treaba pana la final dar sa nu mai permita noi conexiuni pe db</P> <P>multumesc</P> <P>alex.</P>