From what I have seen- yes, but you don't need to.

In other words - if you install one, then the other, the executable for the first SSMS remains...

If I may ask - why is there a hangup about making a connection to the server?

If you can dynamically build the connection string to multiple databases, you can...

Please take a look at what Jeff mentioned: assuming the data is structured as he mentioned (which would be standard for an adjacency), simply listing out the childID's from your...

haiao2000 (10/3/2012)

---

Matt,

Actually, I know which is base and recursive parts, what I don't know is which part in that entire code triggers the retrival of data. Is it the...

Also - the desktop's hardware isn't all that different from the server, so I'd expect the performance to not be that far off. Frankly the hardware raid is...

This is the "base" part of the CTE

WITH TempCTE AS

(

SELECT ParentID, ChildID, 0 as Depth

FROM Table1

WHERE ParentID=1

UNION ALL

SELECT T1.ParentID, T1.ChildID, Depth +...

Jeff Moden (9/27/2012)

---

Heh... whatever happened to the idea that you can write bug-free database code? Am I the only one that still thinks that should be the rule rather...

coronaride (9/28/2012)

---

Ok, what am I doing wrong here?

declare @nblah nvarchar(max)

set @nblah = convert(nvarchar(max), '')

set @nblah = cast(replicate('0', 9000) as nvarchar(max))

select len(@nblah), datalength(@nblah)

This results in:

8000, 16000

Doesn't matter what I change the...

I would say it's a limited use case. The models are much too simple to really be apple to apples. He also makes no effort to show what...

opc.three (9/27/2012)

---

That may execute but when you go to do the insert using 4-part naming...

this may fix your prefix issue:

EXEC('use CORELIBRARY_ARCHIVE;SET IDENTITY_INSERT dbo.MessengerLog ON') AT [NAS2-RPS];

From this article on MSDN, there were no features discontinued specifically in R2 (i.e anything more than what was on in 2008).

http://msdn.microsoft.com/en-us/library/ms144262(v=sql.105).aspx

So what worked in 2008 should still work in...

One more comment: you might care to change this to be a "pull" rather than a push. As in - define the stored proc on the [NAS-rp2] server and...

Kristian Ask (9/27/2012)

---

Not to look down on test like unit-test but even if the tests are well-written they hardly find more than 40% of the bugs anyway. There's a fine...

It makes sense from an ACID point of view.

Since you're calling the stored proc as part of an INSERT statement, the consequences of the procedure being called should only be...