Toad World® Forums

Toad-ss 5.0.0.133 Error on drop view creation


#1

Beta Version of Toad creates a drop of view with a fully qualified database
name, which is not allowed.

Category Timestamp Duration Message Line Position

Error 3/2/2010 12:38:58 PM 0:00:00.002 SQL Server Database Error: ‘DROP VIEW’
does not allow specifying the database name as a prefix to the object name. 27 0

Quick-Fix, is just remove the database name and run the script in an editor
session

DROP VIEW [dbo].[VW_VLCS_ Warehouse_ File_Sizes] ;

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary

GO

image004.png

image001.gif

image003.png

image004.png
image001.png


#2

Additionally, is was noticed that the View Details / Script does not work and generates the following error I am not having any problems with Tables, procedures or functions View Details / Script.

Sorry, graphics could not be pasted due to limitations of the community to handle a graphic paste.


#3

It is fixed now. Check the next beta.

Thanks,

Igor.


#4

I have the latest beta but still puts the database name on dropping view.

DROP VIEW [GCCustomer_ Dummy].[dbo] .[vwCrmPatient] ;

Phil Maidlow


#5

the latest build (5.0.0.157) is still using the database name on view drops


#6

Right, the fix will be in the next beta that is supposed to be posted in a
couple of weeks.

Igor.


#7

Works for me!!!

/*** intentionally put in the schema name first ***/

DROP FUNCTION LiteSpeed.[dbo] .[FN_Convert_ Date_Time_ to_STR] ;

Category Timestamp Duration Message

Error 3 / 10 / 2010 2 : 13 : 53 PM 0 : 00 : 00.004 SQL Server Database Error:
‘DROP FUNCTION’ does not allow specifying the database name as a prefix to the
object name .

/*** This works as it is suppose to ****/

use LiteSpeedlocal

go

DROP FUNCTION [dbo].[FN_Convert_ Date_Time_ to_STR] ;

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image001.gif


#8

Works for me!!!

/*** intentionally put in the schema name first ***/

DROP FUNCTION LiteSpeed.[dbo] .[FN_Convert_ Date_Time_ to_STR] ;

Category Timestamp Duration Message

Error 3 / 10 / 2010 2 : 13 : 53 PM 0 : 00 : 00.004 SQL Server Database Error:
‘DROP FUNCTION’ does not allow specifying the database name as a prefix to the
object name .

/*** This works as it is suppose to ****/

use LiteSpeedlocal

go

DROP FUNCTION [dbo].[FN_Convert_ Date_Time_ to_STR] ;

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image001.png