retrieve a random record from a sql server table

SELECT TOP 1 * FROM table ORDER BY NEWID()

SELECT  * FROM table ORDER BY NEWID()

A NEWID() is generated for each row and the table is then sorted by it. The first record is returned (i.e. the record with the "lowest" GUID).