Online sql formatter
I’m still curious as to why SSMS wasn’t bundled with some sort of SQL formatter.
Until they do, there’s quite a few paid and free options for adding formatting tools - for the moment, I’ll just make do with this one…
http://www.dpriver.com/pp/sqlformat.htm
Online SQL formatter and also has a nice feature of dumping the html you might need if your adding this to a blog.
Monday Nov 1st
SQL Sentry Plan Explorer Beta
A nifty query analysis tool for Sql Server.
http://greg.blogs.sqlsentry.net/2010/10/sql-sentry-plan-explorer-beta.html
Thursday Oct 21st
RESTORE cannot process database ” because it is in use by this session. It is recommended that the master database be used when performing this operation
If you get this, try restoring using the master (like it says).
use master
restore database DatabaseName FROM DISK = ‘c:\Path\To\My\Bak.bak’
Boosh.
Thursday Jul 29th
Sql Server Restore failed ‘The operating system returned the error (error not found)’ while attempting restore
Had this error today trying to restore an existing db from .bak. Looks like something to do with file / user permissions.
Seems the workaround is to run the service under ‘local system account’ (making this change will require a restart of the service).
- Go to services
- Find your sql service e.g. Sql Server (SQL EXPRESS)
- Right-click and select properties
- Select ‘Log on’ tab
- Under ‘Log on as’ make sure ‘Local System Account’ is selected.
- Restart Sql Server service
Wednesday Jul 28th
