<div>
Perhaps<br />
&quot;CREATE OR REPLACE VIEW&quot;<br />
is a better strategy. You could try it.<br />
<br />
From the manual:<br />
This statement creates a new view, or replaces an existing<br />
one if the OR REPLACE clause is given. If the view does<br />
not exist, CREATE OR REPLACE VIEW is the same as CREATE<br />
VIEW. If the view does exist, CREATE OR REPLACE VIEW is<br />
the same as ALTER VIEW.
</div>


Perhaps
"CREATE OR REPLACE VIEW"
is a better strategy. You could try it.

From the manual:
This statement creates a new view, or replaces an existing
one if the OR REPLACE clause is given. If the view does
not exist, CREATE OR REPLACE VIEW is the same as CREATE
VIEW. If the view does exist, CREATE OR REPLACE VIEW is
the same as ALTER VIEW.

<div>
Sorry only put on the tags that Im using SQL 2000 which doesnt appear to support this.<br />

</div>


Sorry only put on the tags that Im using SQL 2000 which doesnt appear to support this.


<div>
Great that will do fine, thanks.
</div>


<div>
<div class="content wysiwyg-content">
Im looking to fire a stored procedure one per day. &nbsp;It retrieves the primary key of records that have been added in the last 30 days. Im then looking to ALTER VIEW so that the view filters for records where the primary key is greater than the one just retieved.<br />
Having issues with ALTER VIEW needing to be the first statement.<br />
Using the PK opposed to just using date criteria is required for speed.
</div>
</div>


Im looking to fire a stored procedure one per day.  It retrieves the primary key of records that have been added in the last 30 days. Im then looking to ALTER VIEW so that the view filters for records where the primary key is greater than the one just retieved.
Having issues with ALTER VIEW needing to be the first statement.
Using the PK opposed to just using date criteria is required for speed.

Using ALTER VIEW from within a stored procedure

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.