From 523bb86f28158efe34b285ba07b2500ea59d09d1 Mon Sep 17 00:00:00 2001
From: Roy Ben Shabat <Roy.mail.net@gmail.com>
Date: Tue, 10 Dec 2024 20:15:36 +0200
Subject: Fixed CE crash with no light inks.

---
 Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt | 6 ++++++
 Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj         | 3 ++-
 2 files changed, 8 insertions(+), 1 deletion(-)
 create mode 100644 Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt

(limited to 'Software/Visual_Studio/Notes')

diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt b/Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt
new file mode 100644
index 000000000..b66eca7d3
--- /dev/null
+++ b/Software/Visual_Studio/Notes/Tango.Notes/DB/Repair Suspect Mode.txt	
@@ -0,0 +1,6 @@
+EXEC sp_resetstatus Tango_TEST;
+ALTER DATABASE Tango_TEST SET EMERGENCY
+DBCC checkdb(Tango_TEST)
+ALTER DATABASE Tango_TEST SET SINGLE_USER WITH ROLLBACK IMMEDIATE
+DBCC CheckDB (Tango_TEST, REPAIR_ALLOW_DATA_LOSS)
+ALTER DATABASE Tango_TEST SET MULTI_USER
\ No newline at end of file
diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
index 9f2d91731..7c0014747 100644
--- a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
+++ b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
@@ -50,6 +50,7 @@
     <Content Include="Azure\Test User Credentials.txt" />
     <Content Include="Azure\SQL Database.txt" />
     <None Include="DB\Fix Domain User Script.bat" />
+    <Content Include="DB\Repair Suspect Mode.txt" />
     <Content Include="DB\DB Schema Change Log.txt" />
     <Content Include="DB\Drop All Tables.sql" />
     <Content Include="DB\Fix Job Corrupted Runs Start Time.sql" />
@@ -72,7 +73,7 @@
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
+      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file
-- 
cgit v1.3.1