Here's a script I use to get the this information. It provides pretty much the same information.

/*

This script displays SQL Server version information, but it does not

identify the service pack....

Here is a query that I've used to query the default trace. To use it, run this statement to get the path of the current trace, and replace 'PATH' in...

Thanks for your reply. I was able to fix it by deleting the user accounts from the affected databases and recreating them via the User Mappings page.