NS-> ContentFormatter -> Custom Formatter assembly cached???
Fri, 23 May 2008 08:34:02 -0700
Hi guys,
I have one Notification Services (in MSSQL 2005) and two Application in it.
Each Application has ContentFormatter with different Custom Formatter.
(assemblies are in different folders)
Code Snippet
..................
<ContentFormatter>
<ClassName>NS.NotificationFormatter.CustomFor ...
|
Email query result
Thu, 8 May 2008 13:11:01 -0700
Hi,
I am new to SQL 2005.
I was trying to set up SQL agent to send a query result via email.
EXEC msdb.dbo.sp_send_dbmail
@recipients = 'user@company.com',
@query = 'SELECT * FROM msdb.dbo.DASD,
@subject = 'DB Space',
@attach_query_result_as_file = 1 ;
The error message was:
Msg 102, Lev ...
|
SMTPSVC Error
Wed, 7 May 2008 08:06:01 -0700
Hopefully this is the correct group to post this to.
My SQL server is generating numerous SMTPSVC 4000 error messages. We have
alerts and notifications setup that to alert the helpdesk when backup jobs
complete and if other problems arise. the errors are gernerated every 10 -15
minutes on the SQL server b ...
|
Aggregated Query not working in Query Notification - Any ideas
Thu, 10 Apr 2008 13:40:00 -0700
We are using an aggregated query for query notification
MSDN says you can use count_big() and sum() with group by clause.
select entry_date, count_big(entry_date) as cnt from dbo.my_stats where
entry_date > '2008-04-10' group by entry_date
entry_date is a column in composite key and hence its a NOT NULL c ...
|
Multiple subscribers
Wed, 19 Mar 2008 03:06:18 -0700 (PDT)
Hi All,
I need create a notification service by e-mail.for this i have given
"To" field as DeviceAddress.
but it doesn't work.In the deliverystatuscode gave 4 is not but
deliveryfail.
can any one help me out for sending a notification service to
different subscribers. ...
|
Setting up email for Operator in SQL2000 - ERROR
Wed, 19 Mar 2008 00:08:00 -0700
Hi,
I'm trying to set up an Email name for an operator to be used inSQL Agent.
When I test the Email Name, I get an error:
>
Error 22022: SQL Server Agent Error: The SQL Server Agent Mail session is
not running: Check the mail profile and/or the SQL Server Agent Service
startup account in the SQL Server Ag ...
|
Errors trying to setup Database Mail in SQL 2005
Mon, 10 Mar 2008 10:24:02 -0700
I have gone thru and set up Database Mail and am trying to send a test
message. When I send the test, the following is shown in the log:
Exception Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Data: System.Collections.ListDictionaryInternal
TargetSite: Mi ...
|
|
|
"Notification Services" compared to "Query Notifications"
Tue, 4 Mar 2008 12:21:18 -0800 (PST)
Hello everybody,
Can anybody explain be the difference between "Notification Services"
and "Query Notifications"?
At the moment I'm using the SqlDependency class which, as i think, is
based on "Query Notifications".
This morning I've seen different postings about the fact that SQL
Server 2008 will no longe ...
|
Insert Matching Events to SQL Table
Thu, 28 Feb 2008 08:34:13 -0800 (PST)
I have setup a few applications with NS, but always with SMTP as the
delivery protocol. I need to build another instance were the result
ends up as inserts to a SQL table. Can I accomplish this within the
ADF or do I need to build a custom delivery proctocol to insert the
rows?
Thanks
Rolando ...
|
Our new website
Fri, 8 Feb 2008 15:33:11 -0800
This website is for artist, freelancers, programmers, writers, translators. All who is looking for work.
If you are a skilled professional use page "Add profile" to create your profile.
Also this website is for those who is looking for skilled professional.
If you are looking for a professional use page "Pr ...
|
