hmmm, I have run this twice an hour apart and the results are always 0 in every cell.

Last n minutes range Avg SQL CPU Min SQL CPU Max SQL CPU

10 0 0 0

30 0 0 0

60 0 0 0

120 0 0 0

240 0 0 0

Yes, that fixed the problem. Sorry to waste everyone's time on such a stupid mistake in the copy/paste.

But.... for each table there seem to be double entries with different values...

I did that and got the same error.

I retyped everything and still got the same error.

This is what I typed in:

SCHEMA_NAME(o.schema_id) + ',' + OBJECT_NAME(p.object_id) AS name,

...

I literally copied and pasted the code verbatim from your post as a new query on the database I wanted to get the results on.

Does it work on an entire...

The same thing.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near 'o'.

I'm trying this with sqlserver 2012

Please excuse my ignorance.

I need to change this how?

I get the error

Incorrect syntax near 'o'.

I tried changing SCHEMA_NAME to the name of the schema for the particular database. That...

I have the opposite problem. I have a user and I want to to be dbo. sqlserver 2008 R2

The user is in the administrator's group in localmachine\username.

I want this...

How does this article

http://support.microsoft.com/kb/304101

fit into the discussion for those of us with databases over 160 gig? The third party backup software is choking on that database in windows 2003/...