SQL Server books online, for local installation, can be downloaded from http://technet.microsoft.com/en-ca/sqlserver/bb428874.aspx

it is working with 100+ rows in my case.... have u tried without openquery?

select top 102 * from ORALINK..SCHEMA.ORATABLE

EXEC master.dbo.sp_addlinkedserver @server = N'ORA_LINK',

@srvproduct=N'Oracle', @provider=N'MSDAORA', @datasrc=N' '

then u can select from the above oracle database as below

select * from ORA_LINK..SCHEMA_NAME.TABLE_NAME

ROWIDs represent the physical location of a record/row.

And most important part is ROWID can change if the row is moved as in index organized or partitioned tables.

the design is not very clear to me from the statement. however, joining the fact tables into one can be an approach

SELECT DepSector, [00001111] as [DepRevenue_00001111],[00002222] as [DepRevenue_00002222], [00003333] as [DepRevenue_00003333] FROM DepRev

PIVOT

(  max(DepRevenue) for DepId in ([00001111],[00002222],[00003333]))

AS pvt

order BY DepSector

note that: dynamic column creation is not supported in pivot,...

why dont u use sql server to create the job by just right clicking the dts and selecting the "schedule package" option? the job will still use dtsrun with encrypted...

see http://www.dbforums.com/showthread.php?t=1617261

space savings done by such changes are preserved within the database for future use. a shrinkdatabse might release the space to the OS.

this needs a trick to be applied... check the link below...

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/rowset-string-concatenation-which-method-is-best.aspx

backup is a preventive measure, so u will have to backup first and then use the backup in case of failure. as u can expect, sql server will not give...