Useful Setting in SQL Server Management Studio

If, like many DBA’s and developers, you are often called upon to run ad-hoc queries, and then save the results to Excel, here is a handy setting you might want to turn on in SSMS. It is "Include column headers when copying or saving results", as shown below.

Once you turn this on, you can run a query, hit Cntrl-A, then Cntl-V the results into a blank Excel worksheet, and have the column headers come along for the ride.

 

Technorati Tag: SQL Server

This entry was posted in SQL Server 2005. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s