The lists are always small (1-4 entries against 1-6 entries). I used a variation of your code Rookie to implement it as a user defined function (had to change the...

Sounds like you had a bad/old copy of the SP in the cache. The WITH RECOMPILE option might have fixed that. Or you could have cleared the cache with a...

A relatively new Dell (2.8Ghz) with CD-burner and DVD for me and the wife. A surplus Compaq Deskpro from work that's configured for me to use VPN to access work,...

Still, you have to run it against each DB as opposed to the posted SP which gets all the DB names from master.dbo.sysdatabases and recurses the list. OK, it uses...

Based on some quick empirical testing the above SP's only apply to the current database. The new SP posted above lists all relevant data (OK, we could add SID if...

Here's a version that doesn't require the DBRoles table and executes the final SELECT with parameters so you can just execute List_DBRoles and specify things like "@dbo='Y'

Unfortunately the mail body is an HTML page so it appears xp_sendmail won't work. As far as I can tell from BOL xp_sendmail only sends text messages...

I'll look at CDOLive....

Whoo hoo!! 

Thanks Steve.

I don't know if it would run any faster (or slower), but if you always want to truncate the right-most 3 characters wouldn't it be easier to use

SELECT (left(CONVERT(varchar, CAST(SUM(S526960.tappMonth2Date.Offered)...

Answer 2 is correct. The question clearly stated the aliases were to be "fixed". That does not imply dropped, but remapped.

Thanks, I'll try that...

In another vein, since I didn't receive any replies initially and I had to move on this app I constructed the following SP cribbed from MS code....

If my post was taken as critical I apologize. I was just trying to offer the script from the library as an example of a flexible way to provide date...

A very nice utilitarian date formatting function that mimics VB's date format strings is available at http://www.sqlservercentral.com/scripts/contributions/1007.asp

I highly recommend it for low transaction volume systems that have odd date...

I have to agree with Frank. I'm happy to see try/catch in TSQL. Right now I have to code all sorts of crap to handle exceptions that aren't MS' fault,...

I attended a webcast overview on SS 2005 and they talked very briefly about TSQL vs. CLR. They don't expect a mass migration to CLR. The presenter's take (he was...