Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Refresh All Database Views

Started 1 month, 1 week ago by aomara
You can simply use this stored procedure to refresh all database views with one command (including dependent views problem handling - Binding errors) Note : this procedure is examined on SQL Server 2005 . CREATE procedure [dbo].[refviews] ( @varViewName VARCHAR(500) = NULL ) --Created on 08 Feb 2009 By Ahmed Omara as declare @p_viewname nvarchar(500) BEGIN IF (@...
Site: Tek-Tips Forums  Tek-Tips Forums - site profile
Forum: Microsoft SQL Server: Programming  Microsoft SQL Server: Programming - forum profile
Total authors: 2 authors
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: tek-tips.com

Other posts in this thread:

genomon replied 1 month, 1 week ago
Why not post as a FAQ? Cogito eggo sum – I think, therefore I am a waffle.

 

Top contributing authors

Name
Posts
genomon
1
user's latest post:
Refresh All Database Views
Published (2009-11-09 11:54:00)
Why not post as a FAQ? Cogito eggo sum – I think, therefore I am a waffle.  
aomara
1
user's latest post:
Refresh All Database Views
Published (2009-11-09 06:12:00)
You can simply use this stored procedure to refresh all database views with one command (including dependent views problem handling - Binding errors) Note : this procedure is examined on SQL Server 2005 . CREATE procedure [dbo].[refviews]  (    @varViewName        VARCHAR(500)    =...

Related threads on "Tek-Tips Forums":

Related threads on other sites:

Thread profile page for "Refresh All Database Views" on http://www.tek-tips.com. This report page is a snippet summary view from a single thread "Refresh All Database Views", located on the Message Board at http://www.tek-tips.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity