By David Wiseman (Administrator)Created 25 Mar 2012
My Rating:
Vote
Rating:
Not Rated
Views:5933
Downloads:13
Source:

Script Databases for Attach

Language:  T-SQL

Compatibility

SQL Server 7 No SQL Server 2000 No
SQL Server 2005 Yes SQL Server 2008 Yes
Description

This script can be used to generate a T-SQL script to attach all the databases on your server. Run this script before detaching your databases.

Code

Line Numbers: On  Off      Plain Text
/* 
	Created By:		David Wiseman
	Website:		http://www.wisesoft.co.uk
	Description:
	Script databases for attach.  Run this script before detaching your databases to generate an attach script for each database.
	Also checks db ownership chaining, trustworthy and broker enabled settings which are normally lost as part of the detach/attach process.
	Run in SSMS and output results to text.
*/
SET NOCOUNT ON;
DECLARE @Database SYSNAME;
DECLARE @IsTrustworthy BIT;
DECLARE @IsBrokerEnabled BIT;
DECLARE @IsDBChaining BIT;
DECLARE @SQL NVARCHAR(MAX);
-- Cursor to loop over each DB
DECLARE cDatabases CURSOR FAST_FORWARD
	FOR SELECT name,is_trustworthy_on,is_broker_enabled,is_db_chaining_on
	FROM sys.databases 
	WHERE name NOT IN('master','msdb','tempdb','model')
	AND state=0; -- ONLINE
	
