I've recently got a new PC with Windows7 and SSMS 2008. I cannot hear the beep from within SSMS. However, when I go into control panel I can...

When I try to execute

select object_name(object_id),

 index_id,

 index_type_desc,

 avg_fragmentation_in_pct

from sys.dm_db_index_physical_stats(db_id(),null,null,null,'limited')

on my server, I get the following error:

Server: Msg 102, Level 15, State 1, Line 5

Incorrect syntax near '('.

Anybody else having this problem? ...