• One addition to the really old post.

    Load your database into a Database Project in Visual Studio (SSDT - SQL Server Data Tools free add-in for VS). Then you can search/replace like any other VS project. Then create a publish script against your database and it will create all of the necessary scripts to convert everything over.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg