English English Spanish EspañolKorea한국어
Straker»Company»Blog»2005» Removing MS SQL table relationships on Shado 6.0.1.27 and before

Removing MS SQL table relationships on Shado 6.0.1.27 and before

Instructions to manually remove redundant table relationships from the "users" table in a Microsoft SQL Server database using Enterprise Manager. Please note that you need to do this only if: - You are not able to delete users from Shado Central. - And you are using earlier version of Shado (version 6.0.1.27 and before). - And are using MS SQL Server Database.
  1. Backup your database.
  2. Right-click on the "users" table and choose Design Table from the shortcut menu.
  3. Right-click within the Table Designer and choose Relationships from the shortcut menu.
  4. Select a relationship from the Selected relationship drop-down list.
  5. Click the Delete button.
  6. Repeat steps 4 and 5 until all relationships are deleted.
  7. Test your site.

Comments

There are no comments for this page as yet.

Add a comment