Thanks for all your help with this issue, and I will be using the OPENQUERY workaround.  I am still curious of why the query (Select * from PROD..APPS.PER_ALL_PEOPLE_F) is not...

Using the openquery function worked.  I can use that as a work around until I can get the standard linked server issue worked out.

Thanks for your help.

I have seen that problem with number fields as well and like you,  I normally handle that with a view.  But what I am seeing is on this on is on...

It would not surprise me if this is true.  From what I have been hearing about the Team Foundation Server (TFS) for Visual Studio, the new Visual Source Safe is...

JP is right.  You need to understand why are you creating the index.  If it is just because that the table doesn't have a clustered index, then maybe don't create...

1)  Create a backup of the database. 

2)  Drop the database.

3)  Recreate the database.

4)  Restore the backup to the database.

1) First do a quick scan of syscomments checking for any drop index command.  For example, select * from syscomments where text like '%drop%'

2) Create a stored procedure to check...

We use a great tool here AdeptSQL DiffTool (http://www.adeptsql.com/). 

One thing that you forgot to mention, when rebuilding the indexes you can specify a fill factor for the index.  This is helpful if you have a clustered index where...

The link server is a good idea, if you are comparing a amount of data then that link gets to be very slow.  Copy the data from the oracle db...

I think that is there for if you are wanting to do replication or remote data access.  If you are doing replication, then Merge replication is what is recommended between...

Please correct me if I am wrong, but my understanding is that SQL Server CE installs on a Pocket PC device, it is not a server based product.