No suggestions? Tried looking into creating my own and although doesn't look impossible just would hate to kick myself for spending hours on something that's already been done and relatively...

OK took a stab at making it SQL2K compatible and added Meta Data Description as an extra column. Not perfect but so far it seems like it works on...

Just found this article and am thrilled because I am working on a new contract with a crazy DB system. This is immensely valuable except I need it for...

Thanks, will give it a try.

I have use the tool recommended from Johnny Cant but I'm getting an error when I try to open the connection in VS2008.

The selected database was created with an earlier...

Excellent trick! I like it! WIll give it a whirl and see how it works for me. Will report back.

thanks!

Here's my Proc. I don't think it's necessary to have an if statement with two identical sets of SQL differing only on sort direction.

/***=================================================================================================

TEST UNIT

*****************************************************************************************************

=====================================================================================================

exec get_lcm_laneclosure_Filter @closure_type_id = 2

exec...

I use COalesce extensively to handle the possibility of many params when doing searches and things like that.

I don't prefess to be a SQL guru but I have found...

I see your point, but I don't think that's right either.

This seems to be working for me and covers all points. Thanks for the highlight.

Declare @Resultbit;

Set @Result...

Found the issue, it had nothing to do with SQL but SQL was the trigger that started the domino effect. It was a setting in Documentum Eroom (Portal similar to...