Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 6,105 total)

  • RE: sysperfinfo contains negative value

    Found this:

    BUG: sysperfinfo counters are not time-adjusted (555064)

    I'm wondering if you're getting these results because sysperfinfo has the raw values.

  • RE: programatically find out is there''''s a SQL installation

    Default Instance:

    Install Path: HKLM\Software\Microsoft\MSSQLServer\Setup\SQLPath

    If they are defined:

    Default Data File Path: HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\DefaultData

    Default Log File Path: HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\DefaultLog

    Named Instance:

    Install Path: HKLM\Software\Microsoft\Microsoft SQL Server\<Instance Name>\Setup\SQLPath

    If they are defined:

    Default Data File Path: HKLM\Software\Microsoft\Microsoft SQL Server\<Instance...

  • RE: Scripting Security

    The code itself is in the syscomments table. Therefore, if public doesn't have access to that table, they can't see the code by doing a direct select. However, there are...

  • RE: Scripting Security

    Short answer is nothing should happen on removing syscomments access, except if you have to call in support you'll have to add it back. I wrote this all up for...

  • RE: sysdepends table doesn''''t populate

    The case you've cited is the main one. Is there a reason why the stored procedure is being created prior to the objects it references? Perhaps you can re-order the...

  • RE: What autorization is neccesary for Performancemonitor?

    You can access SQL Server counters from inside SQL Server. The sysperfinfo table can be queried for these counters. The following article has the permissions needed to allow access if...

  • RE: Scripting Security

    Unfortunately, there's not a whole lot you can do if the user has access to the database. By default, the public role has SELECT permissions against both sysobjects and syscomments....

  • RE: How does a p[ower faulire affect a SQL Server database?

    A power failure can be trouble if the server was doing a write operation, etc. However, this doesn't just affect SQL Server. It affects the OS as well.

  • RE: Monitoring Disk Space

    I don't believe WhatsUp does disk space monitoring, but I could be wrong. The other products I mentioned do. Also, you could throw together a quick script to monitor disk...

  • RE: Monitoring Disk Space

    What other monitoring tools do you have in your environment? BindView? Argent? HP's SIM?

  • RE: is there away not not see system objects when working in EM

    Sure, but it means modifying how you have the server registered. Do the following:

    1) In EM, right-click on the Server.

    2) Choose Edit SQL Server Registration Properties... from the pop-up menu.

    3)...

  • RE: SQL Alert

    Performance Monitor aka PerfMon

  • RE: SQL Alert

    Without resorting to some sort of scripting, no. SQL Server doesn't keep track of any performance counters except those related directly to SQL Server (which you'll find in the sysperfinfo...

  • RE: Cannot add user from Active Directory

    I seem to remember a KB article that covered this exact situation however I'm having no success at finding it. There are issues with SQL Servers on DCs but I...

  • RE: SQL Alert

    It's probably easier to do this using an Alert in Performance Monitor.

Viewing 15 posts - 2,791 through 2,805 (of 6,105 total)