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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|