Hi al,
I have a lnked server between SQL and Sybase.
All my data looks ok except for 2 columns.
These 2columns are named "TIMESTAMP" & "TIME" in sybase.
When I link to these columns using visual studio the data within the columns just shows the word timestamp or time repeated.
This looks like SQL has avoided returning any values.
The Datatype is for TIMSTAMP Column is smalldatetime.
Could this be something to do with the fact tha TIMESTAMP and TIME are reserved words in SQL.
Is there a work around for this because without these columns I cannot run any reports?