My junk drawer has a slew of plastic shopping bags that I tossed in there after bringing something to the office. Why do I keep those?

But the biggest item...

My favored spot is the first space to the right of two handicap spaces. This gives me a straight line up the walkway to the office doors. I've...

Great article. However the title is misspelled.

The work is conversion with an 's' not a 't'.

I like the title of this challenge, "TSQL Challenge 43 – Identifying incomplete segments and missing elemen". Leaving off the "ts", whether intentional or not, is humorous.

We just installed SQLSentry and are happy with it. Actually installed the 30 day eval and immediately identified processes that were causing frequent blocking. After correcting these our...

In the Name of NULL (U2)

Anyone for creating a SQL DBAs Station on pandora.com?

-Andrew

Thank you. I figured as much, but nice to get confirmation from a group. It is unfortunate that we are stuck with the 6.5 compatibility because of a...

1. Excuse me for not noticing 2 pages; the second page pointing out the quotes.

2. My post is still valid for those who may need the older syntax of sysobjects/syscolumns...

For backward compatibility this works. You declared the column name so you do not need to put it in quotes in the Where.

CREATE PROC spWhichTable( @ColumnName varchar(50) )

AS

SELECT o.name...