The Thread is showing signs of life...

If Paul's Script does not work for you, please post sample data and table structures so we can better match the problem with an answer.

jcrawf02 (1/12/2010)

---

I know it's something others have said, I just think this is particularly well said, and wanted to share:

http://prodlife.wordpress.com/2009/10/13/most-important-thing-ive-learned-at-oow09/#comments

This is a huge part of what I have learned from...

Lynn Pettis (1/12/2010)

---

Lynn Pettis (1/9/2010)

---

bitbucket-25253 (1/9/2010)

---

Take a look at this one

http://www.sqlservercentral.com/Forums/Topic844889-392-1.aspx

It is one of the worst I have seen on SSC in a long long time.

Lynn - I must compliment...

This may be suitable for your needs.

Select 'Select count(*) From ' + table_name + ' where [' + column_name + '] is null;' from information_schema.columns

Select 'Select count(*) From '...

What is your criteria for determining if a column is used or not within a table? If it is null?

Doh - posted this in the wrong thread

Some lite reading:

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/02/some-vldb-availability-tidbits.aspx

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

Some lite reading:

http://sqlblog.com/blogs/linchi_shea/archive/2007/01/02/some-vldb-availability-tidbits.aspx

http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx

This might be of assistance.

http://www.mssqltips.com/tip.asp?tip=1172

Try this one

http://vyaskn.tripod.com/scripting_permissions_in_sql_server_2005.htm

The most obstinate of my children is my daughter. 11 months old is all. But that is fine.:-)

Yum - now I need to find Chipotle...

Nice script and thanks for the reference Noel.

Out of curiosity, now that you are able to remove the public role permissions. Do you have a plan in place or substitute role in place should issues arise...

I agree...