Wow tripple simultenaous post.  Haven't seen that in a long while !

Or actually neither of us got this far by being fooled twice for the same thing .

So you're building some sort of reporting tool?

So do you still need help?

Can you add the e-mail of the server to a white list?

Select CONVERT(INT, YouColHere) FROM dbo.YourTable WHERE Whatever = @SomeParam

BTW Presenting the data in the correct format is often better left to the front end but there are a lot of...

Any trigger that could delete that data without throwing an error?

Is it possible that the report accessing that data uses a join on another table which doesn't contain any rows...

Just for kicks... I had to same solution than vasc posted (about 30 secs before me), and I was getting the right results.  So I see no point in you...

The profiler still exists in 2005.  Except if you only have express edition!

Maybe you can change the way you approach the problem.  What is the business requirement?

Good point... that's why I want to move to a bigger company ( meaning 100 GB db ).   You don't learn that stuff on a 300mb db

That's why I stayed away from the more obvious left join for all answers .

EXEC dbo.sp_dboption 'DbNameGoesHere', 'recursive triggers', 'OFF'

Ya that was the lazy solution.  Ultimatelly you could run it untill no row are affected, meaning the db should be empty (excluding circular reference of course).

But I don't have...

Check this out : http://www.sqlservercentral.com/columnists/mcurnutt/datadictionaryfromwithinsqlserver2000.asp