I used this to create the view:
USE [Our Database]
GO
EXEC database.sde.set_current_version 'the version'
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
but when I script out the view to a new query window, the exec is not there:
USE [Our Database]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
is there something else I need to do?
Thanks.