Review the documents here:

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

Under the Enterprise Manageability section you will find whether or not Express supports Database Mail.

Check the properties for the cluster group - verify whether or not you have turned on 'Allow Failback'.

We always disable this feature and 'Prevent Failback' on our clusters.

What node is currently hosting SQL Server and is that the same node you are looking at in Configuration Manager?

Jack Corbett (10/9/2009)

---

I've never run an in-place upgrade, but I would be very concerned if the master database was still in 8.0 compatibility mode. To me it sounds like...

I have found the easiest method of defragmenting database files is to backup and restore the database. When SQL Server restores a database, it creates brand new files for...

GilaMonster (10/8/2009)

---

SELECT @XML = '<outer>

<inner>

value

</inner>

</outer>'

SELECT @XML = '<outer><inner>value</inner></outer>'

Edit: It's the presence/absence of line breaks. If there's a linebreak anywhere in the code block, the < and > come out correct....

GSquared (10/8/2009)

---

select cast('<row A="A" />' as XML)

Very weird! This even runs correctly in SSMS, and I really don't see the difference between it and the prior post. I...

SELECT <Something> FROM SomeWhere WHERE ...

Well - that didn't work either...

Dang it...

I played around with it a little and preview works fine, even if you put in < and > - not sure what is going on there.

SELECT <column list>; FROM <your table here>

SELECT <column>

Like this?

Edit: interesting, worked on preview - then gets modified as above.

Download and install Redgate's SQL Compare and SQL Data Compare. Use them to compare the model databases on each instance to find out what is different.

I would recommend using...

Using the last example I had - which I am assuming is the one that you are using for JLOutcome, it should be the same as this:

if NA1=Appt1 then NA1

if...

Okay, as far as using CTE's - that is something you can look at in the future. It is just a way of 'naming' a query and using the...

That quote is a bit mis-leading because it implies that there is something that needs to be done to 'upgrade' the database application.

The only issues that have been identified that...