Browse by Tags

The joy of template parameters
15 July 2007 20:23

I thought I would do a quick blog about template parameters since I have been writing allot of standard deployment scripts for our 2005 builds and have used them extensively. So what are they? Well they are place holders and you would you use them in the same places that you would probably put a variable. The key difference comes when you assign the values. With... Read More...

by ACALVETT | 1 comment(s)

Filed under: SQL 2005, SQL 2000, Tools

What is that SPID doing?
27 March 2006 17:44

This is certainly not a new topic but something that i felt was worth revisiting and reminding people about, especially because i find many people are not aware of the ability to extract the statement within a stored procedure being executed. So, prior to SQL 2000 SP3, when we want to know what code a SPID is executing we have to use DBCC INPUTBUFFER (). The... Read More...

by ACALVETT | with no comments

Filed under: SQL 2000, Tools, Tips