Move database files to another Drive

• Jefferson Elias

  Ten Centuries

  Points: 1379

  More actions

  June 9, 2015 at 11:57 am

  #398564

  Comments posted to this topic are about the item Move database files to another Drive

• chrissans777

  Grasshopper

  Points: 22

  More actions

  June 22, 2015 at 11:10 am

  #1807112

  SSMS crashes during this script any ideas what might cause this?

  Running SQL Server 2014 Express and all it says is that SSMS has stopped working and needs to close.

  Thanks,

  Chris

• Jefferson Elias

  Ten Centuries

  Points: 1379

  More actions

  June 23, 2015 at 12:09 am

  #1807247

  Yep, as I expected when I read your post.. I forgot a FETCH in the first loop ...

  An infinite loop is never good except when it's what you want...

  Here is the modified version ...

• chrissans777

  Grasshopper

  Points: 22

  More actions

  June 23, 2015 at 5:09 am

  #1807295

  Works prefect!

  Thanks,

  Chris

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  July 1, 2015 at 6:22 am

  #1809445

  I'll have to give this a try. We move databases around all the time. Thanks.