Archive for September, 2013

TSQL to Send Email From a SQL Server With Attachment

There are about a billion different technologies used to connect remotely to SQL Servers and some are better than others.  Some allow file transfer, some allow sharing clipboards and some don’t.  Of course, better depends entirely on your perspective.  In most cases those ‘inconvenient’ things are there for a reason – security.  nonetheless it’s a […]

Read More →

How to Gain Emergency Sysadmin rights to a SQL Server

Whether you are trying to find the purpose of a SQL Server you just became responsible for, or access has been accidentally dropped, or you need to administer a vendor installed SQL instance, or a host of other reasons, from time to time you will need to get emergency sysadmin access into a SQL Server. This post talks about your options for regaining access to that rogue server.

Read More →