I too clear locked records all the time having all users exit out of the system (with 50+ concurrent users). Here's what I use:
delete from tempdb..DEX_SESSION where session_id not in (select SQLSESSID from DYNAMICS..ACTIVITY)
GO
delete from tempdb..DEX_LOCK where session_id not in (select...
Our company desperately needs a Real Estate software as well. We have about 350 retail stores that we lease. We need lease tracking, rent, business licenses, maintenance, etc. Seems alot of the software I looked at came from the direction that you were the property owner. We currently use...
Professional Services Tool Library from CustomerSource has a Login/User Generator Tool Kit for free, you just have to download and install it. It will re-create logins and users based on the users that are currently set up. It's useful for recreating Users and Logins to a restored database on...
I'm searching my but of for a complete feature list of Microsoft Exchange 2000.
The only lists that I still find are the features that are adapted or added to the new release. [sadeyes]
Does anybody know or have a feature list???
Thanx in advance !!!
Curbe
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.