You can give your users rights to check if reports have run or jobs are complete without granting full admin rights. Here's how you can do so by using SQLAgentReaderRole in SQL Server
2008-12-16
3,346 reads
Change owner of a maintenance plan so the SQL Agent jobs have the correct owner for running.
2008-12-12
3,139 reads
Instead of granting higher level permissions, is there a way to allow users that only have public access the ability to see object definitions?
2008-10-13
3,693 reads
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,618 reads
2008-06-08
1,825 reads
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,885 reads
If you want to display variable number of columns in the report I suggest you use a matrix element.To utilise it for this you need to flatten the result of your query. The query can be changed into something like this: select{ [Utility Dimension].[Value].[Current] } on columns,{ CrossJoin( {[TimeByMinute].[All TimeByMinute].[2005].[May].[1] : [TimeByMinute].[All TimeByMinute].[2005].[May].[6]}, {A_list_of_measures }) } on Rowsfrom ACD_Calls This […]
2005-05-24
That really hits home for me too. I agree with Del (above). I have a short list of developers that I actually consider savvy enough to build solid code and an immense list of developers that I [know] from experience code horribly. The "good" coders are the ones that take pride in their work. It's […]
2005-05-23
Use QA as mentioned in this post, it will tell you what's running inside SQL. To set a cap on memory you should probably go through Enterprise Manager, into properties, memory and set the max value.
2005-05-04
2005-04-29
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers