This will not work on SQL Server 2000 since the sp_refreshsqlmodule does not exists on that version!

A while back in the What is deferred name resolution and why do you need to care? blogpost I showed you that sp_depens is not reliable because you can create procedures that reference objects that have not been created yet.

You can use sp_refreshsqlmodule to help 'fix' that

let's take a look at how that works

First create this awesome stored procedur...

If you want to show a 1 when there is a value for something in the column and 0 if none of the rows have that values you typically do something like this

If you have a bunch of User-Defined Data Types in your databases and you would like to get a list of them then you can run the following query

On SQL Server 2000 and up

So I posted a teaser in the puzzles forum. Without running this, try to guess what will happen?

I see more and more people asking how to check if a temporary table exists. How do you check if a temp table exists?

You can use IF OBJECT_ID('tempdb..#temp') IS NOT NULL Let's see how it works