Skip to content

add registration to all database #4

@MykolaDiachok

Description

@MykolaDiachok

I tested your project, and had a little trouble with connecting from the worked database.
Please add script to registration
DECLARE @SQL NVARCHAR(MAX) = N'';

SELECT @SQL += CHAR(13) + CHAR(10)

  • 'USE ' + QUOTENAME(name) + ';

IF OBJECT_ID(''dbo.RegexSplit'', ''FN'') IS NOT NULL
DROP FUNCTION dbo.RegexSplit;

IF OBJECT_ID(''dbo.RegexSplit'', ''SN'') IS NOT NULL
DROP SYNONYM dbo.RegexSplit

CREATE SYNONYM dbo.RegexSplit FOR master.dbo.RegexSplit;'
FROM sys.databases WHERE name <> 'master';

PRINT @SQL;

EXEC sp_executesql @SQL;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions