December 22, 2008 at 10:14 am
I am a new DBA who has created a daily server status report using SQL Reporting Services. I have not yet found a easy way to include Windows NT Event log error type of messages. I had found a VB script a week or so ago but did not go through it. There is a place to run custom code for a SQL Reporting Services report. Has anyone tackled this yet? And willing to share?
Thanks,
Tammy
December 22, 2008 at 1:32 pm
If you are open to SQL CLR, Microsoft has a TVF Sample that you can use to do it with a simple select statement.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
December 22, 2008 at 1:33 pm
The URL and example of doing this with SQLCLR is:
http://msdn.microsoft.com/en-us/library/cc655659(SQL.90).aspx
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply