Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot get the column information
Message
De
28/03/2008 15:29:15
 
 
À
28/03/2008 15:00:18
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Scripting
Divers
Thread ID:
01306583
Message ID:
01306601
Vues:
3
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform