System Object SysColumns not found
-
Hi,
I'm facing a really deployment issue. I have created an application to select the columns and its corresponding datatype from syscolumns table. Its working fine with our development database. But once the application is deployed at the client it gives the error "Invalid Object name 'sysColumns'".
The SQL statement used in the application is
Select * From sysCoulmns
Later I tried to use the system view INFORMATION_SCHEMA.COLUMNS thinking that it could be some security setting. This time I got a new error "Invalid Column Name 'Column_Name'".
The application is developed in VB 6.0 and The Database SQL Server 2000.
SOME PLEASE HELP ME. I NEED TO DEPLOY THE APP B4 THIS WEEKEND!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
SOMEONE PLEASe HELP ME
-
Trt select * from dbo.syscolumn
Is your SQL Server be setup as case sensitive?
-
I'm with Allen in looking at whether or not the SQL Server is set up for case sensitivity. Many third party products require it, though in SQL Server 2000 you can set this at the database level just fine. PeopleSoft and Lawson come immediately to mind as culprits.
K. Brian Kelley
@kbriankelley -
sp_helpsort
Or
check database property using EM.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply