Thank you Lester! I have several with ndf files as well....will it work for those too?? I will look it over tomorrow!! thanks again! 😀

Wow!!! That is awesome! Thank you for this and I will hopefully get to try this over the weekend! Thank you so much!

thank you both for such wonderful answers to my question!! I appreciate your help!!!

No, I will hold that valuable info in my memory banks! I had already deleted out the old MP and re-created them using a login that won't expire.....

Thank you Sugesh....Scott and I will keep that in mind for future use!! Sure easier than recreating the Maint Plans!!

Thanks Scott for the insight. I tried to change the owner, which it lets you do, but somehow, somewhere your original owner/login credentials must remain, because it didn't recognize...

thanks Lucky....I submitted another question, but it didnt post. My computer is having issues today!

Anyhow, will you give me an example of what you mean....you are totally understanding what...

ok, it posted without my ok...and I wasn't finished...LOL

anyhow, you get the idea...

when I try to set the variables, SQL tells me that I cannot do this. I would...

thank you everyone!! I am off to read articles!!

bummer for me!:cool:

Is there a script out that that you can run against OLD database(or server) and re-run against NEWLY moved database(or server) to be sure that all objects made the move?...

thanks Paul...I will check this out!

I don't think so (better not be) but I will check for sure! Thanks!!

ok, I deleted out the PLAN, started over and made sure that there wasn't any option checked that would need to lock the db. NONE, ZIP. I still...

I am still playing with this. All my issues that I keep coming up against have to do with the Integrity Check during the Maint Plan. I have...