diff options
| author | Roy Ben-Shabat <Roy@Twine-s.com> | 2019-07-24 14:55:44 +0300 |
|---|---|---|
| committer | Roy Ben-Shabat <Roy@Twine-s.com> | 2019-07-24 14:55:44 +0300 |
| commit | d052a52d3a6fb6c82a4f1299a0b99dd75726edba (patch) | |
| tree | bba891a86cac5dde003cedb8f7579208cb543644 /Software/Visual_Studio/Tango.Core | |
| parent | 13cea5de4abfa38528ba74d9542734e133acaa81 (diff) | |
| download | Tango-d052a52d3a6fb6c82a4f1299a0b99dd75726edba.tar.gz Tango-d052a52d3a6fb6c82a4f1299a0b99dd75726edba.zip | |
Working on factory reset.
Diffstat (limited to 'Software/Visual_Studio/Tango.Core')
| -rw-r--r-- | Software/Visual_Studio/Tango.Core/DB/DbManager.cs | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs index 9350f426a..10a4e26db 100644 --- a/Software/Visual_Studio/Tango.Core/DB/DbManager.cs +++ b/Software/Visual_Studio/Tango.Core/DB/DbManager.cs @@ -149,13 +149,13 @@ namespace Tango.Core.DB throw new InvalidOperationException("Clear db can only be used when 'initial catalog' is specified at the connection string."); } - SqlCommand cmd = new SqlCommand("EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'", _connection); + SqlCommand cmd = new SqlCommand("EXEC sys.sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'", _connection); cmd.ExecuteNonQuery(); - cmd = new SqlCommand("EXEC sp_MSForEachTable 'SET QUOTED_IDENTIFIER ON; DELETE FROM ?'", _connection); + cmd = new SqlCommand("EXEC sys.sp_msforeachtable 'DELETE FROM ?'", _connection); cmd.ExecuteNonQuery(); - cmd = new SqlCommand("EXEC sp_MSForEachTable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT ALL'", _connection); + cmd = new SqlCommand("EXEC sys.sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'", _connection); cmd.ExecuteNonQuery(); } |
