Balmukund,

Thanks for your reply.

Here are results from one of the slow dbs.

-----------

82

(1 row(s) affected)

-----------

3403

(1 row(s) affected)

I was just pressing the 'user mapping' page - which would then bring up a listing of databases.  So I wasn't running it on a particular db.

Duration ranged between 0...

Thanks - Much appreciated.  Saw that article, but wasn't sure it would apply to 2005. 

Thanks for your reply Elliot. I tried some others, but no luck.  I also used the microsoft wmi tools and the wmi object explorer to see if the values were actually...

I get this same error.  MS has one thread in msdn forums:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=342946&SiteID=1

The MS poster says it's a bug - and also that it results from moving the msdb incorrectly...

You should change the table design if possible - it's got some problems as you can probably tell from having to write this query.

The steps have "Run as SQL Service Account"

I think I was a little unclear.

We had the user domain\sam as the original owner.  It was then changed to domain\sqlagent.  We then deleted domain\sam.  The job started getting errors complaining...

Vipal - this definitely helps, illuminates some techniques I did not know about (which is was I was hoping for!)

do you execute your command with xp_cmdshell?

thanks!

It's really only between LA and Phoenix, so it shouldn't be to hard.  Thanks for the info - just wondered of there was a clever way to do it that...

Will sp_msforeachdb @command1='dbcc updateusage (''?'')' cause log growth?

Thanks Carl and Bill - sounds like that is the solution.

here is an article:

http://www.sqlteam.com/item.asp?ItemID=16512

Seems like this started to work - just not instantly, it took some interval of time from me seeing entries in my client trace before i saw it in the...

sp_trace_setfilter [ @traceid = ] trace_id

    , [ @columnid = ] column_id

    , [ @logical_operator = ] logical_operator

    , [ @comparison_operator = ] comparison_operator

    , [ @value = ] value

>>I think you...