Post reply

Strange situation in SQL 2008

  • March 27, 2012 at 6:17 pm

    #266362

    Hello everyone,

    Today i have faced an issue on SQL2008 instance , when we create a new database the default compatibility it is taking as 90. i can change manually to 100. but why we need to change on 2008 instance. is there any option to check at instance level??

  • March 27, 2012 at 6:21 pm

    #1465420

    What is the compatability level of you Model DB ?

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • March 27, 2012 at 6:24 pm

    #1465421

    Model DB is 100 but not sure why user dbs are getting 90. is there any option in regedit where we can cross check . thanks for ur reply

Viewing 3 posts - 1 through 2 (of 2 total)

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