Mantis #2124

Thank you, RuudL, for a patch that brings MSSQL up to the same
implementation level as MySQL.

1 files changed, 6 insertions, 6 deletions

diff --git a/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql b/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql
index 4e64901..15b39a7 100644
--- a/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql
+++ b/OpenSim/Data/MSSQL/Resources/004_RegionStore.sql
@@ -1,6 +1,6 @@
 BEGIN TRANSACTION
 
-CREATE TABLE dbo.Tmp_primitems
+CREATE TABLE Tmp_primitems
         (
         itemID varchar(36) NOT NULL,
         primID varchar(36) NULL,
@@ -22,15 +22,15 @@ CREATE TABLE dbo.Tmp_primitems
         groupPermissions int NULL
         )  ON [PRIMARY]
 
-IF EXISTS(SELECT * FROM dbo.primitems)
-         EXEC('INSERT INTO dbo.Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions)
+IF EXISTS(SELECT * FROM primitems)
+         EXEC('INSERT INTO Tmp_primitems (itemID, primID, assetID, parentFolderID, invType, assetType, name, description, creationDate, creatorID, ownerID, lastOwnerID, groupID, nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions)
                 SELECT CONVERT(varchar(36), itemID), CONVERT(varchar(36), primID), CONVERT(varchar(36), assetID), CONVERT(varchar(36), parentFolderID), invType, assetType, name, description, creationDate, CONVERT(varchar(36), creatorID), CONVERT(varchar(36), ownerID), CONVERT(varchar(36), lastOwnerID), CONVERT(varchar(36), groupID), nextPermissions, currentPermissions, basePermissions, everyonePermissions, groupPermissions')
 
-DROP TABLE dbo.primitems
+DROP TABLE primitems
 
-EXECUTE sp_rename N'dbo.Tmp_primitems', N'primitems', 'OBJECT' 
+EXECUTE sp_rename N'Tmp_primitems', N'primitems', 'OBJECT' 
 
-ALTER TABLE dbo.primitems ADD CONSTRAINT
+ALTER TABLE primitems ADD CONSTRAINT
         PK__primitems__0A688BB1 PRIMARY KEY CLUSTERED 
         (
         itemID