Unix Technical Forum

RE: ODBC SQLState: 42S22 in Enterprise manager

This is a discussion on RE: ODBC SQLState: 42S22 in Enterprise manager within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> From BOL "This error occurs when a column referenced in a Transact-SQL statement was not found in any table ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 07:17 PM
Shawn Aebi [MSFT]
 
Posts: n/a
Default RE: ODBC SQLState: 42S22 in Enterprise manager

From BOL "This error occurs when a column referenced in a Transact-SQL
statement was not found in any table specified in the FROM clause of the
query.". Somehow the metadata (system tables) for the internal tables seems
to be inconsistent. Have you perhaps recently transferred the db from one
machine to another?

Shawn Aebi
Microsoft
This posting is provided "AS IS" with no warranties, and confers no rights


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:16 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com