Select Into

• sudhakara

  SSCrazy Eights

  Points: 9425

  More actions

  May 2, 2010 at 3:08 am

  #221152

  Hi,

  when i craete table by using the select * into query can i specify the file group on it ?

  Ex: select * into newtable from newtable on filegroup new

  Thanks in advance.

• Adi Cohn-120898

  SSC-Dedicated

  Points: 33944

  More actions

  May 2, 2010 at 3:40 am

  #1160971

  As far as I know, you can’t define the file group and it will be created on the default file group.

  Adi

  --------------------------------------------------------------
  To know how to ask questions and increase the chances of getting asnwers:
  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/

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  May 3, 2010 at 10:59 am

  #1161398

  Already answered with workaround.

  http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=254140