here is the exact error that i get when i execute sp_helptext as a db_datareader with execute rights on sp_helptext

Msg 15009, Level 16, State 1, Procedure sp_helptext, Line...

no, it is not encrypted.  And i am not granting to any particular proc.  I would like the deveoplers to have the ability to see any proc contents, without having...

My app is a little more recent, but still has a history.  After i got into development 12 + years ago, i discovered i wanted a little more control of...

I too love to spend time in my garage/wood shop.  I have accumulated a lot of woodworking tools and love to produce real world objects with my skills.  Much like...

bad development has occurred in the past.  They do not have access to production.  But i have inherited this application and database.  As is.  wooohooo. 

So, some of the ways...

the showcontig simply gets the results and i store them each day. 

I dont always defrag, based on the > 10% < 10% rule.  But with a deviation also.  So,...

I created some tables to store the dbcc showcontig information.  Then i made a job that runs each night, and stores all this information in that table. 

Then a while...

once it is configured, with defaults, is there a way to test it and see what, if anything, is failing?

I create a subscription, give it a time, sit and watch,...

i looked at books online about it, and google.  i cant really remember where i found info about it.  But it was fairly simple. 

here is a link.  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsuiref/htm/cpu_rsconfig_v1_5f1e.asp

when...

after a little more intense searching online, i was able to find some other people with a similar problem.  After a few failed attempts, i was able to find the...

thanks a ton.  I figured that was the case, but wanted to make sure i wasnt making stuff up.

This is for a sox audit, and i had to either prove...

why is that?

i am not an expert in excel.  do you dare share how you accomplished this?

a sample, example, etc?

thanks guys

I too would love to have this explained.  I am attempting to open up some reports to our organization, but with the proper security i place, so only those authorized...