Ninja I just discovered that flag_? is indexed but not Date...also the sulotion you suggested would work but again without a (flag_?, date) index I'm not sure how much gain...

Delete the job and recreate it and it should work.

To troubleshoot the issue I will check the user privelage under which the job runs just to be sure the user...

I figured out the problem - thanks to all who took a look.

So basically the error above is generically thrown due to permission issues when installing SQL 2008 from...

Thanks for your advise - really appreciated.

And yes I read your article and have successfully resolved those errors.

Thanks,

Gail, thanks for your time and input. I have a meeting with my boss on Friday and I will present both recommendations - I will keep you posted. Mainwhile I...

It is a SQL 2005 Server

The DB is an upgraded DB from SQL 2000

The type for syskeys is SYSTEM_TABLE

My understanding is that CHECKDB was not running in the past

There...

Gail, thanks for taking a look. Below is the information you requested:

DBCC CHECKDB (Deployment_09_24_09) WITH NO_INFOMSGS, ALL_ERRORMSGS

Msg 8992, Level 16, State 1, Line 3

Check Catalog Msg 3854, State 1: Attribute...

Bradley,

Thanks a million for the links - great pointers!!

Yes Paul is "de MAN" on this topic and I should have visited his blog before posting. I will implement some of...

Is the mail server available? Is the SMTP authentication valid?

Nick,

It sounds like you may need to define a parameter for your action to return the specific values you need. You are using a Report Action and on the Action...

Now its working. I basically dropped the profile, reinstalled outlook and added a new profile.

Thanks for your help.

Nope. Its connected to POP3/SMPT.

Elliot I think the issue is with outlook. I was able to get the profile to show in the "mail profile" drop down on SQL Agent properties dialog page. When...

Elliot thanks for the response. I actaully am doing exactly that. I have configured SQL mail in the past but for the love of me I can't figure out what...

Do you have other instances of SQL Server installed? SQL2005, Express? Please verify you're connecting to the right instance.

Thanks