Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Prem4ku
Starting Member
1 Post |
 Posted - 2012-08-24 : 08:14:24
|
| 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
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-08-24 : 09:23:39
|
| 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. |
 |
|
|
|
|
|
Sql Server login failed