working with mysql RSS

• • Reply
  

  IanBotham

  Member

  4 Points

  10 Posts

  working with mysql

  Mar 05, 2009 09:33 PM|LINK

  Hi Sorry this is a very long post :( I have uploaded the site and via the servers cpanel created 2 databases (Personal and ASPNETDB). Following the guide I exported both mdf files in VWB2008 and saved them as .sql files. Uploaded them to the server and via mysql webadmin ran the query tool and imported them as files. Both files failed to import and give me this error: Server: localhost:3306 Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in C:\SWSoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\libraries\string.lib.php on line 100 Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in C:\SWSoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\libraries\string.lib.php on line 100 Warning: mb_strpos() [function.mb-strpos]: Unknown encoding or conversion error. in C:\SWSoft\Plesk\admin\htdocs\domains\databases\phpMyAdmin\libraries\string.lib.php on line 100 Error There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below: ----BEGIN CUT---- eNrtXW1z4jgS1tflV/jDVuX2aoYB8jqpuqojQLLcJiQLZOaqrq6oTJLJ5BYIG0hm53787T1q28EO BsuWLYuhixBsWZZaTz/dkvXmVrd73j10GlWnUXNOW51Dp+JUnb2DSmWv1Ovjyp+lUuND79D5sX1z 6Ex/H06uHqe3j+Xh/afy5MvkzbNTK9e2y7Vy1alVKjvvqtV31YpTqRzu4O/AGd6O3jutPybOj6Wz b71fTw+d3XKlXNt/e/0wGj2N72ff3o5npcte1znvvXHqJ61O/43zoYV8P96PnXbL2StXShdn9UNk g8O3k+F26eLnCxnlzXnPTW3X+djudPql03rn5NC5Hb99mn1+e1Ci3P783zvx18DHEefik/iPuBXX YiYOce6IY/EgHhFyL+7EWPyCo28I/RfCfxEDfK7EVExw5RZ3DMQZfmVoHWETMcRd8qwqdsSuaIgK wrdx578pZfnpIadHxJrgbkc0kdoMKcicK4j5Dv938b+G34p4j9Aq/h/iyi7+V3DmhOR/J0r4tJGD TLsl/onjnujj64i/4H9LnOLbQIhDpT0WXZT4DEdTlGoqyuJzqLQD8RuVd4oYH8XPuLeLr4M4c5QG iHuDsL8RekfiH14OA+TdRK4dsQW0bnDHA8pd1kZuS/yEnOpIt4nfCVKR8o4pDT25FuUZ4eot0p+K L6QjN/efCOU6sOwTIg5+68jhlLBJnqbUu9TDBY4a+O2QzrpIs43jfgZsk/KeIGX5mxfjLxEqy9X2 ZNjFpwLmtsS+OGDGayDHjE+OWZ6Mv8D5otVJmzsGT/fw28QvMz49cqYYf0G6+IIwXZ4HU0rPblV8 8mW3a2F+idqeDEeQqkH1SQ38ZHanR84cu12v+4CQK2LTf0myewqpI2T44kezsIBkuelYiRrORVjJ MeqfBkom2d5kK9FAzg4rca/6vM3XRl7nlb2FvMbYhIWEW2qylbaP7zGk2UGNxhaSHjm2EH0LicM4 Xwt5jJBB1l27kKJG3122EA3kzFnII658RipDhOjbQDg1HZar4ZQny7uIvfhMs03P6pKnVXq6YZan R84Uy6U8kpH6zwrBlNKzWxWfPNktLWtRhgpqD2lZdbIxbuXoIGeK3dk9CWfzlKuKjwl2+/ba9ixs H/nvUgtJPk8wu9MjZ57dbYRl58mXp6vP/DjsTDA/3HKSfbBH4GkNnx3u49dCjpmfHrtkzO/hyGXD jfdscU3HTxSm16t7I0Y4HuM7Rehj4NoAZZRXbih/1x7stZcg47K1knzxDFvRDKWZkE5lTMeT5wLf NzhzjxsB3s95ekFHDZSmCfZ1tXv7k5ZjPRjdJQuX6fTEF89jMb/NobuObI8vlT3cD4/RDSCVvE+O ItzhqEdnMyrpnVfTMduzxNNWficth72Mnlsjs9okpuvCbJWyrEdbpYl7h5TOrVdObqeYQHYd2yir S2SS78GRr7Bc4Wvsp5OiVRwvk0hpjmvzHpsBSiPju7zxw5lf8QgVxal4yextgfa49WkUz3Vpefa+ i1an+2TYwNkT9eWfw7tzu9MMtuvY8owr07r1C/sWzZw3gex69wdHlcgWvodn2nKrJcs50uvaZkla Clu5zH3AWfN5fXuA05TEVl7zaN2WQTTXg882jdSF+wH92kOGTkhaKRf37CbFypZ+3VUymmNZ1H4T 4T7C4OqxzWZZEqyKYlkSGc2xbD4n/zrge1/3RkfHYt7poVcUE/WkTsbND+Q5vy5I9IywgaJc9vLs 2StdthxLhk0UIz4g7RYk0kO96LrOn107H1s4Au4txLyiupr9T1rc7KoD4+W1k4kd3DvifvHUqK0D C+fSFs1B9/k3avch5p46WnZxbpmUxfVlnASefXmGWnKcbOnDWCafLT2+c+5HtT7bSJc5p4+gnT27 KpKb4+lH/H5CiZ5f1uyeIuZdIISZqIJRUVxTkS2/Pgs39wtaDTcLzH8YZN47W1vj3gsVlHT7MVTy KIIHwbWSzAV1pPLjQzifIjgR3mOZGaGCU358COZisn3s5xrud/fDudURj1Bx7ds4yfLzKqt2a9l0 T6KyQ04677E85WLWeQV7jrLnwPex0msZRjas9VomWzFs8o9b4g9vpjdzSQUhG5gULVl+9Q/XOPE7 yaarY4r3A8EVzbx6WB0hG/xAtGT5+YH1GSMy5w2ix4N0fEKRIzgNPMnItH4jjX6hEcwrSO+2g3kO YBKUivIQatKZrG1uxZ3XTnFXDDKzssCquBpIXUZzLLukZ3RmmvrOwuO1YFtSOU0yLrp/yLWQEc6f AzP8p9C1TH/EfTcZY1gcM/Vlt4GtcsV/cA5kH9eYo1kgZx8z4yS2gY9uP+k8xH33Aa9800fOPj7G SWwDHxdniQdjMB/TI2cfH+Mktsc/5j0m/P36x9Ujxjb6RxtGoletZuggBf+a3ANtLu857h8Sfuwp s8HQxtUsqrIXv5OCnAU4pt1ELuiOqfhKedyIX5HuLfUw+PugyXqgTutiv3LLM0dUbdudQa80dqzj 4j1p0mNl43qu4vakWbUDepvW+lyTXM+8y33m6Nm463281CbmwfI8pGXv/NWd65qn/qJq3HVY125O p3EI6eo5Lv2iW+iX+H/De51pYGVXazpaxqLbyK+fV7kdk679nBxHu9rWyeW3of+3jf/zdyzzSIQe Zvb1+S6XtfjaWfbmPdDcQq6d02BlW+0cJWPRLAvvYh7sf2OuJUfMLsatkrRo3vWYcxmgZRffepZy 7YS5lgFaNo6F2se1qGdw2a78TKkw45JjZn8fy1xWOz3dR1yVu2a48/1GJD1zUR/BdfCI0ZLbwVPf fnjXcX3MbOTiMlntY9/ck3O7MC1qtjMwLK19HOTd7tMjZjv3itjlXs6U++ax5oraqH38fuJRNkV8 int70Gq5ihgVC89K4tEIdYSKH/FaJlkxPOL366VDyAYeZfEuvbkv03tvOr+lRQ8vFT5dRjKoj7uO qNzZarAIHoXfgcssSoZW0Rx6LU9eDMp6L/HvYcdoM9pPu2+4qm55XW9yZPLXe1YrcFVZwHpfvt9q vprOX7fhWaWs39d4mPDi4Rzz0XNUTxxrOxqV/HUenW/edTjr2+wTXv5Pb+v3xnJzvder3leer95t eKO5O9fw6WWeq78DYPiND2E/xKxJh1pRfY/ppC2Og9OXtNyeiRHtojplr6WBmC3ci5c0nxpw8e2b 82NmVDw++deGcRLkw4vluzIzK+LQyZ8Tq/NPxgg5evsZ6TyBFTPKtwlkBwu7DdTJVwVbZ/JManEH WpU6bUB2e7lxEyrnANK5eM0g5RXpJmvO6OEYZtHEe+Op6wHMtfRdhh55e7aP6awOrPuEURZteifA /wZ+O6TXLu5o47ifASNL3qdFO3zlYx1ntBJ9EJgfLc+qYg+y7ECSGiSpsnXEWocqjqasY3kPV1aW saxnMa1VqCJowiqkDIPASFubznYgS0vsiwOUpoLSsVXEWYUqjqasIvq9zvq2EB4LT2sBqmiZsQB/ hsGA0L3xZGlBjgNCpYkztoB4C1DD0ZwFJJ3Jkp2NJJtxlN6K1BA3YUVdTwq/T8616G18pAxHYP97 yMRWFGdFqjiasqLot6/q20h4xkVaC1BFy4QFXNIM2UFglZH7rLNL3G2gbqvjPraAOAtQxdGUBUTv B6lvAeFR67QWoIqWSQs4I/zlbA9Xlj18m8i5TjUTW4CqBcThyBaQBC2TFiD3lJOruB48WfZp7+MK 7qlxH1MCC4jDkS0gCVo6FhAcz3AUV8EeUSzZn1zH95paezbvJT4NlPE1y8fe+l2XQ5Iv6RHYWhhV 6kEumdcZ4umim79ej8k/DDdWq1Hlz0an0cjmr1E5v2FCsxtm5M/uNla3q5HIRstxaGep79V9UZvl o9NhkVTnaRE3qfXN8eBpkMha4/l79TgJNtG/62GSNQfM+vzw7vub5eNVyp5cu2qI5qnFTfLZ8SXX 1aAJnxzOcTN9cBIMdHVq0scG3yCxSf41vtxJtaiCZF6a2xyfGldqHa3l70uDuZnxo9vWai9bH5oE 2Sw1urhmIk9btEubamVPqklVRJNp0eeHzX3+TdLVKXJ08f/7i9SdF024evM1I+9y34sSHTuLPn79 sTh3/8dPlL5s30wIuTHyuKexrmEM86JKtrjmRcbcQsytyFGtH1agG8RjFdKLaQTvlLvKPXnPzo80 9iVX5/WARpdwkb9uKlNvF8Nrbwx2HNpT9Qe0BGV7cIRr7ohb2ZPl6WWUzfFifiXbddd3Pnljg/7a Hz/O6/xGIZkXdeGPMfp3z6VZrtFHD8lBKPVpIJWgpPPYy3P3S+Hf/7oUy+6cx0/PxKCsQe0sZ+Nq PjovI62udNILthB/FX/+D26OZTo= ----END CUT---- ----BEGIN RAW---- ERROR: C1 C2 LEN: 0 1 68006 STR: ?VS: $Id: sqlparser.lib.php,v 2.23.2.1 2004/11/10 00:40:48 lem9 Exp $ MySQL: 5.0.27-community-nt USR OS, AGENT, VER: Win IE 6.0 PMA: 2.6.0-pl3 PHP VER,OS: 5.0.5 WINNT LANG: en-utf-8 SQL: ?****** Object: ForeignKey [FK__aspnet_Me__Appli__145C0A3F] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__145C0A3F]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]')) ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__145C0A3F] GO /****** Object: ForeignKey [FK__aspnet_Me__UserI__15502E78] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__UserI__15502E78]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]')) ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__15502E78] GO /****** Object: ForeignKey [FK__aspnet_Pa__Appli__45F365D3] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pa__Appli__45F365D3]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]')) ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__45F365D3] GO /****** Object: ForeignKey [FK__aspnet_Pe__PathI__4BAC3F29] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__4BAC3F29]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]')) ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__4BAC3F29] GO /****** Object: ForeignKey [FK__aspnet_Pe__PathI__4F7CD00D] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__4F7CD00D]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]')) ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__4F7CD00D] GO /****** Object: ForeignKey [FK__aspnet_Pe__UserI__5070F446] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__UserI__5070F446]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]')) ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__5070F446] GO /****** Object: ForeignKey [FK__aspnet_Pr__UserI__29572725] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pr__UserI__29572725]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]')) ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT [FK__aspnet_Pr__UserI__29572725] GO /****** Object: ForeignKey [FK__aspnet_Ro__Appli__32E0915F] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Ro__Appli__32E0915F]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]')) ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [FK__aspnet_Ro__Appli__32E0915F] GO /****** Object: ForeignKey [FK__aspnet_Us__Appli__0425A276] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__Appli__0425A276]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [FK__aspnet_Us__Appli__0425A276] GO /****** Object: ForeignKey [FK__aspnet_Us__RoleI__37A5467C] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__RoleI__37A5467C]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]')) ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__RoleI__37A5467C] GO /****** Object: ForeignKey [FK__aspnet_Us__UserI__36B12243] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__UserI__36B12243]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]')) ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__UserI__36B12243] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_FindState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_FindState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_FindState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetSharedState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_DeleteAllState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_DeleteProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_DeleteProfiles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_CreateRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_CreateRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_CreateRole] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_GetCountOfState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetUserState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetUserState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetUserState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_SetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_GetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_SetProperties] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_SetProperties]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_SetProperties] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_CreateUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_CreateUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_CreateUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Applications_CreateApplication] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications_CreateApplication]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Applications_CreateApplication] GO /****** Object: View [dbo].[vw_aspnet_Applications] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Applications]')) DROP VIEW [dbo].[vw_aspnet_Applications] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_FindUsersByEmail] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByEmail]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByEmail] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_FindUsersByName] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByName]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByName] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetAllUsers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetAllUsers]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetAllUsers] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_GetProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_GetProfiles] GO /****** Object: StoredProcedure [dbo].[aspnet_Personalization_GetApplicationId] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Personalization_GetApplicationId]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Personalization_GetApplicationId] GO /****** Object: StoredProcedure [dbo].[aspnet_WebEvent_LogEvent] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_LogEvent]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_WebEvent_LogEvent] GO /****** Object: View [dbo].[vw_aspnet_WebPartState_User] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_User]')) DROP VIEW [dbo].[vw_aspnet_WebPartState_User] GO /****** Object: View [dbo].[vw_aspnet_WebPartState_Shared] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Shared]')) DROP VIEW [dbo].[vw_aspnet_WebPartState_Shared] GO /****** Object: View [dbo].[vw_aspnet_WebPartState_Paths] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Paths]')) DROP VIEW [dbo].[vw_aspnet_WebPartState_Paths] GO /****** Object: StoredProcedure [dbo].[aspnet_Paths_CreatePath] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths_CreatePath]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Paths_CreatePath] GO /****** Object: View [dbo].[vw_aspnet_UsersInRoles] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_UsersInRoles]')) DROP VIEW [dbo].[vw_aspnet_UsersInRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_GetAllRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_GetAllRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_GetAllRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_RoleExists] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_RoleExists]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_RoleExists] GO /****** Object: View [dbo].[vw_aspnet_Roles] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Roles]')) DROP VIEW [dbo].[vw_aspnet_Roles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_DeleteRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_DeleteRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_DeleteRole] GO /****** Object: View [dbo].[vw_aspnet_Profiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Profiles]')) DROP VIEW [dbo].[vw_aspnet_Profiles] GO /****** Object: StoredProcedure [dbo].[aspnet_CheckSchemaVersion] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_CheckSchemaVersion]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_CheckSchemaVersion] GO /****** Object: StoredProcedure [dbo].[aspnet_RegisterSchemaVersion] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_RegisterSchemaVersion]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_RegisterSchemaVersion] GO /****** Object: StoredProcedure [dbo].[aspnet_UnRegisterSchemaVersion] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UnRegisterSchemaVersion]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UnRegisterSchemaVersion] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_AddUsersToRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_AddUsersToRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_GetRolesForUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetRolesForUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetRolesForUser] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_FindUsersInRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_FindUsersInRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_FindUsersInRole] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_GetUsersInRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetUsersInRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetUsersInRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetNumberOfUsersOnline] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetNumberOfUsersOnline]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetNumberOfUsersOnline] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_GetProperties] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProperties]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_GetProperties] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_DeleteInactiveProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteInactiveProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_DeleteInactiveProfiles] GO /****** Object: View [dbo].[vw_aspnet_Users] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Users]')) DROP VIEW [dbo].[vw_aspnet_Users] GO /****** Object: View [dbo].[vw_aspnet_MembershipUsers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_MembershipUsers]')) DROP VIEW [dbo].[vw_aspnet_MembershipUsers] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_UpdateUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_IsUserInRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_IsUserInRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_IsUserInRole] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_UnlockUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UnlockUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_UnlockUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_ResetPassword] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ResetPassword]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_ResetPassword] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_SetPassword] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_SetPassword]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_SetPassword] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetPassword] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPassword]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetPassword] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_UpdateUserInfo] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUserInfo]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUserInfo] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetPasswordWithFormat] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPasswordWithFormat]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetPasswordWithFormat] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByEmail] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByEmail]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByEmail] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByUserId] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByUserId]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByUserId] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByName] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByName]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByName] GO /****** Object: StoredProcedure [dbo].[aspnet_AnyDataInTables] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_AnyDataInTables]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_AnyDataInTables] GO /****** Object: StoredProcedure [dbo].[aspnet_Users_DeleteUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_DeleteUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Users_DeleteUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Users_CreateUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_CreateUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Users_CreateUser] GO /****** Object: Table [dbo].[aspnet_PersonalizationAllUsers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_PersonalizationAllUsers] GO /****** Object: Table [dbo].[aspnet_PersonalizationPerUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_PersonalizationPerUser] GO /****** Object: Table [dbo].[aspnet_Paths] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Paths] GO /****** Object: Table [dbo].[aspnet_UsersInRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_UsersInRoles] GO /****** Object: Table [dbo].[aspnet_Roles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Roles] GO /****** Object: Table [dbo].[aspnet_Profile] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Profile] GO /****** Object: Table [dbo].[aspnet_Membership] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Membership] GO /****** Object: Table [dbo].[aspnet_Users] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Users] GO /****** Object: Table [dbo].[aspnet_Applications] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Applications] GO /****** Object: StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RemoveAllRoleMembers]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Setup_RemoveAllRoleMembers] GO /****** Object: StoredProcedure [dbo].[aspnet_Setup_RestorePermissions] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RestorePermissions]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Setup_RestorePermissions] GO /****** Object: Table [dbo].[aspnet_WebEvent_Events] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_Events]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_WebEvent_Events] GO /****** Object: Table [dbo].[aspnet_SchemaVersions] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_SchemaVersions]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_SchemaVersions] GO /****** Object: Default [DF__aspnet_Ap__Appli__014935CB] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ap__Appli__014935CB]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]')) Begin ALTER TABLE [dbo].[aspnet_Applications] DROP CONSTRAINT [DF__aspnet_Ap__Appli__014935CB] End GO /****** Object: Default [DF__aspnet_Me__Passw__164452B1] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Me__Passw__164452B1]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]')) Begin ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [DF__aspnet_Me__Passw__164452B1] End GO /****** Object: Default [DF__aspnet_Pa__PathI__46E78A0C] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Pa__PathI__46E78A0C]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]')) Begin ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [DF__aspnet_Pa__PathI__46E78A0C] End GO /****** Object: Default [DF__aspnet_Perso__Id__4E88ABD4] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Perso__Id__4E88ABD4]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]')) Begin ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [DF__aspnet_Perso__Id__4E88ABD4] End GO /****** Object: Default [DF__aspnet_Ro__RoleI__33D4B598] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ro__RoleI__33D4B598]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]')) Begin ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [DF__aspnet_Ro__RoleI__33D4B598] End GO /****** Object: Default [DF__aspnet_Us__UserI__0519C6AF] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__UserI__0519C6AF]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) Begin ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__UserI__0519C6AF] End GO /****** Object: Default [DF__aspnet_Us__Mobil__060DEAE8] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__Mobil__060DEAE8]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) Begin ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__Mobil__060DEAE8] End GO /****** Object: Default [DF__aspnet_Us__IsAno__07020F21] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__IsAno__07020F21]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) Begin ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__IsAno__07020F21] End GO /****** Object: Schema [aspnet_Membership_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_BasicAccess') DROP SCHEMA [aspnet_Membership_BasicAccess] GO /****** Object: Schema [aspnet_Membership_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_FullAccess') DROP SCHEMA [aspnet_Membership_FullAccess] GO /****** Object: Schema [aspnet_Membership_ReportingAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_ReportingAccess') DROP SCHEMA [aspnet_Membership_ReportingAccess] GO /****** Object: Schema [aspnet_Personalization_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_BasicAccess') DROP SCHEMA [aspnet_Personalization_BasicAccess] GO /****** Object: Schema [aspnet_Personalization_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_FullAccess') DROP SCHEMA [aspnet_Personalization_FullAccess] GO /****** Object: Schema [aspnet_Personalization_ReportingAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_ReportingAccess') DROP SCHEMA [aspnet_Personalization_ReportingAccess] GO /****** Object: Schema [aspnet_Profile_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_BasicAccess') DROP SCHEMA [aspnet_Profile_BasicAccess] GO /****** Object: Schema [aspnet_Profile_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_FullAccess') DROP SCHEMA [aspnet_Profile_FullAccess] GO /****** Object: Schema [aspnet_Profile_ReportingAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_ReportingAccess') DROP SCHEMA [aspnet_Profile_ReportingAccess] GO /****** Object: Schema [aspnet_Roles_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_BasicAccess') DROP SCHEMA [aspnet_Roles_BasicAccess] GO /****** Object: Schema [aspnet_Roles_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_FullAccess') DROP SCHEMA [aspnet_Roles_FullAccess] GO /****** Object: Schema [aspnet_Roles_ReportingAccess] Script Date: 03/05/2009 19:35:03 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_ReportingAccess') DROP SCHEMA [aspnet_Roles_ReportingAccess] GO /****** Object: Schema [aspnet_WebEvent_FullAccess] Script Date: 03/05/2009 19:35:03 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_WebEvent_FullAccess') DROP SCHEMA [aspnet_WebEvent_FullAccess] GO /****** Object: Role [aspnet_Membership_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ DECLARE @RoleName sysname set @RoleName = N'aspnet_Membership_BasicAccess' IF EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R') Begin DECLARE @RoleMemberName sysname DECLARE Member_Cursor CURSOR FOR select [name] from dbo.sysusers where uid in ( select member_principal_id from sys.database_role_members where role_principal_id in ( select principal_id FROM sys.database_principals where [name] = @RoleName AND type = 'R' )) OPEN Member_Cursor ----END RAW---- SQL-query: ?****** Object: ForeignKey [FK__aspnet_Me__Appli__145C0A3F] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__Appli__145C0A3F]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]')) ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__Appli__145C0A3F] GO /****** Object: ForeignKey [FK__aspnet_Me__UserI__15502E78] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Me__UserI__15502E78]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]')) ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [FK__aspnet_Me__UserI__15502E78] GO /****** Object: ForeignKey [FK__aspnet_Pa__Appli__45F365D3] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pa__Appli__45F365D3]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]')) ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [FK__aspnet_Pa__Appli__45F365D3] GO /****** Object: ForeignKey [FK__aspnet_Pe__PathI__4BAC3F29] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__4BAC3F29]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]')) ALTER TABLE [dbo].[aspnet_PersonalizationAllUsers] DROP CONSTRAINT [FK__aspnet_Pe__PathI__4BAC3F29] GO /****** Object: ForeignKey [FK__aspnet_Pe__PathI__4F7CD00D] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__PathI__4F7CD00D]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]')) ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__PathI__4F7CD00D] GO /****** Object: ForeignKey [FK__aspnet_Pe__UserI__5070F446] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pe__UserI__5070F446]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]')) ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [FK__aspnet_Pe__UserI__5070F446] GO /****** Object: ForeignKey [FK__aspnet_Pr__UserI__29572725] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Pr__UserI__29572725]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]')) ALTER TABLE [dbo].[aspnet_Profile] DROP CONSTRAINT [FK__aspnet_Pr__UserI__29572725] GO /****** Object: ForeignKey [FK__aspnet_Ro__Appli__32E0915F] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Ro__Appli__32E0915F]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]')) ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [FK__aspnet_Ro__Appli__32E0915F] GO /****** Object: ForeignKey [FK__aspnet_Us__Appli__0425A276] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__Appli__0425A276]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [FK__aspnet_Us__Appli__0425A276] GO /****** Object: ForeignKey [FK__aspnet_Us__RoleI__37A5467C] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__RoleI__37A5467C]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]')) ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__RoleI__37A5467C] GO /****** Object: ForeignKey [FK__aspnet_Us__UserI__36B12243] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK__aspnet_Us__UserI__36B12243]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]')) ALTER TABLE [dbo].[aspnet_UsersInRoles] DROP CONSTRAINT [FK__aspnet_Us__UserI__36B12243] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_FindState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_FindState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_FindState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetSharedState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetSharedState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_GetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_GetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_ResetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_DeleteAllState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_DeleteAllState] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_DeleteProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_DeleteProfiles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_CreateRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_CreateRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_CreateRole] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers_SetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAllUsers_SetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_GetCountOfState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_GetCountOfState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationAdministration_ResetUserState] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAdministration_ResetUserState]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationAdministration_ResetUserState] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_SetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_SetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_ResetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_ResetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser_GetPageSettings]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_PersonalizationPerUser_GetPageSettings] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_SetProperties] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_SetProperties]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_SetProperties] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_CreateUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_CreateUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_CreateUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Applications_CreateApplication] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications_CreateApplication]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Applications_CreateApplication] GO /****** Object: View [dbo].[vw_aspnet_Applications] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Applications]')) DROP VIEW [dbo].[vw_aspnet_Applications] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_FindUsersByEmail] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByEmail]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByEmail] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_FindUsersByName] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_FindUsersByName]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_FindUsersByName] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetAllUsers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetAllUsers]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetAllUsers] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_GetProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_GetProfiles] GO /****** Object: StoredProcedure [dbo].[aspnet_Personalization_GetApplicationId] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Personalization_GetApplicationId]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Personalization_GetApplicationId] GO /****** Object: StoredProcedure [dbo].[aspnet_WebEvent_LogEvent] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_LogEvent]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_WebEvent_LogEvent] GO /****** Object: View [dbo].[vw_aspnet_WebPartState_User] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_User]')) DROP VIEW [dbo].[vw_aspnet_WebPartState_User] GO /****** Object: View [dbo].[vw_aspnet_WebPartState_Shared] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Shared]')) DROP VIEW [dbo].[vw_aspnet_WebPartState_Shared] GO /****** Object: View [dbo].[vw_aspnet_WebPartState_Paths] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_WebPartState_Paths]')) DROP VIEW [dbo].[vw_aspnet_WebPartState_Paths] GO /****** Object: StoredProcedure [dbo].[aspnet_Paths_CreatePath] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths_CreatePath]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Paths_CreatePath] GO /****** Object: View [dbo].[vw_aspnet_UsersInRoles] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_UsersInRoles]')) DROP VIEW [dbo].[vw_aspnet_UsersInRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_GetAllRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_GetAllRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_GetAllRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_RoleExists] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_RoleExists]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_RoleExists] GO /****** Object: View [dbo].[vw_aspnet_Roles] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Roles]')) DROP VIEW [dbo].[vw_aspnet_Roles] GO /****** Object: StoredProcedure [dbo].[aspnet_Roles_DeleteRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles_DeleteRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Roles_DeleteRole] GO /****** Object: View [dbo].[vw_aspnet_Profiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Profiles]')) DROP VIEW [dbo].[vw_aspnet_Profiles] GO /****** Object: StoredProcedure [dbo].[aspnet_CheckSchemaVersion] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_CheckSchemaVersion]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_CheckSchemaVersion] GO /****** Object: StoredProcedure [dbo].[aspnet_RegisterSchemaVersion] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_RegisterSchemaVersion]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_RegisterSchemaVersion] GO /****** Object: StoredProcedure [dbo].[aspnet_UnRegisterSchemaVersion] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UnRegisterSchemaVersion]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UnRegisterSchemaVersion] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_RemoveUsersFromRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_AddUsersToRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_AddUsersToRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_AddUsersToRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_GetRolesForUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetRolesForUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetRolesForUser] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_FindUsersInRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_FindUsersInRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_FindUsersInRole] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_GetUsersInRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_GetUsersInRoles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_GetUsersInRoles] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetNumberOfUsersOnline] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetNumberOfUsersOnline]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetNumberOfUsersOnline] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_GetProperties] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetProperties]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_GetProperties] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_DeleteInactiveProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_DeleteInactiveProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_DeleteInactiveProfiles] GO /****** Object: View [dbo].[vw_aspnet_Users] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_Users]')) DROP VIEW [dbo].[vw_aspnet_Users] GO /****** Object: View [dbo].[vw_aspnet_MembershipUsers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.views WHERE object_id = OBJECT_ID(N'[dbo].[vw_aspnet_MembershipUsers]')) DROP VIEW [dbo].[vw_aspnet_MembershipUsers] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_UpdateUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile_GetNumberOfInactiveProfiles]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Profile_GetNumberOfInactiveProfiles] GO /****** Object: StoredProcedure [dbo].[aspnet_UsersInRoles_IsUserInRole] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles_IsUserInRole]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_UsersInRoles_IsUserInRole] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_UnlockUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UnlockUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_UnlockUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_ResetPassword] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_ResetPassword]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_ResetPassword] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_SetPassword] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_SetPassword]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_SetPassword] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetPassword] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPassword]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetPassword] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_UpdateUserInfo] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_UpdateUserInfo]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_UpdateUserInfo] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetPasswordWithFormat] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetPasswordWithFormat]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetPasswordWithFormat] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByEmail] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByEmail]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByEmail] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByUserId] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByUserId]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByUserId] GO /****** Object: StoredProcedure [dbo].[aspnet_Membership_GetUserByName] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership_GetUserByName]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Membership_GetUserByName] GO /****** Object: StoredProcedure [dbo].[aspnet_AnyDataInTables] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_AnyDataInTables]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_AnyDataInTables] GO /****** Object: StoredProcedure [dbo].[aspnet_Users_DeleteUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_DeleteUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Users_DeleteUser] GO /****** Object: StoredProcedure [dbo].[aspnet_Users_CreateUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users_CreateUser]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Users_CreateUser] GO /****** Object: Table [dbo].[aspnet_PersonalizationAllUsers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationAllUsers]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_PersonalizationAllUsers] GO /****** Object: Table [dbo].[aspnet_PersonalizationPerUser] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_PersonalizationPerUser] GO /****** Object: Table [dbo].[aspnet_Paths] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Paths] GO /****** Object: Table [dbo].[aspnet_UsersInRoles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_UsersInRoles]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_UsersInRoles] GO /****** Object: Table [dbo].[aspnet_Roles] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Roles] GO /****** Object: Table [dbo].[aspnet_Profile] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Profile]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Profile] GO /****** Object: Table [dbo].[aspnet_Membership] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Membership] GO /****** Object: Table [dbo].[aspnet_Users] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Users]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Users] GO /****** Object: Table [dbo].[aspnet_Applications] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_Applications] GO /****** Object: StoredProcedure [dbo].[aspnet_Setup_RemoveAllRoleMembers] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RemoveAllRoleMembers]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Setup_RemoveAllRoleMembers] GO /****** Object: StoredProcedure [dbo].[aspnet_Setup_RestorePermissions] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_Setup_RestorePermissions]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[aspnet_Setup_RestorePermissions] GO /****** Object: Table [dbo].[aspnet_WebEvent_Events] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_WebEvent_Events]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_WebEvent_Events] GO /****** Object: Table [dbo].[aspnet_SchemaVersions] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[aspnet_SchemaVersions]') AND type in (N'U')) DROP TABLE [dbo].[aspnet_SchemaVersions] GO /****** Object: Default [DF__aspnet_Ap__Appli__014935CB] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ap__Appli__014935CB]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Applications]')) Begin ALTER TABLE [dbo].[aspnet_Applications] DROP CONSTRAINT [DF__aspnet_Ap__Appli__014935CB] End GO /****** Object: Default [DF__aspnet_Me__Passw__164452B1] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Me__Passw__164452B1]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Membership]')) Begin ALTER TABLE [dbo].[aspnet_Membership] DROP CONSTRAINT [DF__aspnet_Me__Passw__164452B1] End GO /****** Object: Default [DF__aspnet_Pa__PathI__46E78A0C] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Pa__PathI__46E78A0C]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Paths]')) Begin ALTER TABLE [dbo].[aspnet_Paths] DROP CONSTRAINT [DF__aspnet_Pa__PathI__46E78A0C] End GO /****** Object: Default [DF__aspnet_Perso__Id__4E88ABD4] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Perso__Id__4E88ABD4]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_PersonalizationPerUser]')) Begin ALTER TABLE [dbo].[aspnet_PersonalizationPerUser] DROP CONSTRAINT [DF__aspnet_Perso__Id__4E88ABD4] End GO /****** Object: Default [DF__aspnet_Ro__RoleI__33D4B598] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Ro__RoleI__33D4B598]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Roles]')) Begin ALTER TABLE [dbo].[aspnet_Roles] DROP CONSTRAINT [DF__aspnet_Ro__RoleI__33D4B598] End GO /****** Object: Default [DF__aspnet_Us__UserI__0519C6AF] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__UserI__0519C6AF]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) Begin ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__UserI__0519C6AF] End GO /****** Object: Default [DF__aspnet_Us__Mobil__060DEAE8] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__Mobil__060DEAE8]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) Begin ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__Mobil__060DEAE8] End GO /****** Object: Default [DF__aspnet_Us__IsAno__07020F21] Script Date: 03/05/2009 19:35:01 ******/ IF EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF__aspnet_Us__IsAno__07020F21]') AND parent_object_id = OBJECT_ID(N'[dbo].[aspnet_Users]')) Begin ALTER TABLE [dbo].[aspnet_Users] DROP CONSTRAINT [DF__aspnet_Us__IsAno__07020F21] End GO /****** Object: Schema [aspnet_Membership_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_BasicAccess') DROP SCHEMA [aspnet_Membership_BasicAccess] GO /****** Object: Schema [aspnet_Membership_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_FullAccess') DROP SCHEMA [aspnet_Membership_FullAccess] GO /****** Object: Schema [aspnet_Membership_ReportingAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Membership_ReportingAccess') DROP SCHEMA [aspnet_Membership_ReportingAccess] GO /****** Object: Schema [aspnet_Personalization_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_BasicAccess') DROP SCHEMA [aspnet_Personalization_BasicAccess] GO /****** Object: Schema [aspnet_Personalization_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_FullAccess') DROP SCHEMA [aspnet_Personalization_FullAccess] GO /****** Object: Schema [aspnet_Personalization_ReportingAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Personalization_ReportingAccess') DROP SCHEMA [aspnet_Personalization_ReportingAccess] GO /****** Object: Schema [aspnet_Profile_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_BasicAccess') DROP SCHEMA [aspnet_Profile_BasicAccess] GO /****** Object: Schema [aspnet_Profile_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_FullAccess') DROP SCHEMA [aspnet_Profile_FullAccess] GO /****** Object: Schema [aspnet_Profile_ReportingAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Profile_ReportingAccess') DROP SCHEMA [aspnet_Profile_ReportingAccess] GO /****** Object: Schema [aspnet_Roles_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_BasicAccess') DROP SCHEMA [aspnet_Roles_BasicAccess] GO /****** Object: Schema [aspnet_Roles_FullAccess] Script Date: 03/05/2009 19:35:02 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_FullAccess') DROP SCHEMA [aspnet_Roles_FullAccess] GO /****** Object: Schema [aspnet_Roles_ReportingAccess] Script Date: 03/05/2009 19:35:03 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_Roles_ReportingAccess') DROP SCHEMA [aspnet_Roles_ReportingAccess] GO /****** Object: Schema [aspnet_WebEvent_FullAccess] Script Date: 03/05/2009 19:35:03 ******/ IF EXISTS (SELECT * FROM sys.schemas WHERE name = N'aspnet_WebEvent_FullAccess') DROP SCHEMA [aspnet_WebEvent_FullAccess] GO /****** Object: Role [aspnet_Membership_BasicAccess] Script Date: 03/05/2009 19:35:02 ******/ DECLARE @RoleName sysname set @RoleName = N'aspnet_Membership_BasicAccess' IF EXISTS (SELECT * FROM sys.database_principals WHERE name = @RoleName AND type = 'R') Begin DECLARE @RoleMemberName sysname DECLARE Member_Cursor CURSOR FOR select [name] from dbo.sysusers where uid in ( select member_principal_id from sys.database_role_members where role_principal_id in ( select principal_id FROM sys.database_principals where [name] = @RoleName AND type = 'R' )) OPEN Member_Cursor MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? at line 1 Can anyone help in resolving this? Thanks Ian
• • Reply
  

  IanBotham

  Member

  4 Points

  10 Posts

  Re: working with mysql

  Mar 06, 2009 04:45 PM|LINK

  Hi I have moved to MS Sql 2005, although thats thrown up an error when running a query. I am going to start again from scratch and recreate everything, upload and create new .sql files and see what happens Thanks