From 5fb0455e929d96efb41d23f67653b329792ab834 Mon Sep 17 00:00:00 2001
From: Chris Hart
Date: Wed, 1 Jun 2011 04:01:18 +0100
Subject: Updates to MSSQL to most recent compatibility, also included
 Windlight support. Needs plenty of testing but clean install and migration
 from 0.6.9 have been tested and work, a few indexes still need to be added
 for performance.

---
 OpenSim/Data/MSSQL/MSSQLRegionData.cs | 1 +
 1 file changed, 1 insertion(+)

(limited to 'OpenSim/Data/MSSQL/MSSQLRegionData.cs')

diff --git a/OpenSim/Data/MSSQL/MSSQLRegionData.cs b/OpenSim/Data/MSSQL/MSSQLRegionData.cs
index cdf8ec0..3ae87c3 100644
--- a/OpenSim/Data/MSSQL/MSSQLRegionData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLRegionData.cs
@@ -70,6 +70,7 @@ namespace OpenSim.Data.MSSQL
             string sql = "select * from ["+m_Realm+"] where regionName like @regionName";
             if (scopeID != UUID.Zero)
                 sql += " and ScopeID = @scopeID";
+            sql += " order by regionName";
             using (SqlConnection conn = new SqlConnection(m_ConnectionString))
             using (SqlCommand cmd = new SqlCommand(sql, conn))
             {
-- 
cgit v1.1