SQL – Grant execute to all stored procedures
If you want to grant some users the execute rights on all stored procedures under a database in SQL. Use the script below. Now map…
If you want to grant some users the execute rights on all stored procedures under a database in SQL. Use the script below. Now map…
I’ve come across a lot of sites where VMware has been deployed using a SQL Express Database. This is normally fine for a handful of…
There might be occasions when trying to connect to a SQL 2008 R2 Instance with SQLCMD that you might receive the error :- Named Pipes…
In order to start SQL 2008 R2 Express in Single User Mode you need to carry out the following steps. 1) Find out your SQL…
When trying to do a backup of a SQL Database in SQL Server Management Studio you might get the error :- Backup failed for Server…
There are loads of situations where you need to use a SQL database for something. In some cases a SQL Express database will do the…
Had an issue this morning where the Backup Exec 2010 services wouldn’t start on a 2008 SBS server. The Backup Exec Job engine service would…
When trying to add a new user to a Business Contact Manager Database you might receive the following message once you have selected the database….