Yes, it was a serious question.  I always figured it was a throwback to the days when monitors could only display upcase chars.  At least that's all my apple II+...

fyi, in 2008 we will finally have arrays natively in sql:

https://connect.microsoft.com/SQLServer/content/content.aspx?ContentID=5507

very much agree on the all caps.  so why is it that so many sql devs write the keywords such as SELECT in ALL CAPS?

when it comes to sql it...

in 2005 it's not OWNER anymore, but SCHEMA:

LINKEDSERVER.DATABASENAME.SCHEMA.OBJECTNAME for REMOTESERVER

DATABASENAME.SCHEMA.OBJECTNAME for LOCAL SERVER DBs.

agreed, better to keep historical data in another db, not csv.  if it's in csv only, it's impossible to access it unless you load it into a db again.  so...

here's an alternative for scripting objects in an automated way using a console app:

http://www.codeplex.com/scriptdb

open source so you can tweak it if you need to.

you could export the data using bcp.exe, then import it to oracle using SQL*Loader

I wrote a console app hosted on codeplex that will script out all objects for any 2000 or 2005 database.  since it's a cmd line app it would be very...

you should name the property MS_Description, not Description.  if you do that, your comment will be picked up by the MS tools like SSMS, etc.

you might also check out this open source app I wrote for scripting objects and data from any 2000 or 2005 db:  http://www.codeplex.com/scriptdb

it makes it easy to automate generating...

you might also want to check out SqlSpec (in my sig below).  with it you can generate docs for any database, and also edit the extended properties for all objects...

you could also create a logon trigger:

http://technet.microsoft.com/en-us/library/bb326598(SQL.90).aspx

best is: don't do it at all.  read this first if you think EAV is the way to go:

http://weblogs.sqlteam.com/davidm/articles/12117.aspx

SqlSpec will do this for you if you choose the "document permissions" option, or pass "/y 1" on the command line.  Also the eval version is free.  See the link...

I would think that loading into a staging table with bcp is the way to go, even if this is not a one-off.

it will be much more maintainable to write...