You can create a linked server for that. Coordinate with firewall team and create the connection.

You can also create an export/import job that exports the data from one and...

Try using aliases between your derived tables, nested tables and outer tables. This would help significantly for us to understand - but also will straighten out what you are...

You can try doing an alter proc if the proc exists. Else you can script out all perms and then reapply perms post script update.

Log shipping could work

SSIS could work

Please give us more details as to what you are trying to accomplish.

By those standards, I don't qualify either.

Evil Kraig F (11/28/2011)

---

SQLRNNR (11/28/2011)

---

Evil Kraig F (11/28/2011)

---

GSquared (11/28/2011)

---

Brandie Tarvin (11/28/2011)

---

I just love...

Evil Kraig F (11/28/2011)

---

GSquared (11/28/2011)

---

Yep! ...

Pam Brisjar (11/28/2011)

---

Yeah, I stumbled on that just before you posted (see above). That...

To get to parameters - select manage from the dropdown error for the report in question.

Pam Brisjar (11/28/2011)

---

Update: user wanted two more filtering fields so I added those in and those two *do* show up with a default value of all/NULL (using the default default...

Nice job Roy.

Nice hot topic button Andy. If you are already under a fair amount of stress, adding this outside stress compounds the problem. Being able to communicate the cause...

Stocky

You are welcome. I hope it continues to work well.

Thanks Hugo