/****** Object:  VIEW #VIEWNAME# ********************************/
-- Script Date: #DATE#
-- Dev Org:
-- Author: 
--
-- Description:
--
-- Change History:
/****************************************************************/
PRINT '----------- #VIEWNAME# ----------'
GO

IF EXISTS
(
SELECT  *
FROM    [sysobjects]
WHERE   [type] = 'V'
AND     [name] = '#VIEWNAME#'
)
BEGIN
PRINT   '  DROPPING EXISTING VIEW'
DROP VIEW [dbo].[#VIEWNAME#]
END
GO

PRINT   '  CREATING VIEW'
CREATE VIEW [dbo].[#VIEWNAME#]
AS
SELECT  /* INSERT_SELECT_STATEMENT */
FROM    /* TABLE LIST */
GO

IF EXISTS
(
SELECT  *
FROM    [sysobjects]
WHERE   [type] = 'V'
AND     [name] = '#VIEWNAME#'
)
BEGIN
PRINT   '  GRANTING RIGHTS TO:' 
GRANT   SELECT ON [dbo].[#VIEWNAME#] TO [PUBLIC]
PRINT   '    PUBLIC' 
GRANT   SELECT ON [dbo].[#VIEWNAME#] TO [IMIS]
PRINT   '    iMIS'
GRANT   SELECT ON [dbo].[#VIEWNAME#] TO [ASIGOPHER]
PRINT   '    ASIGOPHER'
END
ELSE
BEGIN
PRINT   '  * FAILED CREATING VIEW #VIEWNAME# '
END
GO