Sorry for the late response to your request to know which code set I used. The answer is sorry none, part of process are in ultra secure enviroments and server...

Thank you everyone for your fast response and code posting, now with a quit afternoon(not likely). I can get this loaded throughout my universe.

GRANT VIEW ANY DATABASE TO <login>;

Gentlemen,

Yes the users as premission. I set it up in this fashion.

DatabaseRole: EXFunctionRole

Iside that role the secrables associate to a table-valued functions

Grant Alter

Grant Control

Grant References

Grant Select

Grant View Defention

Then the...

I to just Ran into the very wierd error message. I sent of the dump and all related filed. The answers is move to SP3 + Cumulative update 5....

Got It

DECLARE @command VARCHAR(5000);

SELECT @command = 'Use ['+ '?'+ ']

Select @@servername AS ServerName,

CAST(sysfiles.size /128.0 AS int) AS FileSizeMB,

sysfiles.name AS LogicalFileName,

sysfiles.filename AS PhysicalFileName,

CONVERT (sysname, DATABASEPROPERTYEX( ''?'' , ''status'' )) AS...

Wrong posting my bad

The is from the logs in the active node of the cluster, there was no logs on the passive cluster at all.

Product ...

Fixed it. It looks like the SQL Server Agent was hung.

DUHHH

OPP