I differ with your statement. From BOL (Update Jan 2004)

Note  If neither GLOBAL or LOCAL is specified, the default is controlled by the setting of the default to local cursor...

These are the parameters :

EXEC xp_sqlagent_enum_jobs <is sysadmin (0 or 1)>, <job owner name> [, <job id>]

HTH

Fact tables tend to be a lot bigger than that but actually it all depend on the application so your case may be ok. To estimate the size you need...

mark baekdal  posted: >>Unique constraints do not allow nulls, <<

Incorrect, Uinque Constraints allow for ONE NULL

Kimberly,

Again, a Table Datatype variables are NOT affected by transaction rollbacks, so it really does not matter and btw table variables are not a memory-only always  check this out 

HTH

I've seen the Header-Footer idea implemented before but with no need for osql if you save the results on a table DATATYPE it won't be involved in any transaction rollback and...

besides constraints can be disabled indexes can't (on 2005 you are able to disable indexes, that's cool )

HTH

1. login the machine with the SQLAgent service Account.

2. Open the MS Outlook Profile and Follow the instructions on the link I posted earlier on how to remove it!

HTH

are those Jobs sending email at the end?

are those Jobs Email Profile using the Address book?

If the answer is yes then my post applies even intermitent because it all depends...

Well, You shouldn't

create table mytable ( i int, dta image)

insert into myTable (i , dta) values( 1 , 'TESTING IMAGE')

select i, dta...

the EXISTS Clause NEVER looks at the field List

Check this

HTH