Welcome to Sign in | Help
in Search

pot bloca accesul pe sql server 2005?

Last post 05-05-2009, 1:14 PM by xmldeveloper. 2 replies.
Sort Posts: Previous Next
  •  05-04-2009, 11:28 AM 7088

    pot bloca accesul pe sql server 2005?

    salut, cum pot bloca accesul userilor de sql pe o baza de date in sql server 2005

    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

    multumesc

    alex.

  •  05-04-2009, 11:37 AM 7089 in reply to 7088

    Re: pot bloca accesul pe sql server 2005?

    Cu un trigger de login care interzice accesul (eventual, pe baza unei configurari dintr-o tabela).

    Vezi:
    http://technet.microsoft.com/en-us/library/bb326598(SQL.90).aspx
    http://www.simple-talk.com/sql/sql-server-2005/logon-triggers/

    Razvan
  •  05-05-2009, 1:14 PM 7093 in reply to 7089

    Re: pot bloca accesul pe sql server 2005?

    Pe langa solutia eleganta propusa de Razvan, o solutie ce nu implica folosirea de cod este "Pausing the SQL Server Service":

    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.


    Cristian Andrei Lefter, SQL Server MVP
    MCT, MCSA, MCDBA, MCAD, MCSD .NET,
    MCTS, MCITP - Database Administrator SQL Server 2005
    http://sqlserver.ro
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems