Category Archives: System Functions and Stored Procedures
-
Notes on debugging Database Mail problems
10July 29, 2013 by Kenneth Fisher
I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
Continue reading -
Generic Dynamic SQL Stored Procedure
5July 22, 2013 by Kenneth Fisher
Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
Continue reading -
Metadata Functions (OBJECT_NAME for example)
Leave a commentJune 24, 2013 by Kenneth Fisher
What is a metadata function? According to BOL a metadata function is one that returns data about the database or …
Continue reading -
GO
6May 6, 2013 by Kenneth Fisher
Did you know that the GO command isn’t really part of T-SQL? It’s what’s called a batch separator. And in …
Continue reading -
INFORMATION_SCHEMA the un-sung system views
13April 29, 2013 by Kenneth Fisher
I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. …
Continue reading -
How do I tell the stored procedure name from inside the stored procedure?
1April 24, 2013 by Kenneth Fisher
I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re …
Continue reading
SQL Studies 