joechung said:
Dodo said:
*snip*
DB_ID(N'IntranetApps')
GO

SELECT * FROM sys.dm_db_index_physical_stats
(DB_ID(N'IntranetApps'), OBJECT_ID(N'...'), NULL, NULL, 'DETAILED')
GO

where ... is the name of an object in his database.

qwert231, check out example C in DB_ID (Transact SQL) [MSDN].

You can get SQL formatting like this: [ code language="SQL" ] code here [ /code ]
Just remove the extra spaces around the [].

EDIT: Ok, apparently that doesn't work. I know the code formatter they use supports SQL (since I wrote it Tongue Out ), but apparently C9 isn't exposing it.