• As Andy suggested, you may issue the following query to retrieve the view script, provided that it was created without the ENCRYPTION attribute:

    SELECT [text] FROM syscomments WHERE OBJECT_NAME([id]) = 'YourViewName'


    David R Buckingham, MCDBA,MCSA,MCP