>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.
>
That's a whole new area. Also how would you create this NET Dll if you don't have VS, for example?
>>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
If it's not broken, fix it until it is.
My Blog