Dynamically script Create Database For Attach For All Databases

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by DavidB » Dynamically script Create Database For Attach...

Dynamically script Create Database For Attach For All Databases

Rate Topic

Display Mode

Topic Options

Author

Message

David Benoit

Posted Saturday, May 16, 2009 4:55 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:56 AM
Points: 2,063, Visits: 3,441

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

David

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

Post #718567

Mohamed.Koker

Posted Monday, June 01, 2009 11:43 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:54 PM
Points: 3, Visits: 37

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

Post #727157

David Benoit

Posted Tuesday, June 02, 2009 8:22 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:56 AM
Points: 2,063, Visits: 3,441

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

David

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

Post #727834

Mohamed.Koker

Posted Wednesday, June 03, 2009 12:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:54 PM
Points: 3, Visits: 37

Thx!

Post #727908

Jim P.

Posted Friday, July 31, 2009 3:16 PM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 4:57 PM
Points: 440, Visits: 481

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.

Post #763407

David Benoit

Posted Friday, July 31, 2009 3:21 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:56 AM
Points: 2,063, Visits: 3,441

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
SQL Tentmaker
“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Post #763410

« Prev Topic | Next Topic »

Permissions