February 29, 2008 at 8:02 am
I have a db that serves as the back-end to an Office Communication System. I need to create a asp .net website that will provide users connection data, such as how many connections at what time, etc.
Where is this information maintained in the sql db? How would I provide this info? Any ideas to get me started would be great!
Is presenting the data via an asp .net page the best solution or are there other, better ways, such as crystal reports? (I do not have reporting services installed)
February 29, 2008 at 8:47 pm
Check out BOL for Dynamic Management Views. There is one called sys.dm_exec_connections that has user connections. There are many others that may have information you want as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply