Did you upgrade the server recently, for example by applying a Service Pack or Cumulative Update and not update the SQL Server Native Client on all the clients running Access?

I would like to help. Can you please post the DDL for your table and some DML to load it with some usable test data?

Can you please post the query you're looking to modify and maybe an example of the resultset you would like to see after you modify the query?

Also, what are the...

CELKO (3/6/2011)

---

Spend the money on a proper audit tool. It will work better, run faster and keep you out of jail. Seriously. Triggers do not record who sees the data...

I tried to recreate your issue but was unsuccessful.

Can you please provide:

- version of remote server

- the DDL for your remote table

- the DML to fill the table with the...

You cannot pass a variable into the OPENROWSET function for the query parameter. This is what you have:

...

SET @Cmd = @IpStoredProcName + ' ' + @OpParms

SET @Cmd = 'Set FmtOnly...

I Googled "xml to tabular resultset using schema" and our ongoing thread is the 8th result 🙂

Thanks for your comments, I can better understand your problem domain now, but I...

Thanks for posting your DDL and DML...I think it might be incomplete however.

SPtiruttani (3/3/2011)

---

Hi all,

I'm looking for the query to replace zero value from the another row in the same...

DDL = Data Definition Language, i.e. your CREATE TABLE statements.

DML = Data Manipulation Language, i.e. your INSERT statements to build the data in your tables that we will need...

SSMS 2008 R2:

File > Print

Check the box "Include Line Numbers"

You could use SQL Agent on your 2005 instance to execute a script that uses the WMI Win32_Process class to execute dtexec on the remote server.

I have participated in a migration from Sybase to SQL Server...I was handed specific requirements to cleanse and standardize the data during the migration. I evaluated several options including SSIS...

Sure, nor did I obviously 😀

I am trying to further this example to learn how to present multi-level...

drew.allen (3/3/2011)

---

opc.three (3/3/2011)

---

Try this:

SELECT b.value('(offerId)[1]', 'Int') AS [offer_id],

fr.value('(internetPrice)[1]', 'decimal') AS [internet_price],

fr.value('(newStandPrice)[1]', 'decimal') AS...

You're very welcome 😀