Thanks Jack

that is probably the issue

have not dropped any databases this month

have disabled some though

jim

ok Brandie

thanks for your input

jim

hi jack

i am trying to use your script and have run it on three servers. All i am getting is 8227 object types

which designate "(User-defined) Table". I do not see...

Hi Brandie

you know what i did was replied to OLDHAND where i stated the SP3.

My bad ..

as far as the Maint Plans

I just changed several tasks

and did some...

Brandie

Your previous question(s) were answered above but I will add it again as well as the other requests:

OS:

Microsoft Windows Server 2003 R2

Enterprise x64 Edition

Service Pack 2

Quad-Core AMD Opteron

Processor 2356

2.30 GHz...

H IBrandie

right-clicking on

Sql server management studio in the Windows Task Bar

DID NOT WORK for me doing these twp tasks

made several MP changes and saved (most saved without busy...

Hi Brandie

have not tried it yet

let me see and get back to you

Jim

Thanks Everyone for the assist

Jim

Hi Brandie

I am on SP3

Jim

Thanks WayneS

Jim

Thanks Jeff

will take a look

Jim

HI Drew

that will work

but how do i concantenate it to the string in @subject=

if my @@SERVERNAME is NSAB-SS73-ORA-N

then

I want it to look like this:

NSAB-SS73-ORA-N Test - DBCC Check...

Sorry Guys

I should have done that

Here is what I found, where I found it and what I did:

Problem :

Error happens when expirydate is met in Maint Plan

You will not be...

H iJeffrey

yes you would think that escpecially after i have researched the issue

I am on SQL Server 2005 Developer 64-bit 9.00.4053.00 SP3

I was able to find...

Thanks Derrick

thought i was getting goofey for a minute there

no problem

appreciate you taking the time

Jim