tsql command to check the default filegroup

• invaliddba

  Default port

  Points: 1450

  More actions

  May 13, 2011 at 10:15 pm

  #239533

  Hello

  What is the tsql command to see the default filegroup on a database?

  Thanks

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 14, 2011 at 12:09 pm

  #1324641

  Check out the following example:

  http://sqlserverpedia.com/blog/sql-server-bloggers/is-primary-your-default-filegroup/

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/