GeekArticles
Database
SQL Server
Database
SQL ServerCoding-in-SQL issue: A SQLCLR Stored Procedure to Write to a Trace File
This issue shows a stored procedure written in Visual Basic.Net that writes a line of trace information to a file. It's an example of an assembly that uses requires the External_Access permission set. Included is a discussion of permission sets and some of the error messages encountered while creating the procedure. The download includes the source code and an example output file.
Sponsored Links
Read Next: Enhanced SQL Server Security Auditing
Related Topics
Subscribe via RSS
SQL Server
- Naming Database Objects: Part II
- Trace Messages Part V: Trace Cleanup
- Naming Database Objects: Part I
- Multiple-Child Aggregation
- Creating SQL Tables for an Integrating Application Using Dexterity
- SQL Server 2005 Beta 2 Transact-SQL Enhancements
- .NET Rocks! - Brian Larson on SQL Server Reporting Services
- Computing the Trimmed Mean in SQL
- SQL Server 2000 Gains on Oracle
- Separator First Formatting (SFF)
