Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server notification services > october 2006

Query Notification Design?
Posted by romancoelho NO[at]SPAM gmail.com at 10/27/2006 8:37:57 AM
When using Sql Cache Dependency with Sql Server 2005 it's my understanding that you should use Query Notification. My question is let's say I write a Sql statement with a WHERE clause in it. Does the cache dependency fire if only the data within that WHERE clause changes or if anything in the ta...more >>


Intermittent email problem
Posted by RDV at 10/25/2006 10:02:28 AM
I am receiving the following error in the application event log file. It only happens intermittently. The SMTP server and email addresses are valid and available at the error times in question. This error is followed by a delivery failure message. Running SQLNS 2.0 SP1 on SQL Server 2000 ...more >>

NSTutorial Service won't start
Posted by Bob at 10/24/2006 1:36:01 AM
I can't get my NSTutorial service to start. I've edited the ICF as per the Walkthru, and everything seems fine. The app registers successfully, the Service Account is set up and can access the databases and read / write to the proper Notifications directories. However when I enable the ser...more >>

dynamic conditions
Posted by puneetdk NO[at]SPAM gmail.com at 10/23/2006 10:12:50 PM
Hi Guys, I need to add dynamic conditions to my subscriptions. My situation is like this: Users are presented with a ad-hoc query builder and they can select upto 10 fields to put in the where clause. I have created the App. definition file and the application works with hard coded subsc...more >>

Don't send mail if no records returned
Posted by Sanjeev Rampersad at 10/23/2006 3:06:02 PM
Hi All, I have the standard version of SQL Server installed. I have setup a few reports that will be automatically sent to some out clients on a daily basis via a normal email-based subscription in reporting services. On some days, these reports are blank i.e. no rows returned in the datase...more >>

Error to install SQLMail
Posted by jmeykos at 10/19/2006 5:54:01 PM
I tried to install the service SQLMail in my SQL2000 Enterprise and give me this error: Error 18030: xp_test_mapi_profile: Either there is no default mail client or the current mail client can not fulfill the messaging request I have install the Outlook 200 and function well. I can send and re...more >>

NS with Remote DB Server?
Posted by tarpan at 10/16/2006 7:21:01 AM
Hi everybody, In good old times with a one server everything worked fine. Now I have 2 servers: web server + DB server. I have deployed NS Instance to the Web server with DBs created on the DB server. Installs nice and easy. However, my Subscription management App (ASP.Net based) crashes...more >>

Notification database
Posted by Nick at 10/8/2006 9:11:02 PM
Hi All: i am very new to notification service, I just created a instance notification in sql 2005, and i found it auto created two database , can anyone explain what's those two database differents? Cheers Nick...more >>



Is this the only NS newsgroup?
Posted by corey_bunch NO[at]SPAM yahoo.com at 10/5/2006 5:29:56 PM
Does anyone know of a more active newsgroup on SQL Notification Services? This group has become progressively less used over the past several months or so. I'm trying to find some answers to some questions...... ...more >>

Where the NS DB is...
Posted by GeoffN at 10/3/2006 12:53:30 PM
When you install the NS Sample "Flight" where does it draw it's data from? I only ask because I cant figure out where the tables "Flight" it keeps querying from exist. Thanks in advanced ...more >>


DevelopmentNow Blog