hi i'm new to MS Sql 2012, 1. open MS Sql management studio 2. attach my db, say 1.mdf 3. modify it, save 4. detach 1.mdf it complains "still in use" if i close MSMS, and open it again, then i can detach it. why ?
n*s
6 楼
1. Southwest Airlines Premier Card --50,000 Bonus Points或价值$800机票 http://goo.gl/s28h8 Southwest Airlines推出新卡,只需消费一笔就送5万积分,可折合$800的机票奖励, 足够兑换2张国内往返机票。也可直接兑换500刀Amazon Gift card http://goo.gl/s28h8 2. SapphireSM Preferred Card –狂送$500现金或价值$625机票 限时大特惠,Chase提供超高开卡50K points bonus,可以直接兑换$500支票或价值$ 625机票,足以兑换两张美国国内往返,首年无年费。赶快申请,落袋为安! Earn 50,000 bonus points after you spend $3,000 in the first 3 months- that' s worth $625 toward airfare or hotel accommodations! http://goo.gl/jycFB 3. Chase Freedom Card - $200 Bonus Cash Back + 5% Cashback on GAS, Airline 开户送$200现金, 接下来这个季度7/1/11 - 9/30/11就是大家最喜欢的5% gas cashback(up to $1,500 spent on GAS, HOTEL and AIRLINE ),如果还没有这个卡片 的赶紧申请哦. http://goo.gl/29TB3 4. 信用分数知多少?750?免费查询,快速提升 creditreport提供免费查询信用分数,三大信用记录公司之一Experian的分数,记得在 free trial结束前取消。信用卡申请前先查询一下自己分数,提高申请通过率。 http://goo.gl/xRORF 5. Chase SapphireSM Card – 25000 Points 申请就送$250现金,买机票和旅馆住宿2%现金返回,无年费 http://goo.gl/hOF3Z 6. United Mileage Plus Card 30000miles offer+$50bonus只需要任意一笔消费 http://bankbonus.blog.163.com/ 7. Chase continental onepass 30000miles offer+$50bonus 只需要任意一笔消费 http://bankbonus.blog.163.com/ 8. Gift Card购买好去处!Plastic Jungle折扣购物卡, 最高 35% off http://goo.gl/k27zx 9. 免费的Marriott Hotel 四晚酒店入住 只需消费一笔无金额限制 http://bankbonus.blog.163.com/ 最近申请chase家的这个信用卡会弹出一个页面,写着Before you go…We hope you will reconsider 难不成他们家最近被人拿太多这个免费机票了 不用对它客气, 赶紧点击Return&Apply, 拿到落袋为安。更多详细情况请查看 http://bankbonus.blog.163.com/
【在 w*s 的大作中提到】 : hi i'm new to MS Sql 2012, : 1. open MS Sql management studio : 2. attach my db, say 1.mdf : 3. modify it, save : 4. detach 1.mdf : it complains "still in use" : if i close MSMS, and open it again, then i can detach it. : why ?
because it is online - SET OFFLINE WITH ROLLBACK IMMEDIATE or you need to change DB access mode: Use Master Go ALTER DATABASE YourDB SET SINGLE_USER WITH Rollback Immediate Go SP_Detach_db Go
S*d
24 楼
抱歉上面的网址打不开,可以google"Where to Go Salsa Dancing (Almost) Every Night in Chicago"