Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot get the column information
Message
From
28/03/2008 15:29:15
 
 
To
28/03/2008 15:00:18
General information
Forum:
Microsoft SQL Server
Category:
Scripting
Miscellaneous
Thread ID:
01306583
Message ID:
01306601
Views:
5
Cool.

Hey Mike, here's an interesting article about this error and general reasons, FWIW:

http://sqlserver2000.databases.aspfaq.com/why-do-i-get-object-could-not-be-found-or-invalid-object-name.html

>Ok, I have found the reason. One of the new inserted table contains some fields that I have not passed with the proper name. It seems the script analysis the code before executing in it. In this case, it detected that a linked server import table didn't contain the proper field name and returned that code. So, basically, on that verification, it is entirely done before the first line of script is even executed.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform