SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

Prem4ku
Starting Member

1 Posts

Posted - 08/24/2012 :  08:14:24  Show Profile  Reply with Quote
Hi,
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.

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3383 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  
 New 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