Error removing a view

I have developer who created a view on a database in SQL MSDE 2000 and for some reason it was created without an owner. When I try to DROP this view I get the following error message:
Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the system catalog.
Any help on how I can get this view would dropped would be greatly appreciated
Thanks,
Jerry
hi,
"Jerbear64" <Jerbear64@.discussions.microsoft.com> ha scritto nel messaggio
news:77383992-90E5-4220-9866-01EDDAC0ADDF@.microsoft.com...
> I have developer who created a view on a database in SQL MSDE 2000 and for
>some reason it was created without an owner. When I try to DROP this view
I get
> the following error message:
> Cannot drop the view 'V_RATE_CATEGORY', because it does not exist in the
system
>catalog.
> Any help on how I can get this view would dropped would be greatly
appreciated
it's actually not possible the object not having an owner... it will inherit
the creator owner name...
if you logged in with a different login that not maps to that user, try
locating it with it's owner name in the form , owner_name.object_name
if his user name in the database is minnie, try
minnie.V_RATE_CATEGORY
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jerry,
A similar question was just raised in the .server group. Do you know what
tool the developer was using? (I have only seen this when developing using
Access 2000 ADPs. But that may not be the only cause. That is why I am
curious.)
Russell Fields
"Jerbear64" <anonymous@.discussions.microsoft.com> wrote in message
news:27d5901c46449$0f74ce80$a601280a@.phx.gbl...[vbcol=seagreen]
> Modify the table sysobjects field UID and change it from a
> 11 to 1 and then I was able to remove the view.
> Jerry
>
> MSDE 2000 and for some reason it was created without an
> owner. When I try to DROP this view I get the following
> error message:
> not exist in the system catalog.
> be greatly appreciated
|||I know it should not be possible, but the owner came up showing a "null" value. How it happen I don't but it did.
Jerry
"Andrea Montanari" wrote:

> hi,
> "Jerbear64" <Jerbear64@.discussions.microsoft.com> ha scritto nel messaggio
> news:77383992-90E5-4220-9866-01EDDAC0ADDF@.microsoft.com...
> I get
> system
> appreciated
> it's actually not possible the object not having an owner... it will inherit
> the creator owner name...
> if you logged in with a different login that not maps to that user, try
> locating it with it's owner name in the form , owner_name.object_name
> if his user name in the database is minnie, try
> minnie.V_RATE_CATEGORY
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

Error on deleting SQL/MSDE database

Hi,
On calling the source attached below to drop sql database, I get the
following error randomly,
"Cannot detach the database 'DBNAME' because it is currently in use.
[Microsoft OLE DB Provider for SQL Server]"
I am not sure what am I doing wrong here.
Any pointers in this regard will be appreciated.
Regards,
Usman
con.Execute "use master"
' Get list of processes blocking this catalog and try to
kill all them
Set rs = con.Execute("sp_who2", , adCmdStoredProc)
If Err.Number = 0 And Not rs Is Nothing Then
While Not rs.EOF
If StrComp(rs("dbname"), sCatalog, vbTextCompare)
= 0 Then
con.Execute "kill " & rs("spid")
' Ignore errors
Err.Clear
End If
rs.MoveNext
Wend
rs.Close
End If
con.Execute "sp_detach_db('" & sCatalog & "', 'true')", ,
adCmdStoredProc ''''''''$$$$$$$$$$$$$$$
Hello,
Do the below command from ISQL window
USE MASTER
GO
ALTER DATABASE <DBNAME> Set SINGLE_USER with Rollback Immediate
GO
DROP Database <dbname>
Thanks
Hari
"Usman" <khanusman@.gmail.com> wrote in message
news:1170770913.673583.11240@.s48g2000cws.googlegro ups.com...
> Hi,
> On calling the source attached below to drop sql database, I get the
> following error randomly,
> "Cannot detach the database 'DBNAME' because it is currently in use.
> [Microsoft OLE DB Provider for SQL Server]"
> I am not sure what am I doing wrong here.
> Any pointers in this regard will be appreciated.
> Regards,
> Usman
>
> con.Execute "use master"
> ' Get list of processes blocking this catalog and try to
> kill all them
> Set rs = con.Execute("sp_who2", , adCmdStoredProc)
> If Err.Number = 0 And Not rs Is Nothing Then
> While Not rs.EOF
> If StrComp(rs("dbname"), sCatalog, vbTextCompare)
> = 0 Then
> con.Execute "kill " & rs("spid")
> ' Ignore errors
> Err.Clear
> End If
> rs.MoveNext
> Wend
> rs.Close
> End If
> con.Execute "sp_detach_db('" & sCatalog & "', 'true')", ,
> adCmdStoredProc ''''''''$$$$$$$$$$$$$$$
>

