The article is interesting. I have an issue with the code.

I copied it to my clipboard.

When I pasted it in to a new query it looks like this:

I even pasted...

Carl,

I need to use your suggestions, for firewall reasons, but my environment is more current.

I have an active/active cluster for sql. The 2 servers in the...

Rudy,

You should edit you post so the code is multiple lines. One long line is diffucult to read.

Here is a multi line version.

PRINT 'Active Directory Query...

I like the script, it will be useful.

I have added the following to your code:

DECLARE

@sql VARCHAR(2048)

,@sort INT

DECLARE tmp CURSOR FOR...

I moved them so they were all in the same location and the patch applied.

Thanks for the help.

I have not renamed the file. It is in the original location from installing SQL (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

I have moved the system databases to F:\MSSQL_Data. and the logs to...

I am getting this error, from Summary.txt, while trying to install KB970892:

**********************************************************************************

Product Installation Status

Product ...

Bruc0Blachf0rd-780736 ,

Do not pass dbo. as part of the table name.

I am using SQL Server 2005 Enterprise Edition (x64) and getting the following errors:

Msg 102, Level 15, State 1, Line 11

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Line...

Here is a cleaned up set of code.

CREATE FUNCTION [dbo].[fn_CalculateHeapSize]

(

@Tablename VARCHAR(100)

)

RETURNS VARCHAR(100)

AS BEGIN

-- Calculate the space used...

After cleaning up the text of the functions so it would create them, the function fn_GetTableSize only returns NULL.

I changed the function so the calculations handle a NULL return.

ALTER...

I ran into similar problems getting the accountexpires value.

I created the following function:

CREATE FUNCTION [dbo].[UTC2date] (@numSeconds BIGINT)

RETURNS DATETIME

AS BEGIN

DECLARE @TimeBias AS INT

EXEC...

I run the following query and it will return 17,000 plus records:

SELECT

sAMAccountName

,DistinguishedName

,dbo.UTC2date(accountExpires)

,employeeID

,cn

FROM

...

Mark,

You may need to increase the [Object] field or the [Column] field in table #t.

It will depend on the length of the names you use for your objects and columns.

Nice script.

But I had to increase the size of a2 to 75 to avoid truncation errors on SQL 2005.

Here is an updated script. I changed the names of the fields...