Operating System Error 5 while Attaching/Creating Database
Category: SQL 2008
Actual value was -1. (Microsoft.SqlServer.GridControl) Error when attaching database.
When attaching a database in SQL Server 2008, a user might get the following error. TITLE: Microsoft SQL Server Management Studio —————————— Cannot show requested
Get listing of Databases user has access to …
You can right click on each user to find out what database he or she has access to; which can be very time consuming. I
Surface Area Configuration Manager *R.I.P.*
All who liked the SACM raise your hands … Right that’s what I thought no one heh; okay it wasn’t that bad. But non the
"New Maintenance Plan…" doesn’t work
For some reason Microsoft decided not to enable that function in some editions of RTM in SQL server 2008 (annoying but meh). So looking around
Default Backup Path in SQL 2008
In the SQL Server 2008 setup you can now set the default backup location but in case you set it wrong or need to change
SQL Canada (SQLCAN) 