Thank you! I think the step I was missing was the use of the schemas to control the rights! This should work!

What is your version of the database? if you are below 9.00.3050 there is a bug that does not convert intervals correctly. Both the system and the servicemangement studio should...

I am successfully(now) performing backup routines on our SQL 2005 9.0.3050 release x64 machines.... I have the owner of the plans being a sqlservice account with the permissions to run...

What I did was to set up an date that the backup expires in the backup routine for the backups. The transaction logs are 24 hours, the differentials are 7 days...

Great Carl !

I am glad you were able to get the fix to work for the maint plans to work in the correct manner!

Lowry

RATZ! they came out with another hotfix since the one I applied last Thursday!!!  Read what the hotfixes fix and apply what you need, but I bet the 933097 is...

apply kb933508. That is the hotfix that solves maintenance plan issues

http://www.microsoft.com/downloads/details.aspx?FamilyID=e2c358a1-ecc4-4c49-8f65-daa6b7800eec&DisplayLang=en

There are no triggers on the database.

We cannot identify any stored procedure causing the problem. I did try deleting the subscription, the publication. Removing the stored procedures on the...

I have it installed. It works and solved the problem with the days = hours problem.

Try running the Rebuild index as a separate procedure away from the other opimization steps. That is recommended anyways. I schedule the rebuild about a half hour before the other...

I forgot to add that I have also done restores from backups from the earlier versions to onto this new box.

Ok now I understand the issue better. What I am doing in my corporate enviornment is I have three SQL2005 boxes setup. Two Prod boxes are X64 and the test...

Hi, We are running SQL2K5 x64 on X64 bit processors with Win2K3 x64. This takes full advantage of the 64bit processing. Wouldn't putting a X64 bit app on a X32bit...

Thanks for all your support people. All problems have been worked out and now functioning correctly. I appreciate the messages.

Thanks for replying! I think it is a bug with this. I discovered a major bug tied into this just today. My scripts that I create from my workstation using...