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).

Please post sample data, required results from that data, the solution you currently have and what is wrong with it.  That'll get you an answer much faster than you can...

As far as I know this is pretty hard to do.

The only thing I can think of is to create a new table with the correct properties set up.  Then...

That means that you are restoring the files to a destination that already exists.  That would be a huge a warning to me that you were about to destroy a production...