<div>
Perfect Solution- well explained
</div>


<div>
<div class="content wysiwyg-content">
I am trying to determine the number of to a SQL Server database through a website written in C#.<br />
I can correctly determine the number of connections using the following script through MS SQL Server Management Studio:<br />
SELECT &nbsp;count(spid) as NoOfConnections FROM master.dbo.sysprocesses<br />
(I intend to filter on web connections, but I want to keep it simple for purposes of the question)<br />
This brings back the correct number.<br />
However, when I run it through the website, it always returns just one connection.<br />
I have checked the C# code is correct by querying another set of data on another table- it works fine.<br />
The connection string I am using is:<br />
&quot;Data Source=.\\SQLEXPRESS;Initi<wbr />al Catalog=myDB;Persist Security Info=True;User ID=myid;Password=mypwd&quot;
</div>
</div>


I am trying to determine the number of to a SQL Server database through a website written in C#.
I can correctly determine the number of connections using the following script through MS SQL Server Management Studio:
SELECT  count(spid) as NoOfConnections FROM master.dbo.sysprocesses
(I intend to filter on web connections, but I want to keep it simple for purposes of the question)
This brings back the correct number.
However, when I run it through the website, it always returns just one connection.
I have checked the C# code is correct by querying another set of data on another table- it works fine.
The connection string I am using is:
"Data Source=.\\SQLEXPRESS;Initial Catalog=myDB;Persist Security Info=True;User ID=myid;Password=mypwd"

Counting connections to SQL Server through C#

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.