Search
-
Re: Unknown type - dbo.dbo
Comment by richardjm · · Home› Discontinued and Previous Versions› SQL Data Compare Previous VersionsCan I ask if you have any user defined types in your database and what they may be defined as. We came across this problem in testing and we thought we had it fixed. Any information on types used would be most helpful - perhaps you could send me a SQL Compare snapshot of the structures of the two databases? Thanks -
Re: Unknown type - dbo.dbo
-
Re: Unknown type - dbo.dbo
Comment by GiageJoe · · Home› Discontinued and Previous Versions› SQL Data Compare Previous VersionsRichard, I just attempted to use the 5.1.0.106 build of Data Compare and got Unknown Type - sys.Address. The user defined type of Address is owned by dbo in our SQL Server 2000. I received this problem in mutliple databases (all having our user defined types). One of them was just generated by a home grown app that creates… -
Re: Unknown type - dbo.dbo
-
Re: Unknown type - dbo.dbo
Richard, The message is "Unknown type - sys.udtCode". udtCode is my user-defined data type {varchar(20)} and is in both DBs being compared. The comaprison is between two different servers both with SQL Server 2000. Perhaps interestingly one server is version 8.00.194 and the other 8.00.2093 (SP4). Do you think applying SP4… -
Re: Unknown type - dbo.dbo
Comment by richardjm · · Home› Discontinued and Previous Versions› SQL Data Compare Previous VersionsAfter having a look at the snapshots that I've been sent we've found out that SQL Data Compare has a problem with user defined types in SQL 2000 that are owned by any user other than 'dbo'. We're looking into this now and will hopefully get a fix out as soon as we can. SQL 2005 and SQL Server 7 are unaffected you'll all be…
6 results