Logo Sozezzo
Sozezzo's notes

  • Home
  • Blog
    • Archives
    • Series
    • Categories
    • Tags
  • Tools
    • Github
    • What is my IP ?
    • Create password
    • Sql Server Connection String
    • QR Code
    • Buzzword
    • Encoder Url
    • URI Obfuscator
    • Gym
    • Json editor


  • Github RSS

  • Font Size
  • Mode
  1. Home
  2. Tags
  3. Queue

How Do I Enable a Service Broker Queue When It Is Disabled?

May 23, 20172 min read It SqlscriptBroker ServiceQueue

You can manually disable or enable the service through SQL Server Management Studio or run the ALTER QUEUE command for: 1 2-- Enable 3ALTER QUEUE [queuename] WITH STATUS = ON; 4 5-- Disable 6ALTER QUEUE [queuename] WITH STATUS = OFF; But, it can be complicated when you need over all database. This script enable all...

Read More
Profile
Milton Sozezzo
Milton Sozezzo
About
Taxonomies
it 74 sqlscript 58 follow 18 blog 9 firefox 9 tutorial 6 powershell 5 c 3 programming 3 sql 3 ctutorial 2 ai 1 android 1 automated 1 browser 1 c-sharp 1 commandline 1 config 1 csharp 1 gym 1 java 1 Markdown 1 sante 1 serialize 1 sql server 1
create 3 my day 3 security 3 sql 3 sql server 3 android 2 audit 2 backup 2 column 2 comment 2 database 2 deadlock 2 Markdown 2 metacoding 2 migrer 2 php 2 pluxml 2 table 2 web service 2 xml 2 alert 1 alwayson;shrink database;disaster 1 ASPX 1 blocked 1 blog 1 broker service 1 cell 1 CLR 1 command line 1 concatenate 1 ALL 144
2023 2 2022 7 2021 4 2020 10 2019 22 2018 15 2017 12 2016 16 2015 43 2014 8 2013 2 0001 2
Posts
  • Markdown Syntax Guide
    Markdown Syntax Guide
    November 9, 2020
  • Using API ChatGPT - First Notes
    April 29, 2023
  • Execute a Query on Remote Sql Server
    April 22, 2023
  • How to Save/Restore Serializable Object to/From File in C# ?
    December 13, 2022
  • Creating Automated Browser Tests With Selenium WebDriver in C#
    December 13, 2022
    • docs
    • Markdown Syntax Guide
Copyright © 2000-2024 Sozezzo. All Rights Reserved.