Please post the DDL, some test data, requirements, and the desired results. I can almost guarantee you that we can eliminate the existing cursors.

Yes the cursors are...

halifaxdal (1/7/2009)

---

The sp is out of my control, it returns too many columns, I just don't want to manually create replicate those columns on my side, and I might need...

You don't need to use openrowset. You just use Bob's solution with the EXEC.

What are you doing with data after you retrieve it from the remote server? Does...

Great glad I could help.

Michael Earl (1/7/2009)

---

I stopped at one in NH a few years (possibly like 7) back that had a drive through window. I was on my way to Maine -...

You just need to go into your linked server properties and enable RPC and you should be all set.

Now don't get...

Well, it has 2 Senators like every other state and has to deal with...

You can create a linked server using that user and then use 4 part naming to execute the sp.

linkedserver.database.schema.storedprocedure.

GSquared (1/7/2009)

---

The first thing I'd do is break the proc into smaller procs and have it all called from a master proc. Then you can tune each one.

As written,...

I'd agree with Steve, especially now that the ReportViewer control is available and you can write reports within your applications. ActiveReports is pretty good.

Are you sure that This.UserName is returning the name in the format you need?

I guess you can't argue with that. The worst part...

You definitely want to use a database role to grant permissions and then put your login/user in the role.

Grant Fritchey (1/7/2009)

---

He...