Sort Order of "Computer in Domain" view

[mbrooks]

Strangely enough, overnight, the list order in this view seems to have changed overnight and is unsorted. Clicking on the Computer column header resorts, but navigating to a secondaary view and then "back", the list is unsorted again. Any ideas?

[Hemoco]

The list was never sorted by default.
It must have been a coincidence that it looked sorted.

[mbrooks]

Seems to have fixed it! Not being much of a dba, what did we correct? What was out-of-whack?

Thanks

[Hemoco]

try this sql code:

ALTER PROCEDURE dbo.Web30computers
(@domain varchar(80))
AS SELECT     dbo.tblComputers.Computername, ISNULL(dbo.tblOperatingsystem.Description, '') AS thedescription, dbo.tblOperatingsystem.Caption AS OS, 
                      CASE ISNULL(dbo.tblOperatingsystem.Description, 'NOT SCANNED') WHEN 'NOT SCANNED' THEN 1 ELSE 0 END AS Notscanned, 
                      CAST(dbo.web30ProcessorCapacity.NrOfProcessors AS varchar) + ' * ' + CAST(dbo.web30ProcessorCapacity.MaxClockSpeed AS varchar) 
                      + ' Mhz' AS Processor, CAST(CAST(CAST(dbo.tblComputersystem.TotalPhysicalMemory AS bigint) / 1024 / 1024 AS NUMERIC) AS varchar) 
                      + ' KB' AS Memory, dbo.tblComputers.Lastseen, dbo.tblComputers.LastknownIP, dbo.web30repallcompstates.Thestate
FROM         dbo.tblComputers INNER JOIN
                      dbo.web30repallcompstates ON dbo.tblComputers.Computername = dbo.web30repallcompstates.Computername LEFT OUTER JOIN
                      dbo.web30ProcessorCapacity ON dbo.tblComputers.Computername = dbo.web30ProcessorCapacity.Computername LEFT OUTER JOIN
                      dbo.tblComputersystem ON dbo.tblComputers.Computername = dbo.tblComputersystem.Computername LEFT OUTER JOIN
                      dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername
WHERE     (dbo.tblComputers.Domain LIKE @domain)
ORDER BY dbo.tblComputers.Computername

[mbrooks]

I attached a screenshot but it appears early in this post. As stated earlier, if I click on the column header, the column wiill sort "almost" in alphabetical order, but when navigating to any link on the pagre and then back, the view is returned to its original out of order sequence

[Hemoco]

Which view has this problem (please post a screenshot if possible)

[mbrooks]

There were no SQL updates nor security updates applied!

[Hemoco]

Something must have happened.
Maybe security updates on your sql server?