Still I'll have a look at that article you suggested...

One can always learn something new.

Also thanks for the

ID IN (SELECT ID FROM INSERTED)

I actually did it like this, the example was just quick and dirty....

Awesome! Thanks a lot Jack.

I was dazzled by the absence of a BEFORE Trigger. But well, thats how it works.

Thanks a lot - all of you.

Apparently it would always be best to validate the user input at the user level. But I cannot do anything about that....

I thought about that earlier...maybe there is a way

Thanks a lot!

This trigger is executed for every insert statement, isn't it? I'm a little worried about performance issues: Can't I just fire it if the error occurs? Like a try/except mechanism?

Best...

Exactly....

Thats a first step. But I don't want the whole row to be eliminated, only the datetime value reset to be null or something else. Is there another solution than...

Thanks Vladan,

the idea is good, but unfortunately not applicable in my case. I have thousands of insert statements where only a minimal subset has data of that type, ranging from...

Steve Jones - Editor (1/22/2008)

---

[...] What are you trying to do? If you have a script that executes as your login, then it will work with the SQL Agent one,...

Thx!

Another session you say... that makes sense. But how can I address the current session? I created a "credential" that maps to the user for which I want the script...

Add on:

[font="Courier New"]Set ShellWSH = CreateObject("WScript.Shell")

ShellWSH.Run """" & "notepad" & """" & "xy.txt", 1,false

Set WshShell = Nothing[/font]

I'm not quite sure if the "1,false" makes this difference - I guess it...

Marvellous you guys.

Thanks a lot for the helpful answers!

I'm fine now. But as I know MS Products it might not last forever...

Later!

Dankwart

Certainly I got your point, Don Corle... äh Grasshopper. Except from this one: Whats with the "init"?

Full backup with init

Diff Backup with init

Log Backup

Log Backup

Log Backup

Log Backup

Diff Backup

Log...

Awkwardly I restricted the logfile not to grow beyond 10GB. Obviously I'm missing something there...

It was 65GB and the hard drive was running out of space.

The log backup...