SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Creating DROP followed by CREATE scripts
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

MorningZ
Starting Member

USA
44 Posts

Posted - 09/20/2006 :  11:28:21  Show Profile  Visit MorningZ's Homepage
Maybe i just haven't had enough coffee today, but in SQL Management Studio's "Generate SQL Script" option it says plain as day in the description:

"Generate the script as DROP statements, CREATE statements, or DROP statements followed by CREATE statements"

Am I just off or is that third option not a choice?

JoeNak
Constraint Violating Yak Guru

USA
292 Posts

Posted - 09/20/2006 :  12:12:57  Show Profile
No, it's not an available choice (even though it's listed in the description).

If you're really interested...
http://weblogs.sqlteam.com/billg/archive/2005/11/22/8414.aspx
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 09/20/2006 :  16:46:32  Show Profile
Man, I really gotta get moving on 2k5



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 09/20/2006 :  17:03:43  Show Profile  Visit tkizer's Homepage
I'm hoping that's fixed in service pack 2. It is so annoying!

Tara Kizer
Go to Top of Page

spirit1
Cybernetic Yak Master

Slovenia
11751 Posts

Posted - 09/21/2006 :  03:11:14  Show Profile  Visit spirit1's Homepage
brett, skip it and wait for 2k8 version



Go with the flow & have fun! Else fight the flow
blog thingie: http://weblogs.sqlteam.com/mladenp
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 09/21/2006 :  12:47:23  Show Profile  Visit tkizer's Homepage
I added this issue to my blog:
http://weblogs.sqlteam.com/tarad/archive/2006/09/20/12374.aspx

Tara Kizer
Go to Top of Page

MorningZ
Starting Member

USA
44 Posts

Posted - 12/22/2006 :  13:38:55  Show Profile  Visit MorningZ's Homepage
So all excited after installing SQL SP1 i went looking for this feature to be "fixed"......

* Edit: check that *
the problem is totally unchanged, no fix in SP1

Edited by - MorningZ on 12/22/2006 13:40:00
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 12/22/2006 :  13:59:07  Show Profile  Visit tkizer's Homepage
Well that's what I said in my blog. The issue is not fixed in sp1. sp2 is in Beta though. I'm not willing to install it until it's released, but let us know if you do and if sp2 fixes it.

Tara Kizer
Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2886 Posts

Posted - 12/22/2006 :  23:49:08  Show Profile  Visit jezemine's Homepage
If you don't want to wait for sp2 rtm, you can try scriptdb - it will create the drop statements for you:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73884


www.elsasoft.org
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000