Get the Names of Stored Procedures that Reference a Given Table in SQL Server

SQL Server logo

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

Moving Data from the IMAGE Datatype to VARBINARY(MAX) from a SQL Server 2000 Instance

SQL Server logo

I am in the process of writing scripts to move data from a SQL 2000 database into a different database running on SQL 2008. I had set up a linked server from the SQL 2k server to begin this process, and about 90% of the data could be moved.  One of the last tables to … Read more

Acceptance into Project Glass Pilot Program!

acceptance into Glass Explorers

I received a message today on Google+ indicating my acceptance into the Project Glass program!  Apparently 8000 people have been selected to be the first allowed to buy it.  Now I’m just waiting for the next message…