Are you using CTP version of SQL server?

Try running rebuilding the indexes using DBCC DBREINDEX or ALTER INDEX commands and see what will you get?

You may need to apply the sp2 hotfix (3152) if you are using MPs...

To understand sql memory architecture...

Did you install DTS addins (SQLServer2005_DTS.msi) for sql server 2005?

http://www.microsoft.com/downloads/details.aspx?familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

Try the following...

SELECT l.LocationID, l.Title FROM tblLocations l

join tblContact c on l.LocationId = c.LocationId

join tblSpecialities s on s.SpecialityId = c.SpecialityId

where s.SpecialityID = @SpecialityID

Is backup location is local?

Under what account sql agent service is running?

I think You should be sysadmin on both servers to configure log shipping...

You have to have read/write permission...

In sql 2005 EE you can configure oracle as publisher...

See BOL topic "Configuring an Oracle Publisher "

Looks like you are reading encrypted data.

Can you query the data through Query Window?

Are you looking for sp_addextendedproperty procedure?

select

name, collation_name from master.sys.databases

select

object_name(id