diff options
| author | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2019-02-27 01:44:38 +0200 |
|---|---|---|
| committer | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2019-02-27 01:44:38 +0200 |
| commit | 88a73106e8113a4a6ce224f9205e11219939798e (patch) | |
| tree | 138bd817e9164192aea5297770ec090ae612c3a7 /Software/Visual_Studio/Notes | |
| parent | 3871e96b254db8ce93e294d4eb74f54d51552e2a (diff) | |
| download | Tango-88a73106e8113a4a6ce224f9205e11219939798e.tar.gz Tango-88a73106e8113a4a6ce224f9205e11219939798e.zip | |
Started working on Sql Dependency and EF Cache.
Diffstat (limited to 'Software/Visual_Studio/Notes')
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt | 18 | ||||
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj | 3 |
2 files changed, 20 insertions, 1 deletions
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 |