I get permission denied on 'sp_add_job'

Edit: My Bad ........ The user was also a member of TargetServersrole, which must have lower permissions than SQLAgentUserRole, so it was being...

I'm in the same position of wanting to convert from 80 to 90 ..... Good posts here !

In a production environment, it might be safer to back up the t-logs more frequently. We back ours up every 15 minutes.

How are your current backups running ?? Are your production backups in FULL recovery mode ? Are you taking transaction log backups regularly throughout the day ? ...

We have Idera's Compliance Manager, Diagnostic Manager & SQLSafe. Been happy with all 3. They seem to discount off "list price" so consider that when comparing.

I think all companies will...

We use Idera tools & like them. Also, the new version of WhatsUpGold can monitor all types of things on your server. We're using it quite extensively now. http://www.whatsupgold.com/

In the properties of the SQL Server Agent, what is the "Alert System" setting for Mail Session ? Enable Mail Profile should be checked. This was my problem a...

Yes, you can select the tables for all types of replication. As you set it up, you'll get a screen to check off the tables you want (tables are called...

Jim Russell (1/3/2008)

---

What is recommended in the case where multiple independent dbs owned by unrelated individuals/groups/organizations are sharing the same server, and providing local DBA functions themselves, and wish their...

http://technet.microsoft.com/en-us/library/ms142547.aspx

Consider 3rd party backup compression software such as idera's SQLSafe (we use it) or others by Redgate or Quest. Our 280 GB backup only takes 30 minutes and uses 45...

I don't think that's a bug. One job...

Greg Charles (12/17/2007)

---

That will only work if the package name was used in the step description. What you need to do is

decrpyt the DTSRUN command. Do this:

copy the...

How about setting it to autogrow, with a limit of 300 Gig ?

I parsed it in 2005 and got this:

Incorrect syntax near the keyword 'OPENROWSET'.

I didn't dig any deeper.