I don't have the exact steps to solve as a coworker found the issue. I'm guessing whoever initially set up access did not allocate the proper access at both levels,...

We have this resolved. It was an NTFS/sharing confilct. Thanks

Thanks for the replies.

The agent account is the same as the service account, so it has full control over the directory. Can't execute as a job or in a...

i found it, thank you both

thank you for your reply.

I will look into SP2. For some reason though, I can't view the monitor when I right-click jobs.

Hi, I have a similar issue. I'd like to run a transaction log backup and truncate the transaction log. Currently is 26gigs. Will the back up...

greg thanks for looking. I did, but I figured it out. I didn't realize that when you create a maintenance plan, it automatically generates that code. thanks...

nevermind

I've got a question about this statement:

I created a plan on my test machine, here is what I ended up with for the backup job:

EXECUTE master.dbo.xp_sqlmaint N'-PlanID 0D097FED-F1C1-4850-A34C-7A83EF96A81B -WriteHistory -VrfyBackup...

Jeff thanks, the user did not appear in the results

ALZDBA, thanks again. One of the first things I did was change ownership of that database. I also...

thanks. I ran that query and the user is not included in the results

thanks alzdba, but the script doesn't generate any results....

thanks for the reply.

I ran the CREATE USER statement but not the GRANT CONNECT statement. When I try to run the GRANT CONNECT statement I get the "Msg 15151,...

I'm not a guru, but from what I've been reading, the built in/admin group is a huge security threat. Its on my list of things to fix from the...

In my case, the previous DBA created the database and made himself as the owner, he just left the company..