Actually, db_owner and sysadmin are the only ones who can enable diagramming in a database. After that's done, any database user can create diagrams.

Assuming diagramming has already...

Aw, I messed that one up. I thought you were seeing 0 for next_run_date. I should have just pointed out that the date you set it for was...

You're not really renaming the instances; you're renaming the machine that the instances reside on. You also have to stop and start the SQL Server service after running the...

The reason you don't see the next run date is because sysjobschedules refreshes every 20 minutes from the sysschedules system table. The schedule you set will execute the job...

Open the package n DTS Designer, click on "Package" and select "Save as...". Specify the server and location of the destination server. If you have a lot of...

This http://www.sqlservercentral.com/scripts/attach/66866/ is in the script section and is worth a look for scripting databases.

In either case, when you open the Log File Viewer to see job history, there's a pane on the left called "Select logs". You can check or uncheck specific...

Scripting is the method I prefer for moving jobs. Although you can restore a backup...

Have you checked to see if you have read and write permissions for the folder?

Omit parenthesis and put double quotes (") around the package name.

Usually, the fixed database roles are owned by dbo. Check the properties of some of the other roles in the database e.g. db_securityadmin, db_ddladmin, etc. You can change...

vyelchri (6/22/2009)

---

I downloaded SQL Server 2005 upgrade advisor and installed on my machine. when i trying to access the "Launch Upgrade Advisor Analysis Wizard" it is giving some error message...

I believe you have to run msdb.dbo.sp_update_jobschedule to disable a schedule.

Patrick ISAMBERT (6/23/2009)

---

Hi

In SMS when I enable a disabled job, the next run field is updated.

When I do this by setting enable = 1 in sysjobs, the next run is...

What is in the job category and what makes you think it wasn't built in SQL Server?