Home Forums SQL Server 2008 T-SQL (SS2K8) How to stop SSMS from adding database name to scripts RE: How to stop SSMS from adding database name to scripts

  • That handled that issue.

    Is there a setting for the adding the database to the Insert or Update scripts:

    INSERT INTO [MyDEV].[dbo].[District]

    ([DistrictCode]

    ,[DistrictName]

    VALUES

    (<DistrictCode, varchar(32),>

    ,<DistrictName, varchar(128),>)

    GO

    I don't want the "[MyDev]." to be added when generating this script (or update and delete).

    I can't seem to find it in the section you mention.

    Thanks,

    Tom