Not getting Script drop option

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Not getting Script drop option

Author

Topic

raky
Aged Yak Warrior

767 Posts

Posted - 2008-05-21 : 08:28:25

hi,

I need to generate scripts for some sp's in my database. For this i follow the below procedure.

Right click on database --> Tasks--> Generate Scripts --> next select the database --> here comes the problem

Here i need to set some options before move forward. They are
SCRIPT DROP --> TRUE
INCLUDE IF NOT EXIST --> TRUE
USE DATABASE --> FALSE.

But iam not getting the option SCRIPT DROP to select it as TRUE. Please tell me how can i make SCRIPT DROP option to appear for me.
Please help me ASAP.

Thanks in Advance..

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-05-21 : 08:57:28

I would say that you do not have permissions to drop objects. Have you checked that you have these permissions?

Also, are you using SP2?

raky
Aged Yak Warrior

767 Posts

Posted - 2008-05-21 : 09:51:30

quote:
Originally posted by RickD

I would say that you do not have permissions to drop objects. Have you checked that you have these permissions?

Also, are you using SP2?

Please tell me how can i know whether iam using sp2 or not?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-21 : 15:50:50

Select @@version or

SELECT SERVERPROPERTY('ProductLevel')

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-21 : 16:06:55

http://weblogs.sqlteam.com/tarad/archive/2006/09/20/12374.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

raky
Aged Yak Warrior

767 Posts

Posted - 2008-05-22 : 01:05:41

quote:
Originally posted by sodeep

Select @@version or

SELECT SERVERPROPERTY('ProductLevel')

I think its service pack2 only

when i execute select @@version .i got following message

Microsoft SQL Server 2005 - 9.00.1399.06 (X64) Oct 14 2005 00:35:21 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

when i execute below statement

SELECT SERVERPROPERTY('ProductLevel')

i got result as RTM

Any way iam still not getting SCRIPT DROP option. Plz help me in this regard because i need this service almost every day.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-05-22 : 01:37:41

You still did not check to see if you had permissions?

Oh, and you do not have any Service Packs on your SQL Server, that is the Original release.

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

raky
Aged Yak Warrior

767 Posts

Posted - 2008-05-22 : 02:15:31

quote:
Originally posted by RickD

You still did not check to see if you had permissions?

Oh, and you do not have any Service Packs on your SQL Server, that is the Original release.

http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en

OK if u don't mind please tell me how can i check whether i had permissions are not. please help me with patience. Thanks a lot for your help upto now.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2008-05-22 : 04:08:13

In Management Studio, check under the Security branch. Click your user and see what Server Roles you have, if it is not sysadmin, check user mappings and see what roles you have on the database.

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-05-22 : 11:58:23

And if you read Tara's link, and you do not have any services packs, it's not going to work anyway. She discusses SP1 and the lack of this functionality.

Terry

mdubey
Posting Yak Master

133 Posts

Posted - 2008-05-25 : 10:01:24

If you have SP2 installed in the server then version is to be 9.00.3042.

Please try to use T-SQL

use Master
go
drop procedure <Procedure_Name>
go

Make sure you have proper permission before using this.

Manoj
MCP, MCTS

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources