This was a stupid question because there were actually 3 correct answers.

sp_tableoption N'Employee', 'text in row', '2000'GO

sp_tableoption N'Employee', 'text in row', 'ON'GOsp_tableoption N'Employee', 'text in row', '2000'GO

sp_tableoption Employee, 'text...

I try to stay away from single table schemas for any solution. However, if I understand your question, I would simply have a table containing columns that could contain all the...

I am afraid that is not going to work lakshman. The tables referred to have some of the same columns in them and some different.

Your question is certainly valid, but you do not want to try and reference an index to accomplish your objective. One possibility for ordering your data in a linear format...

I agree with dbamarks post. Likely what was taking place at the time of shutdown was a transaction that had been running for quite some time. It will likely take...

Create a table (newtable) containing all the necessary columns

insert newtable(columnthatapplies1,2,3,4,n)

select column1,column2,3,4,n

from Servey1

insert newtable(columnthatapplies1,2,3,4,n)

select column1,column2,3,4,n

from Servey2

insert newtable(columnthatapplies1,2,3,4,n)

select column1,column2,3,4,n

from Servey3

If the proc works when called from query analizer but not from your trigger I would suspect that there is a problem with the trigger. Specifically, I would suspect that...

Outstanding!

Can you post the code for the trigger. Also, make sure that you do not have another trigger on the table that gets written to.

It may not be ideal for your case, but with the logic I proposed it is easy to go from A,B conditional B1 B2,C where you would skip B1 and...

The suggestion presented would work, but as to your question about conditional logic in DTS, yes, there is a way. What you have to do is have the active-x step...

I agree with jordanac. I suggest pumping the oracle numeric data into a SQL varchar column. Then you can simply change the type of that column to float if it...