Post permalink

• Sven Groot Don't worry... I'm a doctor.
  Jan 02, 2009 at 5:59 AM

  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 ), but apparently C9 isn't exposing it.

See more posts in thread…