September 15th, 2004, 01:44 PM
|
|
Contributing User
|
|
Join Date: Jul 2004
Posts: 33
Time spent in forums: < 1 sec
Reputation Power: 5
|
|
Invalid column name error
I have two servers (server1 and server2), I created a new database on server1. server1 is running low on space so I migrated the database over to server2.
The problem that I am having is, I cannot query, from an ASP script, any of the tables created after the migration, I get the error Invalid column name. I can however query the tables from within SQL Server Enterprise Manager as well as from within Query Analyzer.
Ownerships are completely identical, the public has full access.
I am completely stumped? Can anyone help? 
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
