Clark,

Thanks for the response. I checked and broker was enabled, the domain account was able to query WMI and the instance is not a cluster. What I ended up doing...

Thanks for taking the time to share this.

I am having problems setting up the alert. I get this error:

The @wmi_query could not be executed in the @wmi_namespace provided. Verify that...

Nice script. Thanks for taking the time to share. I ran into one problem though. I get this error:

Msg 213, Level 16, State 7, Procedure sp_helpuser, Line 250

Insert Error: Column...

Great script! Thanks for postingit. One minor change I would make would be to change the subquery to resctrict the database id to less than 5.

I ended up with 2...

I also had the same problem as Phil-94129 but after communicating with Theo (thanks Theo) and trying several suggestions I found that I only had this download problem using Internet...

Thanks for taking the time and effort to share this script with us. I downloaded the file from your link for the sample Excel file but the zip file that...

Charles,

Thanks for taking the effort to create and share this script. I ran into a problem where column names contained special characters or spaces. They would then be reported in...

Great script. However I would get this error on some of my databases:

Msg 15009, Level 16, State 1, Procedure sp_spaceused, Line 62

The object 'tbl_Mine' does not exist in database 'Test'...

Rudy,

Thanks for sharing this excellent script. I ran into one small issue and got this error:

Msg 15281, Level 16, State 1, Procedure sysmail_help_status_sp, Line 0

SQL Server blocked access to procedure...

Thanks Monte. This proc was just what I needed today.

If you decide you do NOT want to restict this to the current database you could change

OBJECT_NAME(objectid,) Name to:

OBJECT_NAME(b.objectid,b.dbid) Name

Lee

Forgive the sparse post. I was referring to the use of [sys].[dm_exec_procedure_stats] as a better approach but it does require SQL Server 2008.

Agreed that this is better but it requires SQL 2008.

Lee

Excellent script. However, I don't understand the reason for the test in:

IF CAST(LEFT(CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR),1) AS INT)>8

I understand that the ComputerNamePhysicalNetBIOS property did not exist prior tp SQL 2000...

Excellent script! Thanks. This is very useful.

Lee