Post reply

sqlserver agent,sqlserver 2008 compatability_level issue.

  • October 6, 2010 at 2:58 am

    #239285

    Hi All,

    Agent is missing in object explorer.. I searched at management from databases under object explorer. it not available.

    I had restored sql2000 databases into sqlserver 2008 instance. Then

    i trying to change the compatability level of those databases. Compatability

    level 100 is not available.

    Can you pls helps me.. how to find/resolve those two bugs.

    Thanks

    Balaji.G

  • October 6, 2010 at 3:09 am

    #1232318

    Please run the following and post the results

    SELECT @@version

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 6, 2010 at 3:29 am

    #1232330

    Hi Gail,

    Microsoft SQL Server 2005 - 9.00.4053.00 (Intel X86) May 26 2009 14:24:20

    Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6002: Service Pack 2)

    My client machine installed at sqlserver 2008 only. but when i ran this

    select @@version query. it shows the above result. i don't know why?

    Can you pls reply me

    Thanks

    Balaji.G

  • October 6, 2010 at 3:41 am

    #1232336

    That's what I expected.

    The server you're connected to is SQL 2005, not SQL 2008. That's why you can't set compat level to 100, the highest possible is 90 for SQL 2005.

    It's express edition (free edition), which does not include SQL Agent.

    Check that you're connected to the right instance. Maybe there's a 2008 edition installed as well and you just connected to the wrong one. Or maybe you just installed the SQL 2008 client tools, not the server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 6, 2010 at 4:05 am

    #1232344

    Thanks for your valuable post Gail

    Regards

    Balaji

  • October 6, 2010 at 4:56 am

    #1232359

    Hi Gail,

    I checked my instance details. I have list out here

    APRST2008\sqlexpress(sqlserver 9.0-4053)

    Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    Microsoft Analysis Services Client Tools 2007.0100.1600.022 ((SQL_PreRelease).080709-1414 )

    Microsoft Data Access Components (MDAC 6.0.6002.18005 (lh_sp2rtm.090410-1830)

    Microsoft MSXML 3.0 5.0 6.0

    Microsoft Internet Explorer 7.0.6002.18005

    Microsoft .NET Framework 2.0.50727.4200

    Operating System 6.0.6002

    Once we installed sqlserver 2008. system databases will come by default.

    Here i checked the system db's.. it shows only 2005 system databases.

    My question is where is the sqlserver 2008 system db's.. its not shown my instance..

    Can you pls advice me

    Thanks

    Balaji.G

  • October 6, 2010 at 5:10 am

    #1232375

    You don't have the SQL 2008 database engine. All you have is the 2008 client tools (management studio and the like) and the only database engine you have listed there is a SQL 2005 one.

    To get SQL 2008 service (and system DBs), you need to install the SQL 2008 database engine. Be aware of the licensing if you install something other than Express.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 6, 2010 at 5:43 am

    #1232404

    Thanks a lot. Gail

    Regards

    Balaji.G

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply