There is a data type introduced in SQL2K called sql_variant, but it would yield you nothing, because AFAIK those variants allocates the space for the biggest possible data type. Well,...

quote:

---

I'm working on a database (SQL Server 7) that stores values for historical insight.

The problem is that there are two types...

quote:

---

Hm...seems to be fixed

---

that was short fun

Frank

http://www.insidesql.de

It might also be a good idea to change DDL for those columns to NOT NULL, maybe with a DEFAULT <blabla>

Frank

http://www.insidesql.de

quote:

---

i want to change the owner of my few tables at a time .how can i do that for all.

---

quote:

---

I need to get up to date on using the SQL language.

---

So if you are...

Hm...seems to be fixed

Thanks!

But what this time was new, was that some mails got through but without any content, no mail body!

Are you trying to keep this issue interesting

Hi tyang,

combine both suggestions and you should be fine.

SP3A seems to be once again sligthly different in information.

Frank

http://www.insidesql.de

Anyone else experiences no subscription mails today ???

Frank

http://www.insidesql.de

p:\sql\ntdbms\storeng\drs\include\record.inl looks like a bug in some inline function deep inside SQL Server.

If it is reproducable ?!? I would call MS support.

Frank

http://www.insidesql.de

quote:

---

Is it better to install EM on developers desktops or just install QA? Are there benefits (security, etc.) by only providing...

Another way could be

SELECT 

* 

FROM 

INFORMATION_SCHEMA.COLUMNS 

WHERE 

TABLE_NAME ='mails_header'

Frank

http://www.insidesql.de

Damm, I should get used to this to promote my site

http://www.insidesql.de/scripts/sqlserverfaq.php?id=19

Edited by...