You should use a .Net DLL as it runs inside SQL Server 2005. The issue that most DBAs have is with External Stored Procedures, which are written in C++ and can bring down SQL Server, don't get backed up, and can do lots of nasty things. A .Net DLL will solve those problems.
>Sorry, this is the 3rd different way of trying to figure this problem out. We are running SQL Server 2005.
> We need, when a specific table in the server has a record inserted into it, we need to make sure that that record info is written out to a special file.
>
>hope that makes sense.
>Beth
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer