Yes, your script is very nice. I see someone has suggested handling offline database. I think offline, read only, and suspect need to be handled.

Have you updated the...

The statement fails but the table exists within the database. I tried the statement there wtihin the database and it also failed. So I changed SysUsers to sysusers...

No the databases exists and all have a normal status as does each of the databases that returned errors.

Mark

ON 2000 any idea what would cause some of the database checks to fail with:

Msg 208, Level 16, State 1, Line 2

Invalid object name 'ARIS7.dbo.SysUsers'.

Msg 16916, Level 16, State 1,...

Never mind wrong script.

-- Mark D Powell --

Scott, very fine explantion.

-- Mark D Powell --

How can there be a temporary table on start up of an instance? When the instance was shutdown the tempory table would have been eliminated. On restart you...

What EAV should really be called is "unscalable".

While having a table or two in your application that are in EAV format should be fine the programmers who try to build...

The uploaded text is full of gargage characters that will prevent a quick copy and paste from compiling.

Any way to clean up the script.

-- Mark D Powell --

Intering fact that different MS products use different versions of the Unicode standard. Looks like a Right hand not knowing what the Left hand is doing situation, and I...

But the question was on Unicode not UCS-2! SQL Server does not actually support Unicode; it supports UCS-2 which is a limited subset of the Unicode standard. If...

I can't get past the syntax errors. I wish ServerCentral would fix their script upload feature because getting the scripts to work has proven to be a royal pain.

--...

Logically all rows returned by a query should be at the same poiint in time. Without row level versioning this is not possible if concurrent DML is supported. ...

I was unable to find sp_GetErrorDesc in the resouce section. Where should (url) I be looking? A search on the procedure name returned no hits.

-- Mark --

I modified the posted SQL to use Left Joins as suggested and indeed my Link to Oracle now shows up. It was missing before and I had noticed that...