If you add a user in model then for every database created it will...

Mark

No question about it.

Not a bad...

Hi markos,

marcosc (5/19/2008)

---

I mean this: if the program and the reports all need to know the property name, it's the same thing as knowing the column name of the table....

Hi Markos,

As you said it is not a cool design but for the situation that was described it

was the best approch to take.

The final paragraph also shows that to...

If you see below and the name part is not in the lookup table, it will add to it automatically. I have included the script with the article for you...

JRoughgarden (3/24/2008)

---

Mark,

Could you give some links to discussion on the (lack of) scalability of the EAV model?

Also, what do you recommend in its place, master entity tables with 1-1...

Hi mark,

I am also looking forward to comments on part II of the article.

Thanks

Teshome

I am nearly there and will try to get in as soon as I can.

regards

Teshome

[qoute]

1. Oracle - PL SQL : What is is the similar tool in SQL Sever.

[/quote]

Transact-SQL

[qoute]

2. Oracle - Forms : What is is the similar...

you can use something like

declare @dbname varchar(300)

declare @sqlstring varchar(500)

select @dbname = max(name) from master.dbo.sysdatabases

while @dbname is not null

begin

set @sqlstring = 'use '+ @dbname + ' update tableA...