Post reply

Rename a SQL 7.0 Logical Filename

  • November 20, 2002 at 9:36 am

    #58211

    Can anyone tell me if it is possible to rename a SQL 7.0 logical filename?

    I am asking as I have a number of shop databases that are all identical so I created a template database and used sp_dettach_db, copy, sp_attach_db to create new shop databases from the template. Unfortunately, SQL 7.0 keeps the original logical filename.

  • November 20, 2002 at 10:01 am

    #441841

    Nope, you can rename all but the primary one, by adding new ones, emptying the old ones (which copies data to the new ones).

    Simon Sabin

    Co-author of SQL Server 2000 XML Distilled

    http://www.amazon.co.uk/exec/obidos/ASIN/1904347088


    Simon Sabin
    SQL Server MVP

    http://sqlblogcasts.com/blogs/simons

  • November 20, 2002 at 10:09 am

    #441846

    That's what I thought.

    Thanks

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

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