Re: SQL Server OpenQuery takes forever to run using linked server to a Progress Datab
Really Tom? Really? That's the best you can do? That's the sum total of your wit? Tom, come on you can do better than that? Sharpen my resume? I'm going to use that one Tom. I am better for reading it...
I have read many posts here about Updating Statistics on the Progress Database but what can I do if I do NOT have permissions to do anything BUT read tables and import data? I am running a query...
SELECT
* FROM OPENQUERY([HAGEN], 'SELECT "Job-ID", "Entry-Number", "Sub-Job-ID", "Form-ID"...
I have a SQL Server 2008 database and a Linked Server (HAGEN) linked to a Progress database. All I do is run an OpenQuery to Select data and insert it into a temp table in SQL. Then I Pull Data from the Temp table to insert into a permanent table in SQL. I have several stored procedures with...
I have a SQL Server DB and I have DTS packages importing tables from Progress. Everything works wonderfully but sometimes data will be missing in random fields but the data is there in the Progress DB? Anyone else had or have this problem or a solution?
Thanks
Mike
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.