Corrupted View? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Corrupted View?

Author

Topic

rbarlow
Starting Member

26 Posts

Posted - 2009-09-24 : 18:56:42

We ran into a problem with a view that started returning incorrect data (no errors). The query (see below) used a table alias and when the view was re-created without it the problem went away:

We changed it from:

CREATE VIEW V1
AS
SELECT
T1.*
FROM DB1.[dbo].TABLE1 T1
WHERE (t1.FIELD1 = 1)

to:

CREATE VIEW V1
AS
SELECT *
FROM DB1.[dbo].TABLE1
WHERE (FIELD1 = 1)

We believe this started happening on the day that we had a SAN outage and the server temporarily lost it's drives with SQL still running. Once the drives were back and SQL started, we ran DBCC CHECKDB to see if anything got corrupted and it didn't return any errors.

Has anybody else seen anything like this before?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources