DECLARE @rOrgId int = 8010;
 
INSERT INTO sExamination.tSetupGroupMaster
VALUES (sCommon.fGetIntIdForOrg(2, @rOrgId), @rOrgId,'Pre Employment','Pre Employment', 2,0,1,GETDATE(),1,GETDATE(),1,0,1,0,0,NULL,NULL)
 
update sExamination.tSetupMaster set SetupGroupId = sCommon.fGetIntIdForOrg(2, @rOrgId)
where Id = sCommon.fGetIntIdForOrg(2, @rOrgId)

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



DECLARE @rOrgId int = 8010;
select * from sExamination.tSetupGroupMaster where Id = sCommon.fGetIntIdForOrg(2, @rOrgId)
select Id,SetupGroupId from sExamination.tSetupMaster where Id = sCommon.fGetIntIdForOrg(2, @rOrgId)

































SELECT
    name,
    collation_name
FROM sys.databases
WHERE name IN ('master', 'model', 'msdb', 'tempdb');
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

SELECT
    SCHEMA_NAME(o.schema_id) AS SchemaName,
    o.name AS ProcedureName
FROM sys.objects o
INNER JOIN sys.sql_modules m
    ON o.object_id = m.object_id
WHERE o.type = 'P'
  AND m.definition LIKE '%CREATE TABLE #%'
  AND (
        m.definition LIKE '%VARCHAR%'
        OR m.definition LIKE '%NVARCHAR%'
      )
  AND m.definition NOT LIKE '%COLLATE DATABASE_DEFAULT%'
ORDER BY
    SchemaName,
    ProcedureName;