Home Forums SQL Server 2005 SQL Server 2005 Security How do I limit user access to certain time of day RE: How do I limit user access to certain time of day

  • August 5, 2008 at 3:32 am

    #853070

    You can simply use SET QUERY_GOVERNOR_COST_LIMIT in the login trigger. You can check the currenttime of the server in the trigger and if it falls in your peak hours, set the option.

    This option is used to specify an upper limit on the time period in which a query can run. Query cost refers to the estimated elapsed time, in seconds, required to complete a query on a specific hardware configuration.

    See the following link For details...

    http://msdn.microsoft.com/en-us/library/ms190419.aspx">

    http://msdn.microsoft.com/en-us/library/ms190419.aspx

    Atif Sheikh

    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Sometimes, winning is not an issue but trying.
    You can check my BLOG     [font="Arial Black"]here[/font][/url][/right]