Post reply

Is there any?

  • August 18, 2004 at 8:03 pm

    #83477

    Is there any change in the structure of the default database of my SQL server when I try apply new Service Packs? I know that sp solve bugs but I'm confused did SP changes also the structure of the default database of sql server? Ex. msdb, pubs, or any.

    Thanks in advance.

  • August 19, 2004 at 2:29 am

    #519711

    the default database? what do you mean by this?

    each user has his own default database, but this is purely for those lazy coders that don't specify the database name in connection strings.

    your default database may be different to another users, and service packs wouldn't modify the structure of your user tables in a user database.

    MVDBA

  • August 19, 2004 at 7:31 am

    #519775

    There can be changes to the db strucutre without notice. This is why you have to backup are each SP ot Hotfix. Then when you restore you install SQL Server, then latest SP and Latest Hotfix after which matches with your DBs then you do the restore of the databases.

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

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