Thanks for the answer. So I don´t need to install Reporting Services on the nodes in the cluster and the reporting databases is in the cluster? Correct?

I want to have my Database Engine on the cluster and Reporting Service on the Remote Server. So I want my application to have the Database Engine on the cluster...

No I meen a remote server, separated from the cluster, with SQL Server installed.

Thank you all for your replays I have now solved it on both ways

Trigger way

CREATE TRIGGER [dbo].[reminder2]

ON [dbo].[my_table]

AFTER INSERT, UPDATE

AS

IF (SELECT COUNT(*) FROM inserted WHERE my_column = 'XX')...

Our system print errorcods in a table and I want a mail when we get this errorcods in the database

It is a user database and a user table holding errorcods...

Thank you Ten.

It works fine.

I´m not a good programmer, so how will I do if I just want a message when, for example, a number 1 is inserted in...

This link solved my problem

http://www.mssqltips.com/tip.asp?tip=1823

🙂

Isn´t it possible to create a comma-separated file from a query. I can create a file with this query

DECLARE @cmd VARCHAR(2048)

SET @cmd = 'OSQL -Stest\SQLSERVER2005 -dtest -E'

...

OK Thank you!

/ERIK

Thanks for the answer but if you set the model database in simple mode can I change some of my user database to be in full mode and some still...