SQL Server - is it possible to execute a stored procedure

Question

I have a stored procedure executed from an ASP.NET application. Can I connect to a procedure and execute it through SQL Server 2005?

Please note that in this case I am not using the DataAdapter. I'm going blindly. The connection string is created on the fly, so I do not have access to the schema from the Visual Studio 2005 constructor.

I was hoping for a solution similar, for example, to how you join a process on a remote server and when you hit a breakpoint, the debugger starts.

Answer 1

, ASP.NET(.. .NET ), , .

SQLTeam.com, , .

Answer 2

• SQL Server 2005
• SQL 2005
• SQL
• SQL Server 2005
• Visual Studio 2005
• SQL Server 2005 Management Studio 2
• SQL Server 2005

Answer 3

http://www.dotnetfunda.com/articles/article27.aspx - .

, , ,

Answer 4

You can also use SQL Profiler to find out what happens behind the scenes.