Edogg (10/8/2008)
You could also grant VIEW DEFINITION to the dbo schema or any other schemas in the database.USE [DATABASENAME]
GO
GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO
GO
ahaa!!
Dont know why I didnt think of this, makes it much much simpler.
I will try to recreate this script using Schema's.
thanks
shiva
Kindest Regards,
Shivaram Challa
(http://challa.net - Home of the "Excel to CSV converter & Browsepad applications".)
Forum Etiquette: How to post data/code on a forum to get the best help[/url]