Viewing 15 posts - 2,791 through 2,805 (of 6,105 total)
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.
July 26, 2005 at 9:55 pm
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...
July 26, 2005 at 9:42 pm
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...
July 26, 2005 at 8:36 pm
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...
July 26, 2005 at 6:47 pm
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...
July 26, 2005 at 6:37 pm
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...
July 26, 2005 at 6:35 pm
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....
July 26, 2005 at 6:18 pm
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.
July 26, 2005 at 6:14 pm
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...
July 26, 2005 at 6:12 pm
What other monitoring tools do you have in your environment? BindView? Argent? HP's SIM?
July 26, 2005 at 2:23 pm
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)...
July 26, 2005 at 2:09 pm
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...
July 26, 2005 at 12:08 pm
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...
July 26, 2005 at 10:29 am
It's probably easier to do this using an Alert in Performance Monitor.
July 26, 2005 at 10:20 am
Viewing 15 posts - 2,791 through 2,805 (of 6,105 total)