• In SSMS 2008 query results window, you can right-click and choose "Copy with headers"

    (Copy, Copy with Headers, Select All)

    if you didn't set the Option settings many mentioned above

    Copy with Headers

    FirstNameMiddleNameLastName

    285EAbbas

    293R.Abel

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005