Correct Ans is only option #2, please see below queries. Output does not match with the desired output of question. PLEASE REMOVE "The solution should be:" FROM THE QUESTION. Such...

I react without reading entire forum's discussion..

This was a flaw in SQL-Server until compatibility level:90. :w00t:

So far I was understanding based on queries executed many time... This quation and...

Given Ans is incorrect query will work without any error, Option "A" is correct.

On getting incorrect ans, I have tested on both Sql-Server 2000 and 2005; this works properly, without...

Hi

Following script will give you file name, database name and its sizes.

SELECT

      alt.filename [File Name]

      ,alt.name [Database Name]

      ,alt.size * 8.0 / 1024.0 AS [Originalsize...