What is My SQL Server Collation Set To?

To find out what the collation settings are in an instance of SQL Server, open a New Query window and execute the following command:

SELECT CONVERT (varchar, SERVERPROPERTY('collation'));


It will return the collation setting, for example:  SQL_Latin1_General_CP1_CI_AS

What DC is my Logon Server?

To find out which Domain Controller your server/workstation is authenticating against, open up a command prompt (Start --> Run --> cmd --> Enter) and copy/paste the following:

echo %logonserver%


This will return the DC that has authenticated your login.

Printing a Selection of a Page in Adobe Acrobat

If you've ever wondered how to print a portion of a single page in a PDF document in Acrobat, here is what you need to do:

1. Open the document, and go to the page you would like to print.
2. In Acrobat X/Reader X, Choose Edit > Take A Snapshot.
   In Acrobat 9/Reader 9,  Choose Tools > Select & Zoom > Snapshot Tool.
3. Drag a rectangle around the area you want to print.  It will highlight the selection that will be printed
4. Go to File --> Print
5. Make any changes to the way it will print as you usually would (Fit to Page, Custom Scaling, etc.)
6. Click the Print button!

This works in both Reader and Acrobat.

Changing Host Name of Server w/ SQL Installed

If you need to change the host name of a Windows Server with SQL Server already installed on it, there are two Stored Procedures that need to be run on SQL Server to change the server name within SQL.

After renaming the host and rebooting run the following two procedures with the appropriate host names and the restart SQL.

sp_dropserver OldServerName
go
sp_addserver NewServerName, local
go