It depends on exactly what you are trying to do with the data. You could do linked servers or use SSIS to copy data to a new database.

Grant Fritchey (11/7/2009)

---

As far as the cool kids club, I snuck in the back door and I'm trying to be quiet lest anyone notice (not doing a good job there...

Flo,

Glad to see you back. I can relate to the addiction.

I'm hoping that you've learned that this is not the best way to do this.

Great, and just how do...

I'd not recommend it for the reasons already mentioned.

It has been proposed for next year with a few other people on board.

I'm out there (@unclebiguns).

Conference hasn't even officially started yet and my head is spinning. Already met most of the people in my list. Already worth the trip. I highly recommend making...

Orlando FL. Pretty much as far as you can get from Seattle and stilbe in the continental US. 4 hrs to Albequerque and now 3 more to Seattle.

At the airport waiting for my flight to PASS Summit. Still have 10 hours before scheduled arrival in Seattle. I hate traveling!

igngua (10/30/2009)

---

it finally worked!!!!!

I did everything again...and it seems some user config was missing.

sp_addlinkedserver '<Server Alias>', '', 'SQLNCLI', NULL, NULL, 'SERVER=<IP>', NULL

sp_addlinkedsrvlogin '<Server Alias>', 'false', NULL, '<username>', '<password>'...

I have a question. What is the problem you are trying to address by monitoring blocking? Are processes timing out?

Well, the performance counter dmv's will show how many blocks but not what.

The Default Trace does not have blocking or deadlocking, you could set up your own server-side...

BIDS is like SSMS, it is installed once on a server and then you can use the data connections to connect to any instance on the server.