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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sql Server login failed
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 08/24/2012 :  08:14:24  Show Profile  Reply with Quote
I am facing a error while am using a visual basic software with sql 2000 server
when i am using the vb application it lock the database of sql when i am try to login to enterprise manager it show an error login failed in database.
please tell me how can i reconnect to database in enterpise manager.

Flowing Fount of Yak Knowledge

United Kingdom
3385 Posts

Posted - 08/24/2012 :  09:23:39  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
You need to find out how the vb app is stopping other things from working.
It is presumably doing something that is either too resource intensive so the server can't process other requests or is holding locks on system tables.

I think with v2000 a select into statement could do this - but lo9ok for anything that is carried out in a transaction. If you already have a connection then yoou shoould be able to use it to access the system tables with nolock to see what is happening.

Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000