I'm not laughing at anyone... except at one comment Jeff made a few days (or weeks) ago.

Who needs that crap... wasn't it you that proposed a fully xmled Entity-value system?  No need for all those table things anymore .

Can we see the rest of the table's definition?

Add a column to A

Copy B data to A's new Column

Copy A data to B's column

Copy new A column to old A column

Drop A's new column

That's another command : sp_addlinkedsrvlogin

I was assuming that you were using windows authentication!

NEVER ASSUME ANYTHING!

There I'll remember this time .

Run that in any command or connection object from asp.  This may be your biggest concern of them all :

Permissions

Execute permissions default to members of the sysadmin and setupadmin...

This adds a linked server on the sql server.  This then allows you to do something like this :

Select * From LinkedSvr.DatabaseName.dbo.TableName inner join...

Good point, but the fact is that if the other guy is not around anymore, it'll be hard to get this answser from him.

I just thaught that he wanted to take 2 columns into 2 rows... must have misread that problem.

Select 'Multiply' As FormulaName, mutiply as Output from table

union all

Select 'Add' As FormulaName, Add as Output from Table

Check out sp_addlinkedserver in the books online.

Maybe it was created like that to make sure that all newly created Dbs had at least 4 gigs of log files.  That would make sens on a lot of...

I'm sorry but adding a column without altering anything in the system is just impossible (unless you use a single table for the whole database or othere pointless technics).  I'd...

How about you post the proposed solutions here so we can point you in the right direction?

Unless the index is unique (UQ) or a primary key (PK).  There's no way to get this info out of sql server (2000).