SQL Server All View Refresh

• yusufkahveci

  SSC-Addicted

  Points: 466

  More actions

  January 11, 2018 at 8:53 pm

  #334476

  Comments posted to this topic are about the item SQL Server All View Refresh

  SQL Server Consultant
  yusufkahveci@sqlturkiye.com
  www.sqlturkiye.com

• Jeff Moden

  SSC Guru

  Points: 1004600

  More actions

  January 14, 2018 at 7:25 pm

  #1975856

  So, what happens when the view is in a schema other than the default schema of the user using the script?

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• SQLOzzie

  Default port

  Points: 1445

  More actions

  June 5, 2018 at 11:35 am

  #1992986

  How about this
  

  DECLARE
   @sqlTrexec NVARCHAR(MAX)='';

  SELECT @sqlTrexec = @sqlTrexec + '
  EXECUTE sp_refreshview N''' + QUOTENAME( SS.Name ) + '.' + QUOTENAME( SO.Name ) + ''';'
  FROM sys.objects AS SO
  INNER JOIN sys.schemas AS SS ON SO.SCHEMA_ID = SS.SCHEMA_ID
  WHERE SO.TYPE='V'
  ORDER BY SS.Name, SO.Name;

  EXECUTE (@sqlTrexec);