1

Closed

SQL statement to check if a view, sp or function does already exists in the DB does not add the scheme

description

SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'PMD_GetCurrentFiscalMonth') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')
 
should be
 
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'MYSCHEME.PMD_GetCurrentFiscalMonth') AND type in (N'FN', N'IF', N'TF', N'FS', N'FT')
Closed Oct 11, 2010 at 8:47 PM by stefh
Solved in MyDbUtils_0.9.3.0

comments