Tag Archives: sp_refreshview

SQL Server: Tables, Views and missing columns

Posted on Feb 26, 2010 by Serguei Dosyukov

When it comes to non-schema-bound-views (NSB View) it is important to remember that there is no schema bound between objects used in the view and metadata for a view. Let’s look at the following scenario: Attempt to use the view would … Continue reading →

Posted in Fun stuff with SQL Server | Tagged invalid column, invalid data, refresh metadata, refresh object, refresh view, script, sp_refreshsqlmodule, sp_refreshview, sql server, view schema | Leave a comment

About
From a junior developer through Sr Manager position, I was always interested in new technologies. Passionate speaker, IT junky, developer, architect, team lead, and development manager - many hats, one goal - making software better and being closer to people’s needs. For the most part I am using my blog as a scratch pad, writing small articles on things which I came across, was asked about more then once, and which would otherwise require additional research again and again.
Testimonials

First I’m new to G3. I was wanting to append my forum with a gallery and after doing a lot of looking and testing I settled on G3.I tried all the themes I could find on the page at the … Continue reading →

― Setishock

The greydragon theme is fantastic. It’s clean, stable and feature rich. It took me a while to decide to move to G3 but with a there like this one, I could no longer resist. Thanks!

― Ed
Categories

Tag Archives: sp_refreshview

SQL Server: Tables, Views and missing columns

About

Testimonials

Categories

Recent Posts

Recent Comments

Links

Recent Posts

Visitors