I am using xp_SMTP_Sendmail. It works great.

The following is code that creates a job that check through every other production job and emails you if one of them failed....

This really is a warning or information statement ONLY indicating that somone

changed the sp_configure option

There really is not any ERROR encountered

You can run RECONIFUGRE in Query Analyzer.

If you...

Did you actually get this to work? I tried and I always get back a blank row from this function whereas DBCC INPUTBUFFER giver me valid info. Maybe...

Frank is right. I got this same error a while back. For more detailed help see: http://support.microsoft.com/default.aspx?scid=kb;en-u-s;q274463

I liked the article as it clearly put forward the concept. I'm not sure I see a business need at this time but it is an idea I'll keep...

Doing a Google search on SQL SERVER T-SQL Debugging shows a number of problems depending on the service pack and configuration of you install. As an example if you...

to set the system wide default fill factor try:

EXEC sp_configure -- checks current settings

-- to change system wide fill factor

EXEC sp_configure 'fill factor (%)' ,0

RECONFIGURE

-- verifies fill factor changed

EXEC...

Microsoft allows you to credit thoses examd for more than i certification. So yes you now have 2 of the 4 exams needed for MCDBA. With Yukon coming...

How about Display Estimated Execution Plan in Query Analyzer (CNTL L)? If the syntax is incorrect this will give you an error.

I used the Microsoft Readiness Review books which are good for general learning about SQL Server but te exam is different. If you are already fluent in SQL Server...

I've been running sp3a on 4 production servers for several weeks now. The machines have all be restarted more than once. I've had no issues with respect to...