nelsonj-902869 (4/1/2010)

---

CirquedeSQLeil responded:

Besides the side by side install, have you considered moving all of the databases to SQL 2005?

Eventually, we will convert the remaining databases, but several are...

WayneS (4/1/2010)

---

That discussion evolved from a comment being made about someone not thinking that...

Chad Crawford (4/1/2010)

---

CirquedeSQLeil (4/1/2010)

---

I enjoyed the blog post. I felt silly that I hadn't thought of a great idea like that (or blogging for April Fools Day). ...

Abhijit More (4/1/2010)

---

Hi All,

After doing some research I found this is becuase of max connection limit for the SQL node. and the siginificant part of sql memory has been ...

Five or more years of experience with SQL Server 7.0 or later: installing, configuring, and troubleshooting

One or more years of experience with SQL Server 2005 or later: installing, configuring, and...

You're welcome.

How big is the database? And log?

Yes you can install up to 50 instances of Enterprise edition on a single server.

Yes have done it. No, I did not encounter any issues.

Install the second instance as a named instance. My preference is also to assign a static port to...

Thanks for the links Paul.

And then it typically defaults to the first database when trying to do something like this.

As Paul suggested, dynamic SQL, SSIS package, nested stored procedures, synonyms or views could resolve...

Well put, and very thoughtful.

Absolutely, remove the logins. No sense in having something there that is unnecessary.

Besides the side by side install, have you considered moving all of the databases to SQL 2005?...

chrismat (4/1/2010)

---

I deleted the SP from the new db and recreated it; now it's working.

In order to test, I added "exec sp" to the end of the query...

So we have the model by PMP as one suggestion.

Anybody have anymore suggestions as to models to research and potentially emulate?

I think the direction the conversation needs to go would...

Good Luck....