OPEN cDatabases;
WHILE 1=1
BEGIN;
	FETCH NEXT FROM cDatabases INTO @Database,@IsTrustworthy,@IsBrokerEnabled,@IsDBChaining;
	IF @@FETCH_STATUS <> 0
		BREAK;
	-- Generate script to attach database.
	SET @SQL = 'USE ' + QUOTENAME(@Database) + '
	SELECT ''CREATE DATABASE '' + QUOTENAME(DB_NAME()) + '' ON'' +
	STUFF((SELECT '',
	(FILENAME = '' + QUOTENAME(physical_name,'''''''') + '')''
	FROM sys.database_files
	FOR XML PATH(''''),TYPE).value(''.'',''NVARCHAR(MAX)''),1,1,'''') + ''
	FOR ATTACH
GO''';
	
	exec sp_executesql @SQL;
	
	-- Ensure trustworthy, db chaining and broker enabled options are maintained after the attach.
	IF @IsTrustworthy=1
	BEGIN;
		SELECT 'ALTER DATABASE ' + QUOTENAME(@Database) + ' SET TRUSTWORTHY ON
GO';
	END;
	IF @IsBrokerEnabled=1
	BEGIN;
		SELECT 'ALTER DATABASE ' + QUOTENAME(@Database) + ' SET ENABLE_BROKER
GO';
	END;
	IF @IsDBChaining=1
	BEGIN;
		SELECT 'ALTER DATABASE ' + QUOTENAME(@Database) ' SET DB_CHAINING ON
GO';
	END;
END;
	
CLOSE cDatabases;
DEALLOCATE cDatabases;

 


Got a useful script? Click here to upload!


 

  Post Comment
Order By:  
User Comments
      
HYst
Posted On: 9/12/2017 7:47:43 PM

You've got lunch and then study-hall, right? That's two hours. Plentyof time to run down this clue and Ugg Pas Cher Femme get back before asics sko anyone misses us. chaussures nike pas cher I'llget the whole team out. Harajuku Fun Madness is the best Cheap True Religion Jeans game ever made. I know I alreadysaid that, but it bears repeating. It's an ARG, an Alternate Nike Shoes Sale Store Reality Game,and the story Cheap Michael Kors Handbags goes that Yeezy Boost Sale Online a gang of Japanese fashion-teens discovered a mi-raculous healing gem at the temple in Cheap True Religion Jeans Harajuku, which is Christian Louboutin Shoes Outlet basicallywhere cool Japanese teenagers invented every major subculture for Nike Air Jordan 11 thepast ten years. They're being Timberland Outlet hunted by evil monks, the Yakuza Cheap Nike Air Huarache (AKAthe Japanese mafia), aliens, tax-inspectors, parents, and a rogue Uggs For Cheap artificialintelligence. They Billige Nike Sko slip Air Jordan Retro Sale the players coded messages that we have to de-code and use Moncler Jackets Discount Marketplace to track down clues nike air jordan pas cher that lead Adidas Yeezy Cheap to more coded messages andmore Hyperdunk 2014 clues. Imagine Nike Kyrie the best Michael Kors Handbags Discount afternoon you've ever spent prowling the Nike Air 90 streets Coach Bags On Sale of acity, checking out all the Nike Air Max Cheap weird people, funny hand-bills, street-maniacs,and funky shops. Now Cheap Michael Kors Tote Bag add Air Max Sneakers a scavenger hunt to that, It was hard to UGGS Outlet stay cool on the bus. We new yeezy shoes were all a little drunk, andlooking Cheap Toms Shoes Outlet at our faces under the bright bus lights was kind Mens Nike Air Max of hilarious. Wegot pretty loud and the driver used his intercom to tell us to günstige nike schuhe keep pandora outlet store itdown twice, then told us to shut up right now or Coach Outlet Store Online he'd call the cops. That set us Canada Goose Online Store to giggling again and we Nike Air Shoes disembarked Nike Huarache Womens Cheap in a mass before hedid Cheap Nike Huarache call the cops. We were in North Pandora Store Sale Beach now, and there were Nike Air Damen lots ofbuses, taxis, the BART at Market Street, neon-lit clubs coach factory outlet online and cafes The official UGG to pullapart our Stone Island Outlet grouping, so we drifted away. I got home and fired up my Xbox and started typing ugg factory outlet in keys from myphone's screen. It Adidas Superstar Sale Online was dull, Nike Air Max Goedkoop hypnotic work. I was a little drunk, and itlulled me Adidas Neo Discount Sale into a half-sleep.Don't you even read Xnet? It's all over Scarpe Air Max the place. You ever hear of theSpeedwhores? I nearly TOMS For Sale choked. That was Jordan Store Trudy Ugg boots Sale Doo's band — as in Trudy Doo, thewoman who Yeezy Shoes Discount Marketplace had TOMS OUTLET paid me and Jolu to update the indienet code. > Yeah I've heard of them> They're putting on a nfl store huge Uggs Pas Cher Soldes show Chaussure Nike Air Max Pas Cher and they've got nike sneakers like fifty bands signedto play Bottes Ugg Femme Pas Cher the bill, Abercrombie and fitch store going to set Nike Roshe Run Sale up on the tennis courts and bring out theirown amp trucks and Chaussure Nike Pas Cher rock out Jordan Shoes Air all nightI felt Nike Pas Cher Femme like I'd been living Soccer Boots Outlet nike under a rock. How had I missed that? Therewas an anarchist bookstore on Valencia that Ray Ban Sunglasses Online I sometimes passed on theway to school that Doudoune Moncler Femme Pas Cher had a poster of an old revolutionary named EmmaGoldman adidas store with the caption "If canada goose jacket outlet I can't dance, I don't want new jordan releases to be UGG BOOTS FOR WOMEN a part ofyour revolution." I'd been new pandora charms spending all Nike Shox Cheap my energies Moncler Outlet on Air max dam figuring Jordan Shoes For Cheap out howto use the Kobe Shoes Nike Xnet to Nike Factory Outlet organize dedicated fighters so they could jam newest lebron shoes the Pandora Outlet DHS,but this was Michael Kors Outlet so nike schuhe günstig much cooler. A moncler jacket sale big concert — I Discount Air Max had no idea how to doone of those, but I was Yeezy Men glad someone zapatos de futbol nike did. And cheap uggs now that I thought Descuentos Nike of it, I was damned Nike Shoes Online proud Michael Kors Clearance that they were us-ing Nike Soccer Cleats Boots the Xnet to do Nike Free Run 5.0 Womens it. The North Face Outlet next day I was a Adidas Soccer Cleats Cheap zombie. Ange and I had chatted Nike Factory Store — flirted — until4AM. Lucky for Ugg Outlet Online Store me, toms shoes outlet it was a Saturday and I was able to Canada Goose Outlet sleep in, Negozi Pandora but147between the hangover and Official NHL Jerseys the Moncler Sale sleep-dep, I could barely put Cheap Michael Kors twothoughts together. By lunchtime, I managed to get up Nike Store and get my ass out onto the streets. I staggered Official Toms Shoes Outlet down toward the Turk's prada outlet to pandora jewelry store buy my coffee — these days, if Iwas alone, Original Ugg Boots I always Discount TOMS bought my coffee there, like Boost Yeezy Sale On Line the Chaussure Air Max Turk Cheap Louboutin Heels and I were partof Louboutin Wedding Shoes a secret club. On the way, I passed a lot of fresh graffiti. I liked Mission graffiti; a lotof the times, it came scarpe nike in huge, luscious murals, or sarcastic art-studentstencils. I liked that the Mission's taggers kept Nike Air Huarache For Sale right on going, under thenose of the DHS. Cheap Toms Outlet Store Another chaussure basket homme kind Nike Roshe Run of Xnet, I supposed Air Max Kopen — they must converse store have allkinds of ways of knowing what was going on, where to get paint, Adidas Superstar whatcameras Pandora Official Website worked. Some Air Max Femme of the cameras had nike shoes been spray-painted over, Inoticed. Maybe they Canada Goose Outlet used Xnet! Painted in ten-foot-high letters on the Jordan Sneakers For Sale side of an auto-yard's Canada Goose Womens Coats fence Moncler Outlet Online werethe drippy words: DON'T TRUST ANYONE Canada goose dam OVER 25. I Ugg Pas Cher En France stopped. Adidas Originals Stan Smith Had botas de futbol someone left my "party" last night and come here witha can of paint? Zapatillas Air Max A lot of Nike Shox discount Sale those fitflops sale uk people lived in the Air Max 90 neighborhood. I got my ?????? ????? coffee Boutique Ugg and had a nike tn pas cher little Zapatillas Nike Air Max Baratas wander around town. Air max levne I kept longchamp bags on sale thinking Ishould be calling someone, seeing if they Toms Outlet Online wanted to get a ugg clearance movie Hugo Boss Sale orsomething. That's how it used Air Max Pas Cher to be Christian Louboutin Heels on a lazy Saturday like this. But whowas I going to call? Pandora Store Van Nike Air Pas Cher wasn't talking to Nike Outlet Store me, Discount Christian Louboutin Shoes I didn't think I was Nike Outlet readyto talk to Jolu, Nike Air Women and Darryl —Well, I nike mercurial soccer cleats couldn't Pandora Style Beads call Darryl. I got my coffee and went cheap uggs for women home and did a little searching Discount Ray Ban Sunglasses around onthe Xnet's blogs. These anonablogs christian louboutin outlet were untraceable Nike Tn Requin Pas Cher to Adidas Yeezy Boost 350 For Sale any author —unless that author Vans Black Sneakers was stupid enough to put her name on it — nike sb stefan janoski and therewere a lot of them. Adidas Shoes Discount Marketplace Most of them Michael Kors were apolitical, but a lot cheap nike air max of themweren't. Nike Air Sneakers They talked about schools and Adidas Originals Superstar the unfairness New Air Max 2017 there. They talkedabout the cops. TOMS STORE Tagging. Turned Scarpe Nike Scontate out there'd been New Nike Shoes plans zapatillas nike baratas for the Air Nike concert Cheap Air Max in the Doudoune Moncler Site Officiel park for weeks. Cheap Real Jordans Ithad hopped from blog to blog, turning into a full-blown Adidas NMD For Sale movementwithout my noticing. And the concert was called ugg store Don't Trust AnyoneOver 25. Well, that explained where adidas outlet Ange pandora beads got it. It was a good slogan. 148Monday morning, I Cheap Nike Free Run decided Moncler Outlet Store I wanted to check out that anarchist book-store again, see vans shoe store about getting one of those Emma Goldman canada goose jackets on sale posters. suivre un envoi Ineeded Nike Shoes Discount Marketplace the reminder. I detoured Doudoune Moncler Pas Cher down to ????? ????? 16th and Mission on my way to school, then up toValencia and across. The store was shut, Nike Online Store but I Nike joggesko got the hours off the doorand made sure they still had Reebok Outlet Store that poster up.As I walked air force one pas cher down Valencia, I was amazed to see how much of theDON'T TRUST ANYONE OVER 25 stuff Nike Air Max Sale there was. Half the shops hadDON'T Cheap Retro Jordans For Sale TRUST merch in the Adidas Originals Sale windows: lunchboxes, babydoll TOMS SHOES OUTLET tees, pencil-boxes, trucker hats. The hipster stores have womens nike air max been getting 23 IS BACK Store faster ADIDAS NMD SALE ON LINE and faster,of Cheap Air Max Trainers course. As new louboutin heels memes sweep the net in the course Hogan Outlet of a day or two,stores have gotten better at putting merch in the windows to match. Some funny little youtube of a guy launching himself with jet-packsmade of carbonated water would land in your inbox on Monday Nike Polo Sale and byTuesday you'd be able to buy t-shirts with stills from the nike air video Boty Nike Air on it. But it was reebok running shoes amazing to see something make Yeezy Black the chaussure adidas pas cher leap huarache sneakers from retro jordans for cheap Xnet to thehead shops. Distressed nike sportschuhe designer jeans nike jordan shoes with the Toms Factory Outlet slogan written in carefulhigh school ball-point ink. Embroidered patches. Good Pandora Store news travels fast.


Posted On: 12/21/2017 10:10:21 PM



Posted On: 12/26/2017 11:01:14 PM

201712.27wengdongdong ugg outlet moncler michael kors outlet pandora jewelry moncler jassen moncler coach handbags tory burch outlet michael kors outlet ralph lauren outlet supreme adidas stan smith manolo blahnik nike air max ugg boots true religion outlet adidas outlet doudoune moncler moncler coach bags canada goose ugg boots hermes belt nba jerseys ralph lauren outlet north face ray ban sunglasses ray ban sunglasses cheap nhl jerseys ray ban sunglasses ugg boots jordans supreme clothing hollister outlet air jordan pas cher polo ralph north face pandora jewelry fitflops longchamp mont blanc pens blackhawks jersey rolex watches ray ban sunglasses ralph lauren outlet flip or flop ugg boots mlb jerseys ugg australia ralph lauren prada hermes outlet moncler moncler true religion jeans ugg boots michael kors outlet ugg australia coach outlet online ralph lauren tory burch michael kors polo ralph cheap ray ban sunglasses michael kors pandora uk ray ban sunglasses red bottom shoes kate spade outlet kate spade outlet ugg boots on sale polo ralph lauren ugg uk moncler moncler ralph lauren outlet north face supra shoes basketball shoes oakley sunglasses air max birkenstock sandals ray ban sunglasses cheap ugg boots moncler jacka cheap oakley sunglasses jordan retro nike huarache burberry scarf ugg boots kate spade outlet longchamp outlet canada goose jackets polo ralph kate spade handbags north face jackets michael kors handbags north face oakley sunglasses cheap ugg louboutin ralph lauren cheap uggs michael kors outlet louboutin beats by dre longchamp outlet flip flops air jordans ray ban sunglasses ray ban air jordans ugg outlet baseball jerseys canada goose canada goose ferragamo hermes birkin handbags canada goose outlet ugg slippers ralph lauren uk timberland the north face coach outlet adidas stan smith ugg boots michael kors handbags oakley sunglasses nike air max christian louboutin ugg outlet coach outlet timberland outlet ugg boots true religion outlet burberry outlet north face ferragamo coach factory outlet polo ralph lauren coach outlet ugg outlet canada goose coach outlet store online nike outlet ugg outlet new balance shoes canada goose jordan shoes coach outlet ray ban sunglasses fitflops ugg boots adidas football boots coach outlet coach outlet store michael kors outlet jordan shoes ugg boots clearance pandora jewelry michael kors tory burch outlet ralph lauren michael kors handbags moncler jackets ugg outlet canada goose outlet calvin klein outlet jordans burberry handbags north face jordans converse outlet jordan the north face nike air max ray ban sunglasses swarovski jewelry oakley sunglasses ugg outlet true religion jeans juicy couture outlet tommy hilfiger canada coach outlet ugg boots on sale canada goose outlet nike huarache bottes ugg coach factory outlet moncler ugg boots kate spade outlet moncler jackets burberry scarf supreme new york cheap nfl jerseys coach factory outlet coach outlet true religion canada goose ugg outlet ugg outlet oakley sunglasses ugg boots pandora charms michael kors outlet cheap ugg boots the north face timberland nike free run ugg outlet store canada goose outlet uggs outlet ugg outlet michael kors sac longchamp timberland mont blanc pens michael kors outlet under armour outlet christian louboutin coach outlet canada goose uk north face outlet snapbacks hats wholesale north face air max canada goose uk ray bans michael kors outlet ugg boots clearance coach outlet ugg outlet canada goose outlet adidas shoes nike air max red bottom shoes canada goose outlet north face north face outlet north face outlet nike football boots tory burch outlet uggs outlet moncler outlet coach outlet online replica watches ralph lauren longchamp canada goose nfl jerseys ugg outlet oakley sunglasses christian louboutin oakley sunglasses ugg boots canada goose nike air force 1 ralph lauren outlet coach outlet online ugg australia prada outlet polo ralph lauren salvatore ferragamo hermes pandora charms ugg boots nike air oakley sunglasses vibram fivefingers christian louboutin north face outlet nike air max ugg nfl jerseys canada goose outlet michael kors michael kors handbags burberry outlet ralph lauren outlet canada goose outlet nike store nike shoes uggs outlet canada goose ugg outlet mbt jordans air jordan superdry clothing louboutin uggs outlet ugg factory outlet ralph lauren nike air max adidas yeezy boost uggs michael kors outlet mlb jerseys coach outlet michael kors outlet ralph lauren outlet oakley sunglasses michael kors birkenstock sandals birkenstock outlet nfl jerseys ray ban sunglasses ugg boots on sale cheap nfl jerseys ugg outlet ugg clearance moncler pandora charms coach wallets ugg boots jordan shoes jordans uggs louboutin coach outlet online mulberry uggs outlet louboutin jordans soccer jerseys ugg nike outlet coach outlet hollister clothing ugg outlet nike factory outlet hogan adidas shoes ugg boots north face fitflops giuseppe zanotti michaelkors outlet moncler coach outlet the north face ugg boots adidas jeremy scott canada goose jassen timberland boots canada goose prada nike trainers canada goose jackets michael kors outlet cheap jerseys kate spade burberry scarves coach outlet ugg boots christian louboutin michael jordan shoes jordan shoes mbt pandora jewelry ralph lauren outlet goedkope uggs canada goose adidas cheap jordans michael kors outlet ugg australia pandora charms louboutin michael kors ugg boots christian louboutin coach outlet online longchamp pandora rings coach outlet ralph lauren ugg boots ugg boots canada goose outlet nhl jerseys mlb jerseys true religion burberry outlet nike outlet nike outlet mont blanc fitflops coach outlet adidas wings nike tn prada outlet oakley sunglasses north face jackets clearance nike blazer shoes coach outlet online north face uk adidas 201712.27wengdongdong


Posted On: 3/30/2018 5:29:51 AM

2018331 leilei3915 fitflops sandals canada goose jackets polo ralph lauren ralph lauren coach outlet fred perry polo shirts ralph lauren shirts cheap mlb jerseys ugg outlet coach outlet online uggs outlet coach outlet air jordan 4 nike outlet pandora outlet uggs outlet tory burch outlet uggs outlet adidas nmd michael kors outlet clearance uggs outlet canada goose uk michael kors handbags coach factory outlet canada goose outlet michael kors handbags cheap oakley sunglasses pandora outlet fred perry clothing ed hardy clothing pandora bracelet mbt shoes nike air jordan 4 oakley sunglasses wholesale coach outlet online christian louboutin shoes kate spade pandora charms canada goose ray ban sunglasses outlet kate spade outlet store nmd adidas coach outlet pandora pandora jewelry outlet canada goose ugg boots true religion jeans nike outlet online longchamp michael kors handbags sale canada goose outlet online canada goose outlet store tory burch outlet pandora charms sale clearance ugg boots kate spade outlet ralph lauren outlet michael kors uk supreme t shirts kate spade outlet polo ralph lauren jordan retro shoes canada goose canada goose uggs outlet canada goose canada goose outlet nike outlet michael kors outlet online pandora charms sale clearance oakley sunglasses wholesale canada goose michael kors outlet mlb jerseys wholesale true religion outlet canada goose jackets true religion jeans pandora outlet ralph lauren shirts canada goose jackets kate spade outlet oakley sunglasses cheap nba jersey christian louboutin outlet ugg boots coach outlet store online coach outlet cheap jordans for sale canada goose outlet canada goose jackets polo ralph lauren outlet michael kors handbags clearance adidas yeezy shoes polo ralph lauren outlet online jordan retro coach outlet online pandora charms kate spade outlet pandora