Search results for query: *

Hi All, I'm looking for the cleanest way to postpone commiting a transaction until an update in a related table is complete. I believe Oracle has a deferred option associated with it's table properties but am thinking it's not as easy as that with a SQL Server tbl. There's probably going to be...

I still haven't found a fix for this. I'm working around it by pulling the data through ODBC and copying to a local database. This is not a preferred method b/c the data is updated only twice a day rather than being dynamic.

Thanks for your response. I did think about the possibility of row limitation but when I use the same driver to set up link tables from an Access db to the same files on the AS400 it works fine and pulls all records. Thats what makes me think it's either the way I set up the Linked server or the...

Hi All, I've recently started working with linked server functionality within SQL Server 2000. After setting up a linked server to an AS400 db without any issues the problem comes when I try to query the db. Using the Openquery method I try to pull ALL the records from one table (no filters or...