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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 database hang up

Author  Topic 

suman.reddy39
Starting Member

34 Posts

Posted - 2009-02-11 : 01:04:56
dear all,
i got a problem in my database

We have two DB of LL1& Ll2 with us. A call to a particular stored
> procedure in one database is working fine whereas in other database
> it hangs. Although I've checked all the properties of both the
> database and found both to be the same.

please help me why it is happening..

Thanks in advance.

Don't go the way Life takes you, Take the Life the way you go

subbi

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-11 : 09:11:42
Compare the execution plan? Also are you doing maintenance jobs for your database?
Go to Top of Page
   

- Advertisement -