A bank IT manager cannot do a linked server with live deposits Microsoft actually works with banks to use just one or two accounts for all access to each database...

Transaction is a unit of work a SELECT statement with linked server running for five hours?

This problem started with Win2003 when IIS comes with most components needed to run Asp.net disabled, Vista has taken it one step so try the link below and enable all...

Hi Lynn,

The index column include is from Microsoft not ANSI, I think it is one of the best new features in SQL Server 2005 because it let you add columns...

Grant,

Microsoft is just joining the party because Oracle have been running Java runtime in memory since oracle 8i or 9i and a .NET runtime albeit out of process is in...

Ignorance and intolerance.

Thanks

(The ultimate ETL tool is a SELECT statement. The ultimate BI tool is Excel. Just about everything else is a waste of money.)

A SELECT statement is algebraically flawed so...

It is healthy to disagree I for one can agree with some of Stephen's points but I have to disagree with you because you are saying things I did not...

(One level up (theory), how is ETL relational calculus?)

I did not say theory you did, and what a feeling powerful solutions no six figures required.

Chris,

Actually you are trying to be difficult because, since I am ignorant maybe you should write the SELECT statement that takes DB2 AS400 deposits and load them to SQL Server...

(A SELECT statement is algebraically flawed so it is a mute point it can do calculus, here is what I know you can do with ETL transferring DB2 AS400 deposits...

Stephen,

Our conversation ended by you saying SAS is an over priced calculator, if you work for pharma your opinion is not relevant because about 30 pages of the 500 pages...

I have edited my post the correct section was Transformations supported and you link in my opinion is just plain generalization because in places prediction that is data mining related...

It does but your opinion is yours here is one about SQL Server Integration Services go to the Tranformation supported section it includes calculus operations.

http://en.wikipedia.org/wiki/SQL_Server_Integration_Services