Thanks for the feedback.

Glad you've solved it.

check out http://www.sqldts.com.

There are a number of scenario's that may apply.

So there is the problem.

I didn't encounter such a situation yet.

What's the sql-version/sp / hf ?

Did you run the @Cmd in a cmd-box for test ?

I guess it gives a popup at serverside

Is this what you're looking for ?

I prefer using Left outerjoins because I find them to be more readable.

I also like using objectaliases...

your problem object :

select object_name(71577680)

Your problem index :

Declare @Name varchar(128)

select @Name = object_name(71577680)

exec sp_helpindex @Objname = @Name

I would run :

DBCC CHECKDB ( 'yourdb')   WITH ALL_ERRORMSGS 

check BOL for...

there are # of ways to do this. This is one of them :

how about : (#tmp1 is your table)

create table #tmp1 (id...

I switch all db's to "bulk logged" in the first step of the maintenance job (dbreindex/indexdefrag).

then perform maintenance

then switch back to "full" when needed

'create date last month...' can be when you alter the table e.g. using EM. It has the tendency to use a ddl sequence of rename - create - insert -...

that way your usp_ only returns a value.

use raiserror of you want to have an error raised and set the jobstep's "on error" action to "quit job with failure"

Check BOL.

e.g....

SQL2005 ? or wrong forumgroup ?

SQL2000 : make sure your sqlserver / sqlagent serviceaccout has got the needed authority for your network-shares.

This job...

Try to alias the tables and you'll find your problem easy so solve.

select MyAlias.mycol,...

from myschema.myverymeaninglesstablenamefartolongtoread MyAlias

...

if you still cannot find it, post...

how about using a udf ?

read : http://www.sqlservercentral.com/scripts/contributions/592.asp

I also backup master and msdb everytime a scheduled backup is taken (full/diff/log) of any userdb.

Can you force a table-scan on all tables of your db ?

select * from yourtable

Why : so no indexes (except clusterd) are used and only datapages are accessed. This way you...