Hi all
We have some tables with a couple of layers of very simple views built on
top. In the table are maybe 6 columns and about 15000 records. The first
view cobines the data in the table with some other data from a lookup
table. The second view does some sorting on the first view using certain
dates . They have worked fine for well over a year now.
Until this morning that is... the views stopped returning the full set of
results- even the very simple one that sits just above the table. The view
returned the core of the data from the main table, but nothing from the
lookup table.
In order to get them to work we had to delete each view (using access front
end to do this), and then recreate it with exactly the same SQL text. I am
guessing this causes SQL Server to recompile it. As soon as view 1 had been
recreated it worked, but view 2 still failed, again rebuilding view 2 it
started working.
The only thing I can think of is that this morning I added 2 new fields to
the base table, but I'm sure I've done this before without any (noticable)
problems.
any thoughts as to why it happened would be welcome, I am a bit nervous
now...
thanks
Andy