I deleted an important database by accident!

I just got a new job at a new company, and I had a network terminal
with sql server which accessed a list of databases. One of them was
the database I was expected to work with.
The first day I opened some stored procedures and some tables to get a
feel of how the database worked.
The next day, the database was gone.
I am new to SQL Server (though I've read books on it) and I wonder if
I deleted the database by mistake. For instance, I double clicked on
some of the stored procedures to open them. Perhaps that runs them
instead of opening them and they delete the database? (Some of the
procedures I clicked on were 'system procedures')
I would think that it would not be simple to delete a database by
mistake - I would expect at least a message saying "are you sure"?
Monday I come back to face the music - so does anybody know how this
could happen?
-- MarvinHi
No , If you double click on stored procedure that won't drop the database as
you describe that.
Yes , if ou delete the db via EM , it always asks you "are you sure...."
bit not if you run DROP DATABASE... via QA.
Also , if some users were connected to the db you also get a message that
'db is in use..."
<COHENMARVIN@.lycos.com> wrote in message
news:67a8223a-4a1c-4eff-9ea8-9eb32417a0b8@.8g2000hse.googlegroups.com...
>I just got a new job at a new company, and I had a network terminal
> with sql server which accessed a list of databases. One of them was
> the database I was expected to work with.
> The first day I opened some stored procedures and some tables to get a
> feel of how the database worked.
> The next day, the database was gone.
> I am new to SQL Server (though I've read books on it) and I wonder if
> I deleted the database by mistake. For instance, I double clicked on
> some of the stored procedures to open them. Perhaps that runs them
> instead of opening them and they delete the database? (Some of the
> procedures I clicked on were 'system procedures')
> I would think that it would not be simple to delete a database by
> mistake - I would expect at least a message saying "are you sure"?
> Monday I come back to face the music - so does anybody know how this
> could happen?
> -- Marvin

I deleted an important database by accident!

I just got a new job at a new company, and I had a network terminal
with sql server which accessed a list of databases. One of them was
the database I was expected to work with.
The first day I opened some stored procedures and some tables to get a
feel of how the database worked.
The next day, the database was gone.
I am new to SQL Server (though I've read books on it) and I wonder if
I deleted the database by mistake. For instance, I double clicked on
some of the stored procedures to open them. Perhaps that runs them
instead of opening them and they delete the database? (Some of the
procedures I clicked on were 'system procedures')
I would think that it would not be simple to delete a database by
mistake - I would expect at least a message saying "are you sure"?
Monday I come back to face the music - so does anybody know how this
could happen?
-- Marvin
Hi
No , If you double click on stored procedure that won't drop the database as
you describe that.
Yes , if ou delete the db via EM , it always asks you "are you sure...."
bit not if you run DROP DATABASE... via QA.
Also , if some users were connected to the db you also get a message that
'db is in use..."
<COHENMARVIN@.lycos.com> wrote in message
news:67a8223a-4a1c-4eff-9ea8-9eb32417a0b8@.8g2000hse.googlegroups.com...
>I just got a new job at a new company, and I had a network terminal
> with sql server which accessed a list of databases. One of them was
> the database I was expected to work with.
> The first day I opened some stored procedures and some tables to get a
> feel of how the database worked.
> The next day, the database was gone.
> I am new to SQL Server (though I've read books on it) and I wonder if
> I deleted the database by mistake. For instance, I double clicked on
> some of the stored procedures to open them. Perhaps that runs them
> instead of opening them and they delete the database? (Some of the
> procedures I clicked on were 'system procedures')
> I would think that it would not be simple to delete a database by
> mistake - I would expect at least a message saying "are you sure"?
> Monday I come back to face the music - so does anybody know how this
> could happen?
> -- Marvin

I can't connect to SQL server 2005 with Management studio express

Hi all,

my server is on internet and can be accessed by sqlb2.webcontrolcenter.com to my hoster.

I subscribe for SQL server 2005

I try to connect to sql server 2005 via Management studio express and visual web developper express without success. i got this error below with both:

Cannot connect to sqlb2.webcontrolcenter.com

a connectionmwas successfully established with the server, but then an error occured during the login process. (Provider: TCP provider, error: 0 -The specified network name is no longer available )

(Microsoft sql server, error 64)

thank's for your help

These errors indicate that the connection between the client and SQL Server was broken for some reason while SQL Server was writing data to the client. You mention that you are accessing the server across the internet, so part of the issue may be routing/firewall rules/devices between you and your provider...if you are able to get through to the server, you may not be able to get data back from the server or vice-versa.

Can you telnet to the TCP port that SQL Server is listening on? i.e. telnet to the IP and port combination you are trying to connect to?

Additionally, ensure your SQL Server is configured to allow remote connections.

This is typcially more of a transport-level issue than SQL Server error (in this case, TCP for example)...

|||

Hello Chad Boyd,

it was my firewall , i put it off and now my connection is working

Thank's for your response