Hi,

I Finaly write a general procedure to refresh all views of current database in good order

This procedure work for any database in SQLSERVER 2000.

See Resources/Scrips SQL Server 7.0/2000 T-SQL aids...

Hi,

I Finaly write a general procedure to refresh all views of current database in good order

This procedure work for any database in SQLSERVER 2000.

See Resources/Scrips SQL Server 7.0/2000 T-SQL aids...

IF you have a complex process to Findcolors, make a Function, you can call it in a select statment.

My example is very simple. Imagine this with database having hundred of views !!

I dont understand why sqlserver not have automatic procedure. After you make the change dependencies is...

exec sp_refreshview 'va'

lost dependencies of va2 !!!

I need to execute sp_refreshview in order of dependencies !!!???