That seems to be the ticket. The instead trigger is fired once, and the after trigger is what continues to recurse.

USE [master]

GO

ALTER DATABASE [YourDatabaseName] SET RECURSIVE_TRIGGERS ON WITH NO_WAIT

GO

USE [YourDatabaseName]

GO

IF...

I like to use Database Roles and only grant permissions to the Roles even if the Role will only have one member initially. Consider that if a person leaves an...

Not a credit thing...just wanted to highlight that Steven was pointing towards a solid solution in case you crossed the posts up and missed the link he posted.

Creating a SQLCLR object to do this is going to be your best chance initially. Ideally though you would not have stuff like that running in your data tier, and...

bugg (3/14/2013)

---

GilaMonster (3/14/2013)

---

You can...

What build are you on?

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

SERVERPROPERTY('ProductLevel') AS ProductLevel

Can you...

I do not typically recommend third-party solutions for SSIS, but in this case it's probably not worth re-inventing the wheel:

http://www.cozyroc.com/ssis/edi-source

cljolly (3/14/2013)

---

Thank you opc.three. I changed my code to look like yours and it works. There are a couple flaws (in the results, not your code) such as...

brettstahlman (3/14/2013)

---

Thanks. Hopefully someone from the SQL Server team will weigh in on this, as it appears there may be an error in the documentation/spec. I started to call it...

I'll have to agree with Phil. Your comment about who was defining tables gave me a bit of a shiver.

re: item 2, I agree the interface is clumsy but it...

Tell him there is nothing analogous on SQL Server and not to worry about it. If he is worried about resource allocation within an instance he can look into the...

I see what you mean. It appears when the AFTER trigger is the first one to fire, nothing carried out within that trigger done against the base table will fire...

I would recommend staying clear away from xp_cmdshell. It opens up a huge can of worms from a security and auditing standpoint and accessing the file system or the command...

Have a look into EncryptSensitiveWithPassword the option. You could also look into using a Package Configuration (of some kind) to store the connection string with the password in it but...

BIDS Helper has a Smart Diff feature that will ignore some changes in the XML, and hopefully only leave the real changes highlighted. Not that we can always make sense...