I have used bcp to transfer tables with more than a billion rows. What is the error message you are receiving?

Just so we're on the same page, and in case it changes your response...the "Native Client" driver, ODBC driver and OLE DB driver are all part of the "SQL Native...

vritaz09 (3/5/2011)

---

I dont have full version of sqlserver.In my web hosting plan i have express edition so i cant use sql server agent.so i searched about service broker.so how can...

I am seeing two separate issues here:

1. Your instance is unable to connect to other servers using Linked Servers.

2. Other instances are unable to connect remotely to your instance using...

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.