SQL Server Service Broker Admin Tool For SQL Server 2005 RTM

Dec 27, 2005

Back in July I released the (then) latest version of SsbAdmin. For you who
don'r know what it is; it's a tool which allows you to graphically administer
SQL Server Service Broker.

I have now uploaded a new version which is compiled against the released
versions of SQL Server 2005 and .NET 2.0.

You can download it from here: [0].

After download, un-zip to some directory and read the README.doc file.

[0]: http://staff.develop.com/nielsb/code/ssbadmin.zip

View 2 Replies


ADVERTISEMENT

SQL SERVER 2005 Service Broker

Jul 23, 2007



Does SQL SVR 2005 Service Broker use connection pooling?



We are building a laptop application that will use SB to send messsages

to one SQL SVR 2005 instance. SQL 2005 Express will be installed on

each laptop and will be the "sender" to one SQL SVR instance, the "receipient"



It will be deployed to over 1500+ laptops. Each laptop will have a different

IP address.



Our SQLDBA wants to know if each of the laptops will use a different

connection when sending messages?



I answered "Yes", but another team member said "No".



What is the correct answer?







View 7 Replies View Related

Enabling Service Broker In Sql Server 2005

Oct 23, 2006

helloi use Visual Web Developer and SQL server 2005 express , how can i enable service borker of my sql server ?thaks for any helpderin

View 1 Replies View Related

Service Broker Feature In Sql Server 2005

Apr 26, 2006

Hi,



I have installed sql server standard edition 2005.I want to enable service broker feature or services after intalling the sql server.Please let me known any tool or utiltiy to enable the feature



Alter datatabase set enable_broker is not working.

Its giving syntax error



Thanks

View 1 Replies View Related

ASP.NET SqlDependency Using Sql Server 2005 Service Broker Problem.

Dec 4, 2007

I created the table dbo.customer from the orginal table sales.customer. dbo.customer works but sales.customer does not. WHY? We took the time to design our tables under different schemas to help control, organize and assign permissions.Private Function GetCustomers() As DataTable
Dim sqlconnection As New SqlConnection(WebConfigurationManager.ConnectionStrings("connectionstringAlliance").ConnectionString.ToString)WORKS:Dim command As New SqlCommand("SELECT CustomerID, CustomerType FROM dbo.Customer WHERE CustomerID=1234", sqlconnection)DOES NOT WORK:Dim command As New SqlCommand("SELECT CustomerID, CustomerType FROM Sales.Customer WHERE CustomerID=1234", sqlconnection)

Dim dependency As New SqlCacheDependency(command)
Dim dad As SqlDataAdapter = New SqlDataAdapter(command)
Dim customers As New DataTable
dad.Fill(customers)Cache.Insert("Customers", customers, dependency)
Return customersEnd Function Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.LoadDim customers As DataTable = CType(Cache.[Get]("Customers"), DataTable)

If customers Is Nothing Then
customers = GetCustomers()
Label1.Text = System.DateTime.Now.ToString()
End If
gridviewCustomer.DataSource = customers.DefaultView
gridviewCustomer.DataBind()

End Sub

View 6 Replies View Related

SQL Server 2005 Service Broker - Activation Stored Procedure Memory Usuage

Nov 9, 2007

We are looking for some guidance with an issue we have picked up with our implementation of Service Broker here on the ABSA Capital project and I am hoping you can help or point us in the direction of someone.

The architecture we have implemented for service broker is to make use of an Activation stored procedure on two queues (1 SP per queue) to process the messages received. What we have found is that the activation stored procedure runs on a background session and its CPU time and memory just grows to the point where it brought one of our UAT servers to a grinding halt.

Is there anyway we can reduce the memory consumption of the activation stored procedure or is this one of those things that still need to be ironed out in Service Broker?

View 6 Replies View Related

The SQL Server Service Broker For The Current Database Is Not Enabled, And As A Result Query Notifications Are Not Supported. Please Enable The Service Broker For This Database If You Wish To Use Notifications.

