Post reply

Update Schema Table / Structure Table

  • April 9, 2002 at 4:13 am

    #78436

    Hi everyone ... i'm newest on SQL Server

    i have problem to update schema table on sql server. Actualy i have 40 database on my sql server and 1 database for master structure.

    my question is how i update my 40 database using 1 database as the based structure ?

    thanks before

    ng hendry

  • April 9, 2002 at 5:31 am

    #426855

    Beyond using model for future database building to have the same files and structure, the answer is no, not without an application to do it. Databases are treated as individual intities and changes to ones structure cannot apply to all.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • April 9, 2002 at 9:22 am

    #426870

    May I know what kind of application that you are referring to here? Any example?

    Is it possible to use store procedure to do this? If can, how?

    thanks

    ng hendry

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

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