Thanks Scott. I will give that a try. I also have a query that for remaining text columns will find the longest record. That could help cut down on the...

Thanks John. I will give that a try.

Andrew J

Thanks Jeff and Phil for your helpful advice. Unfortunately I don't have access to the system where this data originally came from and it would take awhile to find the...

So for us wannabes, what is the best way to learn these basic level T-SQL skills? Obviously a Google search on each one would return a number of resources. I...

Sorry. One more clarification. Does View Definition also allow users to see the columns details of a table if trying to connect from an external source like if they want...

OK. I think I understand. It is only a bad thing if there is some table, view or SP that I don't want people to see the design.

Fair enough. I understand the principal of granting the minimum privileges required. What is still not clear to me is what is the risk of granting this View Definitions access?...

Thanks John. I guess I can just grant View Definitions as the default. Are there any situations you can think of where you would not want to grant View Definitions...