Dugi's got you on the right track. use ISNULL to put in a default value, or raise an error before it gets to the trigger in the first place.

as...

ps (6/19/2009)

---

you can write a query to delete all tables in a schema.

Also wouldn't it be good to drop the database if you do not want tables to be there?

Question...

your'e trying to use an identity() column in the wrong way; an identity should simply identify one row as unique, and should never repeat...what you want is basically a ranking...

it can be done yes...but it's going to involve a bit of work. search for "FTP" on this site, and look at "Scripts" ; there s quite a few contributions...

GilaMonster (6/19/2009)

---

You wanna maybe tell me why you want to remove an entry from an error log? The main use I could see for that is to hide evidence of...

'ftp://username:password@xx.xx.xxx.xxx/domainname/www/textdocument.txt' is not a static filepath..., you have do download the file from your ftp site to a location on the server(or maybe in anetwork share if your account...

it might be that you need identify the columns to insert into:

INSERT INTO DatabaseReport.dbo.Database_File_Info(col1,col2...)

did i misread the question? i thought he wants audit triggers to write to a separate database,and didn't see where anything about a separate server.

I thought it would be a...

no, it's my ignorance John, sorry...

I know the HTML way to get the desired action, but not how to do it via the Reporting Services Interface.

I think Nate pointed you...

yes, you can uninstall FTS, and then re-install it;

ive done that with FTS and reporting services; it doesn't break any other part ofg your installation.

If it is the right version, you'll need to rerun the setup. You can go to Add Remove programs and find SLQ express..the dialog would have a modify option so...

i think something like this would work:

CREATE TRIGGER TR_TEXT ON [uitgifteregel]

FOR INSERT

AS

BEGIN

IF EXISTS(SELECT [oaantal]

FROM...

no need to add duplicate posts if you didn't get the answer you were after;same question was asked here:http://www.sqlservercentral.com/Forums/Topic735615-145-1.aspx

the more information you provide, the better we can help you.

show us...

duplicate...

that's a good question.

do a select * from sys.traces

the first column, "id", is the traceid.

with that value, you could stop and then delete the trace:

assuming the traceid is 2,...