Filegroups

• Frank Mirigliano

  Newbie

  Points: 3

  More actions

  April 27, 2004 at 7:23 am

  #85485

  Is it possible to have data files from one database in the same filegroup as another database?

   

  Also I am getting blocked processes on one production database that are being blocked by processes from another database. Any ideas?

   

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  April 27, 2004 at 7:46 am

  #504330

  1. Nope, datafiles are for use by a single database, why would you want to share the file?
  2. Check what is being run, you could have a cross database query that is causing the blocking. Run a DBCC INPUTBUFFER on the blocking and blocked spids to find out what is going on with the connections that could cause this.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net