Thanks, this worked like a charm:

TSQL -- select count(*) from empMstr = 12073 (correct)

Enterprise Mgr -- double click table empMstr count = 12048(incorrect.

Is that a better picture??

Hooray, the sp works.  Thanks!! charger

I'll have to ask my network administrator for our organizations SMTP server information? Where do I enter it? I'll also have to ask if our SMTP server is set up to...

I created the sp and ran it with:

declare @Body varchar(4000)

   select @Body = 'This is a Test Message'

   exec sp_send_cdosysmail 'thomasj@ministryhealth.org','thomasj@ministryhealth.org','Test of CDOSYS',@Body

The results of the sp are No...

Ok so ughhh to SQL Server Mail!!  What I need to do is be able to send an email when a certain job fails.  And also I need to send...

Ok, Homebrew thanks.  We have installed SP3.  The reason I wanted to know was that when I try to test the operators properties i get this message:Error 22022: SQLServerAgent Error...

Thanks so much, one of our vendors is changing a column, which appears in many tables.  Guess what?  They forgot to do it in 2 tables!!.  Charger.  (By the way...

Thanks to both Dan and SQLBill.

SQLBill I tried sp_updatestats, it did not work I even did it with the 'resample' param it still did not work. Perhaps I did something...

I agree with you Angela and I have been doing some reading and testing.  My conclusion is this.  I removed my login from one of our servers and I was...

Ok, but then what is their default role?  What can they do?  I am guessing that if I want to restrict or grant access, I must create a login for...

Thanks, I appreciate it. I am a converted Oracle DBA. This is a snap in Oracle.