Viewing 15 posts - 301 through 315 (of 2,636 total)
Combine Sarvesh's and David's suggestions:
1. create a login: create login domain\login from windows
2. create a user in the specific database: create user user for login domain\login
3. create a database role:...
July 7, 2009 at 9:42 am
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...
July 6, 2009 at 12:01 pm
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...
July 2, 2009 at 4:49 pm
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...
July 2, 2009 at 12:45 pm
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...
July 2, 2009 at 9:44 am
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...
July 1, 2009 at 12:52 pm
This http://www.sqlservercentral.com/scripts/attach/66866/ is in the script section and is worth a look for scripting databases.
July 1, 2009 at 12:49 pm
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...
June 30, 2009 at 9:23 am
David (6/30/2009)
You can script all the SQL agent jobs and run them against the destination server...
Scripting is the method I prefer for moving jobs. Although you can restore a backup...
June 30, 2009 at 9:10 am
Have you checked to see if you have read and write permissions for the folder?
June 29, 2009 at 4:54 pm
Omit parenthesis and put double quotes (") around the package name.
June 25, 2009 at 10:48 am
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...
June 24, 2009 at 10:11 am
vyelchri (6/22/2009)
June 24, 2009 at 9:10 am
I believe you have to run msdb.dbo.sp_update_jobschedule to disable a schedule.
June 23, 2009 at 5:25 pm
Patrick ISAMBERT (6/23/2009)
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...
June 23, 2009 at 9:32 am
Viewing 15 posts - 301 through 315 (of 2,636 total)