• Like this:

    declare @idxname sysname;

    set @idxname = 'idx_DatePosted';

    I am finding that I am writing more code using SQL Server 2008 syntax and forget to change it for SQL Server 2005.