This error stated in the link has to do with an IMPORTED maintenance plan. I am creating a new maintenance plan from the wizard. It is happening on...

Thank you!! I will go see if I have such option checked and try again~

Great idea!! I just found it odd that you couldnt set the time for the transaction log backup like you could in 2000... Thanks for your help!

thank you Chris!

I changed things around (realizing that if exists brings back a T or F)

and had this in place:

if @Mode = 'WEB'

begin

select

@EntityID = pro.ProviderEntityID,

...

...and where can I find Nigel Rivett's examples? Here in the forum?

Thank you everybody for all your help and hints here! I am taking this all in.........:P

Sweet! This worked!! Now I think all I have to do is convert the time passed in to military time and run this code! Thank you so...

Oh how I wish it were that easy!! LOL... I need to convert it to military time, multiply the hours by 60 to get minutes and then subtract...

thank you!!

OK!! in a quick test this WORKS!!~~~~  I will implement this into my code and test again.  I can't thank you enough!!!!!

In my staging table, the LabDate is a datetime field and the LabTime is a varchar(50) field.

LabDate = 6/11/2004 or 1/21/2007 12:04:00 AM

LabTime = 9:40:24 PM

...thanks!

ok, more testing...more finds:

if I qualify the table and then run the same sp_, it changes it to dbo.  YEAH!!  Then for giggles, I ran the optimization script I am...

ok, back to this project again!! 

I did a test on a qa server db.  I created a simple 2 column table.  the owner was dbo.  I did the sp_changeobjectowner...

Obviously, qatest isn't a member of sysadmins.  Since the tables were named this way, does the optimization script only optimize dbo tables???????

Sorry guys, grasping at straws on this one!!

more info:

the only difference in these tables is that all the others are dbo.tables and these are qatest.tables......but my optimization script doesn't check on that.....