Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table or view.
28 May 2006 20:22:47 -0700
I am having problems enabling sql table for notifications in sql 2005.
The problem is that when i use custom schema name i get following
error:
Cannot create trigger
'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its
schema is different from the schema of the target table or view.
Ev ...
|
multipart mime emails with ssns built in SMTP Protocol
Fri, 26 May 2006 15:18:02 -0700
Is there a way to send Multipart MIME emails with the Notification Service
built in SMTP Protocol? Multipart emails being both text and HTML.
Thanks in advance! ...
|
Earn up to 1000 $ per month only for reading your Mails!!!!!!!!
Tue, 23 May 2006 16:21:02 +0200
...
|
Installing SQL 2000 NS App on SQL NS 2005
Sun, 21 May 2006 13:08:23 +0000 (UTC)
I have been working with some folks attempting to install the Notification
Workflow Solution Accelerator for MOM 2005 on SQL 2005 Notification Services....an
application that was written for the SQL 2000 version of Notification Services.
We are able to perform the installation, but when we attempt to l ...
|
How to stop events from firing for the same thing twice...
Fri, 19 May 2006 07:07:54 +0000 (UTC)
Hi,
I have a trigger that fires events to SSNS on INSERT and UPDATE to my table.
It all works fine, execpt that in my application that uses this table, there
is code in there inserts to the table and then immediately fires an update.
This results in 2 events being fired almost at the same time and so 2 no ...
|
monitor sql backups
Thu, 18 May 2006 22:33:02 -0700
I currently receive a notification if my sql backup fails through sql agent.
However, there is always an outside chance that the sql agent is not working
either in which case I have no notification if my backups fail.
Perhaps one can easily write a command prompt code to monitor the dates on a
folder an ...
|
Using SPs to fire events - but the notifications dont get sent!
Thu, 18 May 2006 12:55:46 +0000 (UTC)
Hi,
I hope someone can help me! I have setup triggers on a table, so that when
the table is inserted to or updated, it fires an event to my SSNS application,
which should then send a notification email out.
For some reason, the notifications are not being sent out. I cannot find
any evidence of them be ...
|
|
|
MSSQL Server 2000
Wed, 17 May 2006 20:53:01 -0700
I have installed MSSQL Server 2000, necessitated by an accounting program, no
longer in use. Can I safely delete or remove MSSQL Server and how? ...
|
Where are SSNS's dates coming from?
Thu, 11 May 2006 11:53:06 +0000 (UTC)
Hi,
I'm a little confused as to where SSNS gets its date information. If I connect
to my SSNS database on my database server (local), and type "Select GETDATE()",
I get the correct current date.
But, the date information entered in SSNS tables is always offset by an hour.
So for example if I "Select * ...
|
Multi Server Deployment Scenario - What Port Does NS windows service use for communication?
10 May 2006 18:52:02 -0700
Hello All,
I am having a multi-server deployment scenario. my DB Server will
reside in our domain and would run the NS instance windows service . In
other words, my DB server is behind a firewall. Our Web server would be
outside this domain. the web server would host the subscription
management UI. The web ...
|
