运行存储过程时断开SQL Server连接 [英] disconnected sql server when run stored procedure

问题描述

运行存储过程时断开sql server的连接.
当我尝试创建或更改存储过程时，它会自动断开dbserver的连接.

仅适用于创建存储过程，更改.

我得到了这个错误.

Hi,
disconnected sql server when run stored procedure.
when i try to create or alter stored procedure it automatically disconnected dbserver.

only for stored procedure create,alter.

this error I am get it.

A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)

如何解决这个问题...

谢谢，

How to solve this issue...

Thanks,
Karthikeyan,Bangalore.

推荐答案

这里是一个例子；将您的代码放入conn.open()和conn.close()中.
希望它能起作用.

Here is an example; put your code inside that conn.open() and conn.close().
Hope it works.

conn.Open();
SqlCommand cmd = new SqlCommand(@"select _regno from _registration", conn);
SqlDataAdapter ada = new SqlDataAdapter(cmd);
dt = new DataTable();
ada.Fill(dt);
conn.Close();

这篇关于运行存储过程时断开SQL Server连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！