One of my colleagues sent me a very handy bit of code this morning that I thought would be helpful to post. Below are two options which, when run against the database, should return the names of all stored procedures that reference the named table. I am told that the functionality of the first option … Read more
By modifying the code I used for sending email attachments, I am able to execute a SQL Server stored proc and format the results as an HTML table in an email. Also, I use the sys.exit command if there are no rows returned so that the email is not sent if there is no data … Read more
SQL Server Reporting Services is a great tool that comes with SQL Server, and it is the tool I prefer to use when a report is needed. I have built and continue to maintain many such reports, and once the reports are built, they don’t often need updating, unless the database schema changes or the … Read more