Perhaps I misunderstood the original question. Are you simply trying to find the compatibility mode of databases on a SQL Server 2008 instance rather than check the version of SQL...

SELECT SERVERPROPERTY('productversion')

This returns it in the form of major.minor.build.

I know this is common in web code due to the vast compatibility differences and the fact that you have little choice...

What does the event viewer message say? You can double check which logs directory to look in by looking at the path to the executable for the agent service.

In the...

You can usually get more information by looking in the SQLAGENT.OUT in your SQL Server logs directory...

The path is something like C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG by default

True - a series of conditional statements isn't too arduous though as it's a relatively small list

The Datepart argument of DATEADD cannot have a variable passed to it according to BOL:

http://msdn.microsoft.com/en-us/library/ms186819.aspx

datepart

Is the part of date to which an integer number is added....

Hmm, not sure it's fair to say that they all just run the same query against the servers. Some of them are pretty in depth about the performance counters they...

I believe this is an informational message and can be ignored. It's a performance optimisation that can only be used if the SQL Service account has privileges to lock pages...

Well, the only feasible way I can think that could occur is if you have a date value that's less than 90 days from the max for datetime (December 31,...

No, you don't have to enable Service Broker (although you're correct that it uses it). It works regardless of the Service Broker option.

My experience with Database Mail is that it's...

There's probably a better way, but doing a meaningless cast or similar so that the output column has no name acheives this result:

declare @tab table (col xml)

insert @tab

select '<element/>'

select ...

bpportman 52825 (3/9/2011)

---

@HowardW - please ignore my typo for the second query. What is important is the developer states the first query does not return data under 2K8 but...

This code is not correct (and won't run) as it references B outside of...

This doesn't have anything to do with the move to SQL Server 2008. You need to convert any non-unicode strings to unicode before they reach the destination in your data...

You have no control about what the web service does after you've made your call. I guess it's likely that you'll physically be able to push data out to a...