Looks like there are no such concept as 'scheme' in MsSQL2000, at least I was unable to find it. 2000 server have only different 'data bases' looks they work as 'schemes' one DB server can have multiple 'data bases'. So all my tables are located in the same databases (by name) in both my and main DB servers. They all have the same owner - dbo. And they all are - user tables. Thats all I was able to find. I can`t find any other differencies.
>Likely this has something to do with your default schema on each
>server. IIRC schema name on MS SQLServer matches the user name you
>use to log in. So the tables probably exist, only in some other
>schema... Just a guess - you can browse different schemas in the
>Enterprise Manager to confirm that.
>
>Andrus
>
>
>On Nov 24, 2005, at 2:46 PM, noban wrote:
>
>> Actually I`ve tried to create test table on DB server using its
>> (server) MS EnterpriceManager. The same result.
>>
>> Does anybody have some hints?
>>
>>
>>> Hi!
>>>
>>> Recently I have reinstalled my MsSQL, it works fine. I`ve loaded
>>> my dev. DB from the server and added couple of tables. Also I`ve
>>> exported these tables to Main dev server. So now when I`m
>>> launching Cayenne modeller on my machene it reengeneers only
>>> system tables, and when on main DB server it reengeneers only old
>>> tables without new exported one`s. I`ve tried both 1.1.3 & 1.2.M7
>>> - the same result.
>>>
>>> As I remeber now My old configuration on my machine was MsSQL2000
>>> SP3, as well at server, but my new configuration is MsSQL2000
>>> SP4a. Can this (SP4a) be the cause?
>
-- Сегодня удачный день, чтобы завести почту на Яндексе http://mail.yandex.ru
This archive was generated by hypermail 2.0.0 : Thu Nov 24 2005 - 08:11:00 EST