Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Multi refresh of views within a database

As we know you have SP_RECOMPILE to re-compile the stored procedures within the database and DBREINDEX statement to reindex the fragmented indexes.

How about refreshing the views that are modified on day-to-day basis within a database?

You can take help of  SP_REFRESHVIEW that updates the metadate for a specified view, ensure that view is not a schema bounded (not used with  SCHEMABINDING clause). Because the view will reproduce unexpected results when executed SP_REFRESHVIEW statement.

 

Posted: Tuesday, May 22, 2007 8:12 AM by SQL Master

Comments

SSQA - SqlServer-QA.net said:

As we know you have SP_RECOMPILE to re-compile the stored procedures within the database and DBREINDEX

# May 22, 2007 4:28 PM
Anonymous comments are disabled