From 88a73106e8113a4a6ce224f9205e11219939798e Mon Sep 17 00:00:00 2001
From: Roy Ben Shabat <Roy.mail.net@gmail.com>
Date: Wed, 27 Feb 2019 01:44:38 +0200
Subject: Started working on Sql Dependency and EF Cache.

---
 .../Notes/Tango.Notes/DB/SQL Dependency.txt            | 18 ++++++++++++++++++
 .../Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj |  3 ++-
 2 files changed, 20 insertions(+), 1 deletion(-)
 create mode 100644 Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt

(limited to 'Software/Visual_Studio/Notes')

diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt b/Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt
new file mode 100644
index 000000000..d46f10bd7
--- /dev/null
+++ b/Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt	
@@ -0,0 +1,18 @@
+-- Set user as db owner --
+USE Tango
+GO
+SP_DROPUSER Developer
+GO
+SP_CHANGEDBOWNER Developer
+
+
+-- Maybe this one also ? --
+ALTER AUTHORIZATION ON DATABASE::Tango TO Developer;
+
+
+-- Get state of broker service on each database --
+SELECT NAME, IS_BROKER_ENABLED FROM SYS.DATABASES
+
+
+-- Enable broker service --
+ALTER DATABASE Tango SET ENABLE_BROKER;
\ 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 e2f081fd0..2ce33c1c4 100644
--- a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
+++ b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
@@ -46,6 +46,7 @@
     <Content Include="Advanced Installer\License.txt" />
     <Content Include="Azure\Test User Credentials.txt" />
     <Content Include="Azure\SQL Database.txt" />
+    <Content Include="DB\SQL Dependency.txt" />
     <Content Include="PPC\Remote Debugging.txt" />
     <Content Include="PPC\Virtual Flash Drive.txt" />
     <Content Include="PPC\Windows 10 LTSB.txt" />
@@ -56,7 +57,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