Welcome to Sign in | Help

Re: pot bloca accesul pe sql server 2005?

  •  05-05-2009, 1:14 PM

    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 Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems