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.

5. Restart sql server and the sql server agent by opening a command prompt and typing net stop mssqlserver and net start msssqlserver.

Microsoft has released SQL Server 2008 Feature Pack August 2008 the same day when SQL Server 2008 was released. Feature Pack is a collection of stand-alone packages, including Analysis Services ...

Open up new reporting options for your SQL Server with these PowerShell tips.