Post reply

Dynamically script Create Database For Attach For All Databases

  • May 16, 2009 at 4:55 pm

    #209781

    Comments posted to this topic are about the item Dynamically script Create Database For Attach For All Databases

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • June 1, 2009 at 11:43 pm

    #1003180

    Will this script work for databases using the FILESTREAM feature in SQL Server 2008?

  • June 2, 2009 at 8:22 pm

    #1003732

    I did not include that in this design but could look into that as well.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • June 3, 2009 at 12:38 am

    #1003787

    Thx!

  • July 31, 2009 at 3:16 pm

    #1033178

    Sweet code.

    On the

    SELECT @a = (SELECT SUBSTRING(@a,1,LEN(@a)- 1))

    --Trim off the final comma; I'm sure there is a better way to do this...

    Why not just do a

    SELECT @a = LEFT(@a,LEN(@a)- 1)



    ----------------
    Jim P.

    A little bit of this and a little byte of that can cause bloatware.

  • July 31, 2009 at 3:21 pm

    #1033181

    A lot of the code is sourced from another script posted by another user on the site. I reference the original script when I posted my version so that proper credit could be given. That particular section of code came with the original script. I will look at adding that in my version though. Thanks for the suggestion!

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • May 19, 2016 at 7:02 am

    #1880208

    Thanks for the script.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy