Yes I do. Theese are: dbo, guest, INFORMATION_SCHEMA, system_function_schema. That`s all.
>I don't keep my Windows test box online, so I can't check this right
>now, but AFAIK 'dbo' is one of the schemas in Java terms.
>
>When you are doing reengineering, Cayenne presents a panel with
>schema selections (ok, "schema" is what the driver thinks is "schema"
>on the target DB, whatever it might be called by the DB vendor). Do
>you see any other choices in this dropdown besides 'dbo'?
>
>Andrus
>
>
>On Nov 24, 2005, at 4:10 PM, noban wrote:
>
>> 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
>>
>
-- Яндекс.Почта: объем почтового ящика не ограничен! http://mail.yandex.ru/monitoring/
This archive was generated by hypermail 2.0.0 : Thu Nov 24 2005 - 09:07:28 EST