• Are you sure you're comparing to the correct instance?

    When I run this PoSh code:

    Add-PSSnapin SqlServerProviderSnapin100

    Add-PSSnapin SqlServerCmdletSnapin100

    Set-Location SQLSERVER:\SQL\orlando\sql2008r2$i = ls

    $i | %{$_.Databases}

    This is what is run on the instance when the ls is run:

    exec sp_executesql N'SELECT

    dtb.collation_name AS [Collation],

    dtb.name AS [DatabaseName2]

    FROM

    master.sys.databases AS dtb

    WHERE

    (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'master'

    exec sp_executesql N'SELECT

    dtb.name AS [Name]

    FROM

    master.sys.databases AS dtb

    WHERE

    (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'msdb'

    exec sp_executesql N'SELECT

    dtb.collation_name AS [Collation],

    dtb.name AS [DatabaseName2]

    FROM

    master.sys.databases AS dtb

    WHERE

    (dtb.name=@_msparam_0)',N'@_msparam_0 nvarchar(4000)',@_msparam_0=N'msdb'

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato