Possible to simulate supertypes and subtypes ?

Is there a way you can simulate subtypes in SQL Server ?
In Oracle Designer, you have the possibility to make
subtypes, but in SQL Server I can't find the way you do
this...
I would like to have a situation where you can make a
record of a subtype and SQL Server automatically creates
the records of the supertype(s)
ThanksCan you explain what you mean by subtype/supertype?
If you mean can you create a parent row automatically when a row is inserted
into a child table then the answer is yes. You can do this with a trigger on
the child table.
--
David Portas
--
Please reply only to the newsgroup
--
"Koen" <nospam@.nospam.com> wrote in message
news:0a7001c34214$c363e9b0$a101280a@.phx.gbl...
> Is there a way you can simulate subtypes in SQL Server ?
> In Oracle Designer, you have the possibility to make
> subtypes, but in SQL Server I can't find the way you do
> this...
> I would like to have a situation where you can make a
> record of a subtype and SQL Server automatically creates
> the records of the supertype(s)
> Thanks|||I jsut worked with a subtype/supertype design issue but
your post isn't clear, you want to make child records that
automatically create the parent records?
Ray Higdon MCSE, MCDBA, CCNA
>--Original Message--
>Is there a way you can simulate subtypes in SQL Server ?
>In Oracle Designer, you have the possibility to make
>subtypes, but in SQL Server I can't find the way you do
>this...
>I would like to have a situation where you can make a
>record of a subtype and SQL Server automatically creates
>the records of the supertype(s)
>Thanks
>.
>

Possibility of creating multiple join between two tables

Pls could someone help me out on the downside of creating two or more join relationships between two tables in a database and in business objects universe creation. Is it really ok and possible to create more than one join?

Thanks a lot .

Olusoga

Systems Analyst

If you mean that you want to have more than one column in the relationship, the answer is yes. That possible in SQL Server and very common as PK can contain more than one column. I doubt that this is not supported in any OR mapper like Business Objects.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

possibility in enterprise manager

Hi,

I'm using enterprise manager to remotely connect to a MS SQL Server for one of my client's websites. The problem I'm having is that the connection times out when I try to expand the "Databases" folder. The reason that it's timing out is because the company that hosts the DB has hundreds of other clients who all share the same IP, but each with their own seperate login/password/database, but even though I don't have access to all the rest of the DBs on the server, it still wants to list them all for me. What I'm wondering is is there a way to set EM to ignore all of the databases on the server that cannot be accessed with my credentials? So basically when I expand the Databases folder all that appears is the one that I can access?

Thanks,
DanteSeems like I've seen this question on the forum before and the answer was "nope". Sorry.