There would appear to be an error in CASE statement as there are two when 3's ?

I am able to create the synonym and select from the table just fine in 2008 R2. The question specifically states the table exists hence the command will work...

The script has a minor problem in that if a database has multiple data files (.ndf files) then there is a backup command generated for the database once per file....

Alex, Nice set of fixes. The procedure had compiled for me, but execution was failing looking for a database named UP. I had another piece of code to...

Josha, what is the main difference from this version and the version your wrote in July 2007 and updated in May 2009 that also performs a string search?

FYI - running the posted statents using 10.50.4000 I got a response with only the message tab back with the message "Command(s) completed successfully"and 0 rows listed in the bottom...

I knew this and yet I marked the question wrong because instead of thinking what was asked all I could think about was that the data rolled back. I...

I am not a T-SQL person since I am primarily an Oracle DBA, but I did notice the single quotes and it make me think. The equivilent SQL in...

The question specifically states 2008+ and on 2008 the syntax is invalid. The first answer is the correct answer, not the answer you indicate.

Grasshopper, both your posted SQL statements result in invalid length passed to substring errors when I attempted to execute the statements on SQL Server 2008R2 RTM.

- -

HTH -- Mark D...

Another poorly worded question and answer set.

I think the posted query answers the question that was asked which I remember as being how to prove to the auditor via a query that the sa account requires...

Tested on 2005 and 2008 successfully. It errors on 2000 (no sys.sql_logins table after all)

-- Mark --

Now that you have pointed it out the extra 1 is plan as daylight. Here is my version of the query you posted.

select

name

,default_database_name

,is_disabled

,modify_date

from

...

Leo, maybe my eyes just cannot make out the difference but where is the difference from your WHERE line and the OR line condition? Should one of the entries...