Forum Replies Created

Viewing 15 posts - 136 through 150 (of 243 total)

  • RE: SQL Agent

    Bhuvnesh (3/31/2010)

    Sorry i just saw there is no option i ADD REMOVE programs.

    refer below link .it might help you http://www.sqlservercentral.com/articles/Service+Packs/sp3/138/

    Yes Yes there is no such a option in the...

    March 31, 2010 at 4:26 am

    #1142942

  • RE: SQL Agent

    Bhuvnesh (3/30/2010)

    Sp3 would be fine , ignore my previous post

    Hi..

    while applying the service pack 3 Notification services got failed.Please let me know how to rollback the service pack.

    March 31, 2010 at 12:33 am

    #1142858

  • RE: SQL Agent

    Bhuvnesh (3/30/2010)

    Sp3 would be fine , ignore my previous post

    ok.

    March 30, 2010 at 6:39 am

    #1142129

  • RE: SQL Agent

    Bhuvnesh (3/30/2010)

    sudhakara (3/30/2010)

    Thanks for your reply.

    Did it get resolve ?

    Let you know once i have applied the service pack 3 on the sql server.

    March 30, 2010 at 5:34 am

    #1142076

  • RE: SQL Agent

    JKG (3/29/2010)

    May seem like a stupid question, but is anything actually not working, or are you just getting the error in the logs? Looking around, this seems to...

    March 30, 2010 at 1:47 am

    #1141995

  • RE: SQL Agent

    Bhuvnesh (3/30/2010)

    yes it happened because of SP1 i think MS has fixed this bug iin SP2.

    refer these links

    http://www.windows-tech.info/15/4b5bdaab8e755fbe.php

    http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15824.aspx

    http://dbaspot.com/forums/sqlserver-programming/350238-sql2005-sql-agent-error.html

    Thanks for your reply.

    March 30, 2010 at 1:45 am

    #1141994

  • RE: SQL Agent

    Bhuvnesh (3/29/2010)

    Additionally Are you taking backup of MSDB ?

    No. i have not taken the backup of MSDB.

    March 29, 2010 at 9:49 am

    #1141525

  • RE: SQL Agent

    Bhuvnesh (3/29/2010)

    Did you have SP1 patch recently?

    Whats values you are getting with it?

    select value, value_in_use from sys.configurations where name = 'Agent XPs'

    Yes. i have applied service pack 1...

    March 29, 2010 at 9:44 am

    #1141522

  • RE: SQL Agent

    Any suggestion will be appreciated.

    Thanks in Advance.

    March 29, 2010 at 2:44 am

    #1141255

  • RE: SQL Agent

    vmssanthosh (3/27/2010)

    Hi

    By any chance did you change the sql server agent process account using windows service manager?

    No.i did not.

    March 27, 2010 at 8:46 am

    #1140939

  • RE: SQL Agent

    vmssanthosh (3/27/2010)

    hi

    did you change the server role by any chance. Check whether you are able to access msdb database with the login specified to run the job at the agent

    Regards

    VMSSanthosh

    Yes,i...

    March 27, 2010 at 8:43 am

    #1140938

  • RE: SQL Agent

    GTR (3/26/2010)

    Is it using same windows account as back up job maintenance task?

    Is it using same windows account as back up job maintenance task?

    Ans: Yes but it is not created...

    March 27, 2010 at 5:36 am

    #1140917

  • RE: SQL Agent

    GregoryF (3/26/2010)

    Have you enabled logging (under the advanced tab of the job step properties)? If not, enbable it, then check the log file for more detailed info.

    Also, copy the...

    March 27, 2010 at 5:31 am

    #1140916

  • RE: CUP utilisation of Instance in Server

    sql_lock (3/21/2010)

    No, it should give you the % per process per instance.

    Yes..its there in the name of sqlservr , sql servr#1. but how i can identify the name of the...

    March 21, 2010 at 7:10 am

    #1137331

  • RE: CUP utilisation of Instance in Server

    sql_lock (3/20/2010)

    Use perfmon. Under the Process object you will be able to select sqlservr, sqlservr#1 etc. Then select the % Processor Time

    Yes.. it is there the object in name of...

    March 20, 2010 at 8:19 pm

    #1137291

Viewing 15 posts - 136 through 150 (of 243 total)