OK, thanks, that's really a different version and a copy&paste failure. The script body of the first one should look like the second one.

But this could be the problem. The...

SELECT c.name AS FK,e.constraint_column_id AS FKc,d.name AS P,f.name AS Pcol,g.name AS Ptype,b.name AS C,h.name AS Ccol,i.name AS Ctype

FROM sys.foreign_keys a

INNER JOIN sys.objects b ON b.object_id = a.referenced_object_id

INNER JOIN sys.objects c...

Ha, there is the system table foreign_key_columns. I will test a little bit.

I'm back. Great, the trigger script fits me needs.

@jason: the hierarchy would be very interesting too, but for me it's only interesting, if there is a trigger which relates to...

That sounds great, I'll test this and give a feedback.

I know the existence of sys.triggers. But for me it's interesting what the trigger does respectively what other tables a trigger touches.

RBarryYoung (9/30/2009)

---

From the BOL entry on XP_CMDSHELL:

' command_string '

Is the string that contains a command to be passed to the operating system. command_string is varchar(8000) or nvarchar(4000), with no...

Ha, just some minutes before your post, I have the same intuition.

I'm trying to script a backup tool for backing up only some specific tables of a database. So I...

When endless running, there is the following situation (Windows XP Prof.):

CPU 0%

BCP is in task list with 0% CPU and nearly 4 MB memory consumption

there is also a cmd.exe in...