I think that objectproperty() can also give this information out.

Works for me.

Ya Sushila beat you to the punch .

Thanx.

There are a few advantages of being rich too .

Who's that guy?

Here's an exemple you can play with (this is for top 90%):

SELECT O.XType

--, count(*) AS TotalHits_Found

, O.name

, (SELECT CEILING(COUNT(*) * 0.9) FROM dbo.SysObjects O4 WHERE O4.XType = O.XType)...

Unfortunaltely not .

Wow that's out of my knowledge... I'll let the "network" dbas handle this one.

Ya, those file are locked, I mean DEAD locked. You can't even copy them file they are attached. Maybe that cause some other side effects as this one.

Alright, see ya monday.

Hmm, what do you get if yo run Select @@ServerName on that server?

Why are you entering data manually?

I'd say you're fine... Seems you have all systems go.

I vote charity .