diff options
| author | Chris Hart | 2011-06-01 04:01:18 +0100 |
|---|---|---|
| committer | Justin Clark-Casey (justincc) | 2011-06-01 21:01:04 +0100 |
| commit | 5fb0455e929d96efb41d23f67653b329792ab834 (patch) | |
| tree | b28593f324ba685cd3c4d23036438a4890bb7bb8 /OpenSim/Data/MSSQL/MSSQLRegionData.cs | |
| parent | a few minor formatting tweaks (diff) | |
| download | opensim-SC_OLD-5fb0455e929d96efb41d23f67653b329792ab834.zip opensim-SC_OLD-5fb0455e929d96efb41d23f67653b329792ab834.tar.gz opensim-SC_OLD-5fb0455e929d96efb41d23f67653b329792ab834.tar.bz2 opensim-SC_OLD-5fb0455e929d96efb41d23f67653b329792ab834.tar.xz | |
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.
Diffstat (limited to 'OpenSim/Data/MSSQL/MSSQLRegionData.cs')
| -rw-r--r-- | OpenSim/Data/MSSQL/MSSQLRegionData.cs | 1 |
1 files changed, 1 insertions, 0 deletions
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 | |||
| 70 | string sql = "select * from ["+m_Realm+"] where regionName like @regionName"; | 70 | string sql = "select * from ["+m_Realm+"] where regionName like @regionName"; |
| 71 | if (scopeID != UUID.Zero) | 71 | if (scopeID != UUID.Zero) |
| 72 | sql += " and ScopeID = @scopeID"; | 72 | sql += " and ScopeID = @scopeID"; |
| 73 | sql += " order by regionName"; | ||
| 73 | using (SqlConnection conn = new SqlConnection(m_ConnectionString)) | 74 | using (SqlConnection conn = new SqlConnection(m_ConnectionString)) |
| 74 | using (SqlCommand cmd = new SqlCommand(sql, conn)) | 75 | using (SqlCommand cmd = new SqlCommand(sql, conn)) |
| 75 | { | 76 | { |