I actually had switched the inners to left/right perspectively but ran it in the context of the whole script where there was another statement further down taking the results of...

Kurt,

Thanks for the taking to the time to explain.  It DOES actually make sense when you put it like that. I guess the biggest problem I have when it comes...

Ok, so perhaps the stupid question of the moment but I'll ask.

Why go thru all the trouble of a customized process to evaluate and rebuild/reorganize indexes vs. the standard maintenance...

Actually, the stats are not recently updated and the indexes are fragmented ALOT.

This is day 6 at a new job so I'm finding all kinds of things to complain to...

Ok, so from the laymans point of view (ie. my boss/supervisor), if I have 122 indexes in a particular database that is used on a daily basis with defragmentation all...

it still says that it is an invalid column name in the second case statement.

I'm getting an error msg on the version using the format file;

Bulk Insert fails. Column is too long in the data file for row 1, column 13. Make sure...

Awesome, exactly what I needed

thanks,

Chris

Hi there,

Thanks for the reply but in looking at the code I remember that I already had this argument with my boss.  He basically wants one line by intMasterAcctID but...

Bingo!  thats it exactlY!

Thanks!

Chris

(sorry I always leave off the specifics)

MSSQL 2000, sp3a

Basically the maint job was created via. wizard for creating maint jobs.

It is turned on, but then its turned on for all of them as auto growth.  I can understand that it COULD grow to huge sizes I just cannot understand...

heh, thanks

Tried just about every option EXCEPT that one.

EDIT:  Still having a problem though... the database is no longer marked for replication however...

Right!  The only way I could find to determine if a job was running or not was to check the sysjobhistory table and check on its status.  Its either 'In...

Greetings,

I have an ASP process that I use to do replication to a tablet and I needed to find out when the job was finished so I knew when I...