Red Gate forums :: View topic - Parsing error
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Dependency Tracker 2
SQL Dependency Tracker 2 forum

Parsing error

Search in SQL Dependency Tracker 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
cbondeson



Joined: 29 Nov 2005
Posts: 7

PostPosted: Thu May 25, 2006 4:22 pm    Post subject: Parsing error Reply with quote

We have an sp which assesses information_schema.tables. The parser indicates that "tables" is an "Unresolved Internal Reference" ,"object not found". The sp text follows:

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS OFF
GO
CREATE proc dbo.DatabaseReIndex AS

--Script to automatically reindex all tables in a database


DECLARE @TableName varchar(255)

DECLARE TableCursor CURSOR FOR
SELECT table_name FROM information_schema.tables
WHERE table_type = 'base table'

OPEN TableCursor

FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0
BEGIN
--PRINT "Reindexing " + @TableName
DBCC DBREINDEX(@TableName,' ',90)
FETCH NEXT FROM TableCursor INTO @TableName
END

CLOSE TableCursor

DEALLOCATE TableCursor



GO
Back to top
View user's profile Send private message
Bart Read



Joined: 31 Mar 2005
Posts: 977

PostPosted: Fri Jun 02, 2006 9:45 am    Post subject: Reply with quote

Hi there,


Thanks for the feedback. This is a known problem: since we don't pull in system objects, and this includes the INFORMATION_SCHEMA views, these always appear as unresolved objects.

The workaround for now is just to hide them, however I imagine we might well fix this in a future release. I'll add this to our bug tracking system at any rate.


Many thanks,
_________________
=============================
Bart Read
www.bartread.com/blog
=============================
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group