Link to home
Start Free TrialLog in
Avatar of healthcheckinc
healthcheckincFlag for United States of America

asked on

SQL Amdinistration

I am having an issue and its been ongoing with my login until I had the networking delete it and add me back as Domain Admin. I thought everything was fine but now I when I try to look at a SQL job I cannot get into the properties. It keeps bringing me too a new job and not the details of the job Im trying to open. I cannot even create a Maintenance plan. I am sysadmin on the db. Something is wrong. Any help I would apprecate it.
ASKER CERTIFIED SOLUTION
Avatar of bull_rider
bull_rider
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of healthcheckinc

ASKER

Thanks I will try and let you know...Would I be able to do this while people are working in the db?
I would suggest you to do it in off peak hours just to make sure you don ot trigger any more severe issues. Good luck. :)
ok thanks. I will let you know...
hey bullrider, I dont have any service packs installed. Would I have to install sp1 before I go to sp2? Would you recommend me installing the lastest sp?
Here is my system info
version           product level     Edition
9.00.1399.06  RTM             Standard Edition

Thanks
No you do not have to install sp1 before sp2 as all SPs include the previous SPs released and the cumulative updates released thereafter by Microsoft unless stated by Microsoft that some updates are not included.

In other words, go directly for SP2

Good luck.
yeah I read that...Thanks..Probably wont run until the weekend though
Let me know if you come across any discrepancies and do not forget to mark the question answered if it really answered your question. Wish you good luck in your work. :)
I wont forget you, promise...
here's my email, if you ever wanna contact me...

ashu_vicky123@yahoo.com

or ashuvicky123@gmail.com
Did this work out for you?
I am gonna give you the points but I cannot run this until next week. I appreciate your help
Thanks bull rider