Here’s a SQL Server Tip

How many times have you asked this question when you run a query. How do I copy the query result with the column names into Microsoft Excel? In the SQL Server Management Studio, in the Tools menu, select Tools > Options > SQL Server > Results to Grid Then check the Include column headers when [...]

SQL xp_findnextmsg and xp_readmail

If you use SQL mail, you can read the messages in the SQL inbox stack and do stuff with them. Recently I had to use SQL scripting to find messages in the SQL inbox, read the message, determine if it is a text or html email, then add the message to a table in the [...]

Database Mail vs SQL Mail in SQL Server 2005

SQL Mail was what one would use to send emails from SQL Server in the SQL Server 2000 version. But in SQL Server 2005, SQL Mail is considered legacy. Microsoft introduced a better email component called Database Mail for SQL Server 2005. In SQL Mail, you can run the xp_sendmail stored procedure to send an [...]