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

Depending on how long ago tempdb physically grew you may be able to query the default trace file if you have it enable. It is enabled by default. It captures...

This code will tell you if the default trace is enabled:

SELECT * FROM sys.configurations WHERE configuration_id = 1568 AND value_in_use = 1

If it IS enabled then this code will tell...

John,

Thank you for an excellent and very useful script.

Lee

It's not the code. I have run into this problem a few times when I copy code from this site. I seems that some Unicode characters get inserted in the...

Great script. Very useful.

I made one small change to the Linked Server section though. This eliminates displaying the current SQL instance from showing up as a linked server.

SELECT ...

Is this what you are looking for:

SELECT

log.name AS [Name],

ISNULL(log.default_language_name,N'') AS [Language],

l.alias AS [LanguageAlias],

ISNULL(log.default_database_name, N'') AS [DefaultDatabase],

CAST(CASE sp.state WHEN N'D' THEN 1 ELSE 0 END AS bit) AS [DenyWindowsLogin],

CASE WHEN N'U'...

Mystery Solved!

The odd traces are being created by our monitoring software, Foglight for SQL Server (Quest Software).

Thanks again for everyone's help.

Thanks for the quick response. It looks like they are tracing deadlock graph, event id 148. No tsure why they are there since trace flag 1222 is not enabled....

Wow! Thanks Lowell. Excellent procedure. I have no idea where the trace originated from but it looks like it is for deadlocks. Here is the output from your excellent proc,...

I found that if I included 'password', 'PASSWORD', and 'Password' in the @WeakPwdList table variable the script would not return all users with those passwords. The fix was to use...

Ellen,

Thank you, thank you, thank you!! This was driving me nuts. What forum did you find this on?

Lee