Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Old Forums
 CLOSED - SQL Server 2005/Yukon
 Creating DROP followed by CREATE scripts

Author  Topic 

MorningZ
Starting Member

44 Posts

Posted - 2006-09-20 : 11:28:21
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

292 Posts

Posted - 2006-09-20 : 12:12:57
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 - 2006-09-20 : 16:46:32
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

38200 Posts

Posted - 2006-09-20 : 17:03:43
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

11752 Posts

Posted - 2006-09-21 : 03:11:14
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

38200 Posts

Posted - 2006-09-21 : 12:47:23
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

44 Posts

Posted - 2006-12-22 : 13:38:55
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
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2006-12-22 : 13:59:07
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
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2006-12-22 : 23:49:08
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
   

- Advertisement -