Feb 16, 2008

Hello,          I receive this error  "The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.  Please enable the Service Broker for this database if you wish to use notifications." I attach the database in Management Studio to query and enable the broker using the scrip below but to no avail. ALTER DATABASE DataName SET ENABLE_BROKER β€˜''<<------successfulandSELECT is_broker_enabled FROM sys.databases WHERE name = 'Database name' β€˜'''<<-------value is 1 Global.asax ...    Sub Application_Start(ByVal sender As Object, ByVal e As EventArgs)        System.Data.SqlClient.SqlDependency.Start(ConfigurationManager.ConnectionStrings("dataConnectionString1").ConnectionString)    End Sub...Web.config ...    <connectionStrings>        <add name="dataConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|jbp_data.mdf;Integrated Security=True;User Instance=True"         providerName="System.Data.SqlClient" />        <add name="ASPNETDBConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True"         providerName="System.Data.SqlClient" />    </connectionStrings>... Hope you could help.  cheers,imperialx 

View 1 Replies View Related

Server Admin Tool

Apr 3, 2007

Hi my server people have informed me that there is a tool that I can access the server with.  Can anybody point me in the right direction?
 
Many Thanks
howlinhuskie

View 9 Replies View Related

SQL Server Admin Tool

Mar 8, 2004

Hello,

I am looking for an ASP.NET tool that allows me to access a SQL Server remotly. We have created a database and would like to begin populating the tables before development of our site. The main funtionality I am looking for is to be able to view all tables within a database in the SQL Server. Also, I would like to be able to insert data into these tables. Is anyone aware of a tool like this?

Thanks a lot!!

View 3 Replies View Related

How To Prevent The Hang On The Initator Service Broker If The Target Service Broker Is Not Started?

Sep 10, 2007

How to prevent the hang on the initator service broker if the target service broker is not started?

Our case has two service brokers (two databases), sometime, the target is need to turn off. But the sitation is the initator service broker (in fact, the message is sent from triggers) become hang, I want to prevent this case and continue to operation, and the messages should queue and will continue to send to target service broker when it startup. How should I do?

View 3 Replies View Related

The SQL Server Service Broker Challange

Jun 19, 2005

Can't believe no one has commented on this in here yet. If you're into SQL Server Service Broker (and you are if you are reading this forum), you must go over and take Rushi's Service Broker Challange.

View 1 Replies View Related

SQL Server Service Broker Examples

Jul 17, 2005

Recently there has been questions on some of the newsgroups about examples for SQL Server Service Broker. So, yesterday on a flight back to England I crofted up three different SQL Server projects as examples: LocalSampleRemoteSampleServer1RemoteSampleServer2
All three examples are jus your very basic €œHello World€? example, but they show: LocalSample €“ communication between two databases on the same SQL server instance. MasterKeys in a database and the database being TrustWorthyRemoteSampleServerX €“ These two samples are meant to run on two different machines/instances and in the samples you set up both transport security and dialog security by using Certificates.
Download the zip file from here [0], unzip and read the README.txt file, and €“ Have Fun!!
[0] : http://staff.develop.com/nielsb/code/servicebrokerexamples.zip
 

View 6 Replies View Related

Insert To A Linked Server Possible Via Service Broker?

Jul 14, 2006

I have configured a non-SQL linked server (via an OLE DB provider) and I wish to insert data into it via Service Broker but I am getting the following error in the SQL Server log:
The activated proc [dbo].[sp_ mytableServiceProgram] running on queue TestDB.dbo.mytableQueue output the following: 'Cannot promote the transaction to a distributed transaction because there is an active save point in this transaction.'

As you see below, my strored proc. is not issuing any 'save trans' statements, so why is it not allowing me to wrap my code in a transaction? How else can I use a transaction (in order to not lose anything from the queue) and yet still be able to insert to the linked server?


CREATE PROC sp_mytableServiceProgram
AS
SET NOCOUNT ON;

DECLARE
@XML XML,
@MessageBody VARBINARY(MAX),
@MessageTypeName nvarchar(256),
@Dialog UNIQUEIDENTIFIER;

-- This procedure continues to process messages in the queue until the
-- queue is empty.

WHILE (1 = 1)
BEGIN
BEGIN TRANSACTION;
--BEGIN DISTRIBUTED TRANSACTION; --Tried this but didn't help.

-- Receive the next available message
WAITFOR (
RECEIVE TOP(1) -- just handle one message at a time
@MessageTypeName = message_type_name,
@MessageBody = message_body,
@Dialog = conversation_handle
FROM mytableQueue
), TIMEOUT 2000 ;

-- If RECEIVE did not return a message, roll back the transaction
-- and break out of the while loop, exiting the procedure.
IF (@@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION;
BREAK;
END ;

SET @XML = CAST(@MessageBody AS XML);

INSERT INTO LINKEDSERVER.dbname.user.mytable
SELECT tbl.rows.value('@doc_no', 'INT') AS doc_no,
tbl.rows.value('@queryid', 'NVARCHAR(50)') AS queryid,
tbl.rows.value('@ar_num', 'NVARCHAR(50)') AS ar_num,
tbl.rows.value('@status', 'NVARCHAR(20)') AS status,
tbl.rows.value('@creationtime', 'DATETIME') AS creationtime,
tbl.rows.value('@note', 'NVARCHAR(250)') AS note,
tbl.rows.value('@posted', 'NCHAR(1)') AS posted,
tbl.rows.value('@kms', 'INT') AS kms,
tbl.rows.value('@schresid', 'NVARCHAR(50)') AS schresid,
tbl.rows.value('@resolution_code', 'NCHAR(8)') AS resolution_code,
tbl.rows.value('@page_count', 'INT') AS page_count,
tbl.rows.value('@new_serial_number', 'NVARCHAR(20)') AS new_serial_number,
tbl.rows.value('@taskresolution', 'NVARCHAR(250)') AS taskresolution
FROM @XML.nodes('/inserted') tbl(rows);

-- If the INSERT did not insert any rows, rollback.
IF @@ROWCOUNT = 0
BEGIN
ROLLBACK TRANSACTION;
BREAK;
END
COMMIT TRANSACTION;
END
GO

View 8 Replies View Related

Can See Service Broker Queue With SQL Server Login

Sep 7, 2006

I have an application that is reading a message from a Service Broker Queue. When I use integrated security with an NT account it works fine. When I use a SQL Server User through Management Studio I can select from the Queue however, when I use this same account through the web app with the SQL Server User, I cannot see the Queue. Is there a grant that I must do to this account to get it to see the Service Broker Objects?

Gary

View 2 Replies View Related

SQL Server Logging Of Service Broker Messages

May 2, 2006

I am writting a huge Service Broker Application. I notice that each message that is processed appears in the SQL Server Logs. Currently I am just testing with a single queue and tons of messages are showing up in the log. Is there a way that I can turn these informational messages off? I think in the end I may have something like 15 or 20 queues. These messages are very useful for debugging but I may not desire this extensive logging to be running all the time on all of my queues.

Gary

View 4 Replies View Related

SQL Server 2008 :: Service Broker Queue In Database

Feb 3, 2015

I had to restore a database in one of the staging servers the other day. However, upon completion, I found out that the service broker queue in the database is not working anymore. The service broker queue error was similiar to this error:
The activated proc dbo.procedure_name running on queue database_name.dbo.queue_name output the following: '<error message>.'

View 0 Replies View Related

SQL Server 2008 :: Service Broker And Temp Tables

Feb 12, 2015

Let's say that I have a stored proc that is assigned to a service broker queue and is constantly running while it waits for messages in said queue. When a message comes in on the queue, the stored proc creates a table variable based off of the contents of the message and performs various operations with the data. Since the stored proc is constantly running, do the contents of this table variable ever truly get emptied? Should I be deleting the contents of the table variable at the end of the operation to ensure that stale data doesn't persist?

View 5 Replies View Related

Service Broker SQL 2005

Aug 2, 2006

Hi,

Wat is Service broker? wat is the use of service broker? How to use it with SQL 2005?



Thanks & Regards,

Mani

View 3 Replies View Related

The SQL Server Service Broker Or Database Mirroring Transport Is Disabled Or Not Configured

Jul 13, 2007

Hi,



I received an alert 'The SQL Server Service Broker or Database Mirroring transport is disabled or not configured'



How can I check the status of the two? and if they are disabled how do I enable them?

View 6 Replies View Related

SQL 2005, Service Broker And XML Compression

Sep 28, 2007

We have a number of large binary xml messages. I would like to compress the XML before converting to VARBINARY as much as possible. What is the recommended way to handle this if the conversions are happening in TSQL? I will also need to be able to decompress in .NET code, so I'm wondering if the best way is to just use CLR Integration for the marshaling routines, rather than building the marshaled structure in SQL. Any suggestions on reducing the XML payload size for extremely large messages?

View 1 Replies View Related

SQL Replication Vs SQL Service Broker (SSB) For SQL 2005

Aug 17, 2006

Hi

I am presently working on a requirement involving a central SQL store replicating data with 600+ stores.

Presently the no of stores is 300 and it would eventually more than 600+ shortly.

What would be the best option to use in this scenario?

I am told that for more than 600 stores the replications would serioulsy impact the performance and SSB would be more advisable.

Now i am newbie on SSB and would like to know from the experts whether its a correct way of implementation

TIA

Paritosh

View 4 Replies View Related

Enable Service Broker For DB Mail On SQL 2005 Cluster

Aug 31, 2006

I'm having problems enabling service broker for DB Mail on a SQL 2005 cluster, when I try to execute this sql it just hangs. Any ideas?

USE master ;
GO

ALTER DATABASE AdventureWorks SET ENABLE_BROKER ;
GO

View 10 Replies View Related

SQL Server Admin 2014 :: SSIS Service Fails To Start

Aug 7, 2015

i m not able to start the SSIS service on my laptop . IT gives error saying SQL server integretion service 11.0 service on local computer started and then stopped . some services stop automatically if they are not in use by other services or program

i am not able to start SSDT . it gives error

microsoft visual studio is unabble to load this document to desigen integration service package in ssdt , ssdt has to be installed by one of these edition of sql server ; std enterprise,dev,or evloution

i hav installed sql 2012 evolution verison on my local desktop.

View 1 Replies View Related

Architectural (broker) Place Of SQL Service Broker

Apr 5, 2007

Hi,



I am struggling with the position SSB could take in an SOA. If I would want a broker in the general sense, meaning an intermediary sitting between applications which exchange information through messaging, would SSB be a good candidate? I know Biztalk is probably the primary candidate, but in my scenario I would end up with Biztalk apps with empty orchestrations. Also, I think Biztalk is more expensive to manage. So I am looking for a lightweight broker for a simple SOA targeted at application interoperability, no fancy business processes in sight.



I look forward to some responses.



Kind regards,

Neeva

View 2 Replies View Related

(Windows Server 2003) Cannot Run SQLSERVERAGENT Service Under Non Admin User After SP1 Installation

Aug 14, 2006

Hi All,

I need a hand here, referring to this knowledge base on Microsoft (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q283811) i applied this knowledge base, and it worked, the MSSQL and SQLSERVERAGENT have run under local non admin account.

But after i installed SP1, MSSQL service is ok, but SQLSERVERAGENT wont run. The warning message is : "Some service run and then stop if they have no work to do."

Is there any way i can install SP1 but in the same time run SQLSERVERAGENT under local non admin account?

Your assistance will be much appreciated

thank you very much in advance.

Felix Adhitya

View 4 Replies View Related

SQL Server Admin 2014 :: Service SIDs With Data Files On CIFS Share?

Jan 13, 2014

I want to use service SIDs for my SQL Service accounts but also want to have the data files on a NetApp filer CIFS share. The 2014 installer prevents installation if CIFS and Service SIDs are used. I tried to install with domain account on CIFS, and then to swap back to Service SIDs afterwards, but couldn't find a way to do it.

I granted the AD Computer account Full Control to the CIFS share, so it should work, but I just can't work it out at the moment.

View 0 Replies View Related

SQL Server Admin 2014 :: Does Changing Service Account Update NTFS Permissions

Nov 22, 2014

If you were to do a fresh install it would set permissions on the disk so everything just works.

Now when changing the service account (e.g. to a domain user) use the configuration manager, does it do the same magic (possibly sans if the database data/log files are on another disk)? Or do you need to trawl through the dozens of folders and assign rights manually?

View 1 Replies View Related

SQL Server Admin 2014 :: CLUSDB Files Missing - Cluster Service Not Coming Up

Oct 9, 2015

I have configured windows failover clustering 2012 on 4 of my test nodes.

I am trying to add another node into this cluster but its not happening. I am not even able to start the cluster service in services.msc

After installing windows failover clustering, when I go to the C:WindowsCluster folder, I am unable to find CLUSDB, CLUSDB.1.container, CLUSDB.2.container and CLUSDB.blf files in the folder.

These files are very much present on the other nodes where cluster service is running.

I tried copying these files manually to server where its missing but still no luck.

View 1 Replies View Related

Where Is SQL Server 2005 Diagramming Tool?

May 19, 2005

I currently install SQL server 2005 CTP and I couldn't find the diagramming tool which used to view the conceptual model of the database structure, relationships and entities visually. This diagramming tool feature is available in SQL server 2000, however I couldn't find in SQL server 2005. Anyone would like to give me some recommendations or show me where this feature is hidden?  

View 1 Replies View Related

32 Bit BI-tool Connecting A 64 Bit SQL Server 2005

Mar 28, 2007

Hi,



I have Cognos 8 as BI-tool installed on a Windows 2003 Server, both 32 bit. We are thinking of using a 64 bit SQL Server 2005 with 64 bit Windows 2003 Server as database server for a new data warehouse.

Can I use the 32 bit SQL Native Client on the Cognos server for connecting to the 64 bit database server? If not, how should I set this up?



Thanks in advance for your help.



Kind regards,



Albert de Ruiter.



View 3 Replies View Related

Cannot Connect To SQL Server 2005 DB From ASP.NET Configuration Tool

Sep 25, 2006

Hello,I am trying to connect to a DB, which is hosted on an SQL Server 2005 by a provider, using ASP.NET Configuration Tool. The result is the following error when I click on the Security Tab:---There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---The hosting provider checked that my connection string is correct. They do not know why I get the error, though. Here is a relevant snippet from my web.config:<connectionStrings> <remove name="LocalSqlServer" /> <add name="LocalSqlServer"connectionString="Data Source=ABC;Integrated Security=false;Initial Catalog=ABC;User ID=ABC;Password=ABC"providerName="System.Data.SqlClient" /></connectionStrings>ABC is a mock :)Could anyone pls help? It is much appreciated.

View 4 Replies View Related

SQL Server 2005 && 2000 Tool Compatibility

Jan 31, 2006

Can someone tell me if I can use the Gui tools which come with SQL Server 2005 against 2000 databases ?

View 1 Replies View Related

Online Query Tool SQL Server 2005

Feb 18, 2008

Hi,I was wondering if someone could help advise me.Basically i have a client who wants to upgrade from a desktop msaccess solution to a web based system using MS SQL Server 2005.Basically their main concern is in losing the ability to write ad-hocqueries using the MS Access query manager. I can obviously writestatic reports etc but whats the best way to give them someflexibility ??Can anyone advise me if there is any product that can do this for SQLServer 2005 (which im sure there is) but will work in a webenvironment.Or does anyone have any helpful ideas ???all help / advice greatly appreciatedCG

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved