Thanks again for your response.
Yes I did. I somehow found the problem. I have to do some testing though to
You might have encountered this problem or issue:
Production Server - SQL 6.5 SKP4
Test Server - SQL 6.5 SPK5
My frontend is Powerbuilder (I have two versions, PB5 and PB6.5) After
transfering the database to the Test Server (from Production) I looked at
the tables using PB5 and the datatypes are gone but when I view it again
using PB6.5, everything was okay. I think it has to do with the Service
> Did you select to transfer all user defined datatypes and dependencies?
> Neil Pike MVP/MCSE. Protech Computing Ltd
> (Please post ALL replies to the newsgroup only unless indicated
> For SQL FAQ entries see
> http://go.compuserve.com/sqlserver (library 1) - latest stuff is always