Recent update: 2008-3-21
Hi, Is this possible to receive notifications from Notification Service in my windows application written in Framework 1.1? I am using SqlServer 2K. I want to create a notification when number of rows in a given table reach a specific limit. I want to receive the notification in my application ...
572 byte By
RDV at 2008-3-6
Hello, I have multiple linked servers setup to go to various data sources. All data sources are basically the same ... just different data for the different locations. Currently I have different subscription classes and associated matching rules for each linked server. Is there a way that I ...
6606 byte By
mcass at 2008-3-5
Had a couple questions about some Event ID 6702 errors on the server I’ve been getting recently.I can’t seem to find any intelligible information on Microsoft’s site about it; however, I did find this: http://support.microsoft.com/kb/842006/en-us#XSLTH5294121122120121120120 There are no ...
165 byte By
mmssi at 2008-3-3
I am new to SQL 2005 and want to setup a notification service to email me when a job fails. How do I begin to set that up? Any basic examples I can check out?
Hello All,</P> perhaps a stupid question, </P> Notification Services replace triggers to detect changes in a database table ?</P> Olivier</P>
Hi everyone, Im not into VB scripting...On SSNS, im trying to add subscribers and subscriptions using VBscript. I have been successful in adding subscribers but am getting an error while trying to add subscriptions... here's my code and the error: PS: the tutorial code doesnt help much though ...
How create a custom delivery Protocol class and show data in the Grid?</P> any advice and is good at having sample code?</P>
Functionallity of the Application-- "We have a large legacy application using SQL Server 2000. We're gradually adding .NET WinForms controls to it, using the IdeaBlade DevForce package as the data access layer, and primarily Infragistics Grids and other controls for display. We're using ...
We have SQL NS 2005 with our ADF with the following setting: <Vacuum> <RetentionAge>P7DT00H00M00S</RetentionAge> <VacuumSchedule> <Schedule> <StartTime>05:00:00</StartTime> <Duration>P0DT02H00M00S</Duration> </Schedule> ...
So I have a little snippet of code as follows: _nsServer = smo.Server(nsServerName);_notificationServices = _nsServer.NotificationServices;_nmoInstance = _notificationServices.Instances[instanceName];_nmoApplication = _nmoInstance.Applications[applicationName]; This is in a class that's in a ...
301 byte By
Anjana at 2008-2-23
Hi, I am just looking for the best and worst scenarios to implement Notification services...This is more to come up with a design guildelines I Would be more interested in the worst sceanrios :) Please share your inputs based on your experiences... Regards, Anjana ...
Hi i was wondering if notification service allowed for 2 notification classes with in one aplications I have a running notification instance that notifies me when a colums value in my database is set to '1' this works fine. But i also want to be notified when the colums value is set to 0 ...
2280 byte By
MFaulk at 2008-2-22
I'm using the Service Monitoring Solution Accelerator to configure Notification Workflow. Everything works with the exception of e-mail delivery. E-mails are not sent; but events are logged. I've included the event as well as an excerpt from the appConfig.xml file. Event Type: ErrorEvent ...
6606 byte By
mcass at 2008-2-21
Had a couple questions about some Event ID 6702 errors on the server I’ve been getting recently.I can’t seem to find any intelligible information on Microsoft’s site about it; however, I did find this: http://support.microsoft.com/kb/842006/en-us#XSLTH5294121122120121120120 There are no ...
I'm trying to set CC (CarbonCoby) and BCC properties of an email notification. The SMTP protocol element of my ADF looks like this: <Protocol> <ProtocolName>SMTP</ProtocolName> <Fields> <Field> <FieldName>Subject</FieldName> ...
Folks, I want to let everyone know that the 2005 update to my Notification Services book is now available for order. You can get it from http://www.amazon.com/gp/product/0672327791/. This book has been completely updated for the 2005 release: - All source code examples are now designed to ...
I have installed the SQL Server 2005, including in the installation the notification serviceis, I want to check that <font color="#ff0000">Notification Services engine components </font><font color="#000000">is insalled, </font>how can i do that?!
I have installed SQL Server 2005, including all of its services like Notification service on my machine and i have create a new notification service, and it is already enabled and started. on the code in vidual studio, after i included the Dlls required. i make a new instance of this created ...
397 byte By
Ed77 at 2008-2-18
NS gives you the ability to structure your XSLT files in a 'subscriber locale' directory structure (one folder for en-US ; one for es; etc.). This allows you to have only one Notification Class per email, regardless of the locale. But how do you localize the Subject line, since it is part of ...
155 byte By
Spyros at 2008-2-17
I have starting using Notification Services and I was wondering if somebody can tell me if the NS use triggers behind the scenes in order to start events.
Hello,We are seeing portions of text missing from our notification emails using NS 2.0 and the built in SMTP delivery protocol.The notification looks fine in the MS notifications table -- no missing text in the field that becomes the email body, so it may be a bug in the xsl transform code ...
I just have a question around the SubscriptionClass class. I'm not grasping why there would be multiple rules for a single SubscriptionClass. Can someone give me a good use case for it? It seems to me that since the primary use of Rules are to generate Notifications from Subscriptions. The ...
723 byte By
Shash at 2008-2-15
Could anybody help provide some detailed information about installing BSM with SSRS 2005? My installation needs to have SSRS running on a different box than the BSM server. There are 2 issues involved here: The BSM Server.msi by default looks for Reporting Services 2000. I need to have the ...
Can any one provide me with Tutorials for beginners?
Hello, I am interested in being able to be notified when someone inserts a new row into a table. I have a list of objects bound to a combo box using table adapters in Visual Studio.NET 2005. I would like for my application to be able to subscribe to this notification and know if the list the ...
Hello, I'm trying to understand how Notifications Services work and i'm looking under Microsoft Sample Tutorial for more information but I always get stuck at this point... To create the instance of Notification Services In Object Explorer, right-click Notification Services and select New ...
Hello,I have been exploring NS and I would like to use it as a rudimentary transfer tool. I have an existing database table from where I would to transfer a record to subscribers and then possibly move the records out of that table. 1. How do I set up the ...
Now that slq2005 is out can we still distribute MSDE 8.0 or do we have to move up to 9.0 sql express? Please include links on subject if you happen to have them. Thanks, Dave
I created my Notification instance, enabled, register, start sucsesfully. Then I added Subscription and Subscriber Finally I run the query to add Events to my event class. The NSEventBeginBatch<EventClass> returns a valid BatchId The NSEventWrite<EventClass> inserts 1 row And ...
I created my Notification instance, enabled, register, start sucsesfully.Then I added Subscription and SubscriberFinally I run the query to add Events to my event class.The NSEventBeginBatch<EventClass> returns a valid BatchIdThe NSEventWrite<EventClass> inserts 1 rowAnd ...
Now that slq2005 is out can we still distribute MSDE 8.0 or do we have to move up to 9.0 sql express? Please include links on subject if you happen to have them. Thanks, Dave
I'm trying to just get a basic NS app up and running. While I can get through the samples just fine, it seems there are no samples that programmatically manage Instances/Applications, etc. I've googled around and not found anything either. Essentially it looks to me that everyone uses the ...
586 byte By
GUYO at 2008-2-10
Back in version 1.0/1.1 of SNS that was a delivery channel for Exchange Messenger under Exchange 2K. Since the Messenger Server has moved over to LCS 2003/2005 has anyone create the linkage between SNS2.0 and LCS2005?There idea is that the protocol would be sip but that the redirector on LCS ...
Hi,It suppose to be real simple, but I can not find out how to do it. I have a SQL server and Web server on 2 separate PCs. When I create NSInstance objectNS_Instance = New Microsoft.SqlServer.NotificationServices.NSInstance(NS_InstanceName) .Net tries to access NS right on the Web server.How ...
Hello,We are seeing portions of text missing from our notification emails using NS 2.0 and the built in SMTP delivery protocol.The notification looks fine in the MS notifications table -- no missing text in the field that becomes the email body, so it may be a bug in the xsl transform code ...
Hello,I am interested in being able to be notified when someone inserts a new row into a table.I have a list of objects bound to a combo box using table adapters in Visual Studio.NET 2005. I would like for my application to be able to subscribe to this notification and know if the list the app ...
We have SQL NS 2005 with our ADF with the following setting:<Vacuum> <RetentionAge>P7DT00H00M00S</RetentionAge> <VacuumSchedule> <Schedule> <StartTime>05:00:00</StartTime> <Duration>P0DT02H00M00S</Duration> </Schedule> ...
322 byte By
Amby at 2008-2-7
Hi All,I am using Notification Services 2005.I have done with the configuration and deployment of Notification Services 2005.Now i wanted to know how to send notifications via email with custom attachments. Please help me out in this issue. ...
As the topic says I found a way to give notification services API the ability to do transactions. This is accomplished by using DTC transactions. Given that the API just boils down to some SQL call and SQL is DTC aware it will take advantage of the current transaction. Thanks Wayne Sepega ...
We have SQL NS 2005 with our ADF with the following setting: <Vacuum> <RetentionAge>P7DT00H00M00S</RetentionAge> <VacuumSchedule> <Schedule> <StartTime>05:00:00</StartTime> <Duration>P0DT02H00M00S</Duration> </Schedule> ...
When upgrading a database from MSDE to Visual Studio 2005 Express, I've noticed that the system tables in the MSDB database don't get upgraded. For example, the SYSSCHEDULES table doesn't get added. Is this by design or a bug?</P> -Doug</P> </P> </span>
We have rolled out a solution on SQL 2005 and NS for 2005. As we have been looking into reporting notifications from our system I came across that a column that is created out of the box does not make sense.In the generated table NS<NotificationClassName>Notifications there is a column ...
We have rolled out a solution on SQL 2005 and NS for 2005. As we have been looking into reporting notifications from our system I came across that a column that is created out of the box does not make sense.In the generated table NS<NotificationClassName>Notifications there is a column ...
Hello,We are seeing portions of text missing from our notification emails using NS 2.0 and the built in SMTP delivery protocol.The notification looks fine in the MS notifications table -- no missing text in the field that becomes the email body, so it may be a bug in the xsl transform code ...
9200 byte By
shav at 2008-2-4
Hello all. We are a small taskforce currently working on a system of which utilizes the SQL notification service. For this we are using dependencies provided by SqlDependency. The dependency is set up as follows: //Where dbo.MTable is the table and guid is the unique key of the records. We ...
Does anyone have experience using the new VS 2005 (.NET 2.0) with Notification Services 2.0 and SQL 2000, does it work?We're far away from upgrading to SQL 2005, but I'd like to use the new developer tools (ASP and C#) to upgrade my subscription management interface.Thanks,Marcus ...
We have rolled out a solution on SQL 2005 and NS for 2005. As we have been looking into reporting notifications from our system I came across that a column that is created out of the box does not make sense.In the generated table NS<NotificationClassName>Notifications there is a column ...
Hello, I apologize for this total newb question. I recently purchased Shyam Pather’s book on SQLNS and am currently working through chapter 5. I hit a snag on page 149. Everything runs great until the call to nsInstance.Initialize in AddSubscribers.vbs. I verified that the registry keys are ...
Does anyone have experience using the new VS 2005 (.NET 2.0) with Notification Services 2.0 and SQL 2000, does it work? We're far away from upgrading to SQL 2005, but I'd like to use the new developer tools (ASP and C#) to upgrade my subscription management interface. Thanks, Marcus
8672 byte By
R.A.F at 2008-2-3
Hi Alls!I m new to SQL Notification Services. I m trying out an example as mentioned on the following article. http://www.devx.com/dbzone/Article/28522I created an Notification Application using nsControl.exe in SQL 2K5 which is based on the File Channel Protocol. The scenerio is. When we add an ...