Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Sql server 2005 SP3 Issue

Author  Topic 

Madhav
Starting Member

38 Posts

Posted - 2010-03-29 : 10:27:09
I have upgraded my sqlserver 2005 from sp2 to sp3.
Upgrade completed successfully but I have an issue with sql server agent jobs. When I click on job proprties(jobs-->rightclick on jobname-->Properties), It opens a "New Job" window.
I can not able to edit existing jobs or newly created jobs. Is this is a bug with sp3? how to fix it?
Please help me.

Thanks.

divided
Starting Member

12 Posts

Posted - 2010-04-30 : 17:02:51
I've ran into this before and it was only when I tried connecting to a remote server using management studio. If I log in locally (or rdp) into the server then run the stuido from there it works fine. Not sure why but it really isnt a big deal in my situation.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-30 : 17:08:50
Try applying CU9.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -