quote:

---

I suggest personally use the reusable SP as base concept and create new SPs based on it with their own code...

Configure your server for Openquery

1) sp_addlinkedserver SERVER_NAME

2) EXEC sp_serveroption 'SERVER_NAME', 'data_access', 'true'

Then run:

3) select col2, col1 from openquery(SERVER_NAME, 'exec DB_NAME..SelectStuff')

sp3a should be used instead as it fixes sp3 installation & slammer issues