Error msg when installing

When I try to run MSDE setup, i get a msg (after a msg about starting to
configure) roughly like this: "...instance name is invalid" - how come?
Very grateful for help!
Hi,
Try running the setup from command line to install the MSDE.
1. Run command prompt.
2. Change the directory to the MSDE install extract folder
3. Run the following command:
setup.exe INSTANCENAME="testmsde" DISABLEROLLBACK=1 SAPWD="password" /L*v
c:\temp\setup.log
Thanks
Hari
"Black Eagle" <BlackEagle@.discussions.microsoft.com> wrote in message
news:F0709E51-93C5-42D3-98B6-DB32FB7B0127@.microsoft.com...
> When I try to run MSDE setup, i get a msg (after a msg about starting to
> configure) roughly like this: "...instance name is invalid" - how come?
> Very grateful for help!
>

Error Message When Connecting to SQl Server Data

I am using MSDE on XP pro Service Pack 2 and have stored my data on the
default instance of MSSQLSERVER on my computer ID OFFICEPC. This is
networked to LAPTOP and SHOPPC.
My Access front end works fine with the SQL back end on the OFFICEPC. But
when I try to link the same front end from one of the other computers using
ODBC, i get the following error:
Connection Failed:
SQL state 2800
SQL Server Error 18456
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
'OFFICEPC\Guest'
I have run svrnetcn.exe and enabled port 1433 to pass through the firewall.
Ports 135 and 445 are also enabled.
What have I done wrong? Thanks in advance for any help
hi Gerald,
"Gerald G" <GeraldG@.discussions.microsoft.com> ha scritto nel messaggio
news:54F59F97-F083-4C93-B08A-4FCEA3429731@.microsoft.com
> I am using MSDE on XP pro Service Pack 2 and have stored my data on
> the default instance of MSSQLSERVER on my computer ID OFFICEPC. This
> is networked to LAPTOP and SHOPPC.
> My Access front end works fine with the SQL back end on the OFFICEPC.
> But when I try to link the same front end from one of the other
> computers using ODBC, i get the following error:
> Connection Failed:
> SQL state 2800
> SQL Server Error 18456
> [Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user
> 'OFFICEPC\Guest'
> I have run svrnetcn.exe and enabled port 1433 to pass through the
> firewall. Ports 135 and 445 are also enabled.
> What have I done wrong? Thanks in advance for any help
it seems you do not have firewall troubles, but standard security problems,
as OFFICEPC\.. users are not granted login to MSDE instance... please verify
your Logins
can you telnet on port 1433 the MSDE instance?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea - thanks for answering
I think you are right about it being a standard security problem. How do I
telnet on port 1433, and How do I grant login to my MSDE instance?
"Andrea Montanari" wrote:

> hi Gerald,
> "Gerald G" <GeraldG@.discussions.microsoft.com> ha scritto nel messaggio
> news:54F59F97-F083-4C93-B08A-4FCEA3429731@.microsoft.com
> it seems you do not have firewall troubles, but standard security problems,
> as OFFICEPC\.. users are not granted login to MSDE instance... please verify
> your Logins
> can you telnet on port 1433 the MSDE instance?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi Gerald
"Gerald G" <GeraldG@.discussions.microsoft.com> ha scritto nel messaggio
news:7CD6EC0F-53A4-4252-9228-A40089BE66FF@.microsoft.com
> Hi Andrea - thanks for answering
> I think you are right about it being a standard security problem.
> How do I telnet on port 1433, and How do I grant login to my MSDE
> instance?
>
in order to grant your 'OFFICEPC\xxxx' users, you have to add them to the
SQL Server Windows logins...
please have a look at
http://support.microsoft.com/default...N-US;q325003#8 for
further info about granting login to Windows logins/groups
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

error message

I finally installed MSDE and have the icon in my tray at the bottom of the screen.
When I try to connect to a database using the wizard in the web matrix program I get this message:
Unable to connect
SQL Server does not exist of access denied
Connection Open (Connect ())
What might be wrong??
Thanks for your help I'll get it soon (I hope)
Del Dobbswell, are you specifying the correct instance name? username? password?|||see this

http://support.microsoft.com/?kbid=328306