Search results

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