Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 687
  • Last Modified:

SQL Mgmt Studio - ACTIVITY MONITOR >> LOCKS BY OBJECT....?

Experts,

I'm having some issues with our Application "locking-up" on certain menus. Our DB is SQL Server 2005. In my research I've noticed that in SQL Server Management Studio there it an Activity Monitor.

What does the LOCKS BY OBJECTS tell me...? Are these ALL locks that have occured regardless of status,....OR.... is this a listing of CURRENT LOCKS on the system?
0
MIKE
Asked:
MIKE
  • 2
1 Solution
 
aelliso3Commented:
that is current locks ... basically the same as running exec sp_lock
0
 
JensMigCommented:
You can use the XmlWriter class to create your XML.

You dont need to write it into a file, you can redirect it into memory if you like.

using (XmlWriter writer = XmlWriter.Create("some.xml"))
{
    writer.WriteStartDocument();
    writer.WriteStartElement("RootElement");

    writer.WriteString("This is nice & good coding. Even <This> works well");

    writer.WriteEndElement();
    writer.WriteEndDocument();
}

Open in new window

0
 
JensMigCommented:
I am sorry, I hit the wrong tab and therefore the wrong question! Oops! Please ignore!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now