GilaMonster (5/7/2010)

---

Problem with that is if...

GilaMonster (5/7/2010)

---

Likely that's exactly the point, to tell what version a detached DB came...

What would be the point? You could only even attempt this for a detatched DB.

Check for the existance of a logon trigger

For my servers, I've just accepted the defaults, and on a couple of them increased data retention and also compressed a few tables and indexes. Nothing you can't easily...

bteraberry (5/6/2010)

---

This article[/url] indicates that the bug with SQL Server 2000 that required the Outlook client to be installed for the missing dll's was corrected with Service Pack 1.

It's been...

I have to agree with Jason entirely, and I'm not sure you even have an understanding of what SQL is and how it's used. I say that because you...

Your welcome

There's a lot of things that get left behind during un-installs. I've never unistalled anything from a cluster, I would consider it bad practice.

I think you would benefit more...

gregory.perry2 (5/6/2010)

---

I am new to SQL Server and am confused about how to change between databases. Heres my problem.

I have 3 different databases connected in Management Studio. One...

SQL 7 and SQL...

RonKin (5/6/2010)

---

I have a test cluster 2-node (SS 2005 x64) I am almost through with uninstalling SS2005 manually from node1. What do I need to do in...

Yesterday R2 was released to MSDN subscribers, so hopefully some of them can chime in. I am just doing my first install, so I can't comment yet.

Also, I think backup compression is available in R2 standard, but only in RTM/SP's enterprise. That is a big selling point.

I'm just doing an installation from MSDN, but from someone's perspective who has not touched OLAP in 7 years, I think Central Management is supposed to be the largest difference.