June 27, 2012 at 6:12 am
Hi,
I am getting the following error when I right-click on a stored procedure (any one) in Management Studio and select "modify". It hangs for a while and then I get the error message below.
The weird thing is I can execute them fine (right-click and select "execute stored procedure")
I am just unable to edit them.
I have tried all the recommended steps (changing connection timeout in server properties from 0 to 600) etc
The error mesage is below.
Thanks for any replies.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attempt to retrieve data for object failed for Server '*********'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attempt+to+retrieve+data+for+object+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Failed to connect to server *********. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. (System.Data)
June 27, 2012 at 7:23 am
Something blocking you from updating the metadata perhaps.
Try modifying a proc, and when it is waiting run sp_who2 or query sys.dm_exec_sessions & sys.dm_exec_requests for the spid your altering the proc from to see if you are being blocked and by whome.
June 27, 2012 at 7:34 am
leesider (6/27/2012)
Hi,I am getting the following error when I right-click on a stored procedure (any one) in Management Studio and select "modify". It hangs for a while and then I get the error message below.
The weird thing is I can execute them fine (right-click and select "execute stored procedure")
I am just unable to edit them.
I have tried all the recommended steps (changing connection timeout in server properties from 0 to 600) etc
The error mesage is below.
Thanks for any replies.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attempt to retrieve data for object failed for Server '*********'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attempt+to+retrieve+data+for+object+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
Failed to connect to server *********. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. (System.Data)
Probably you don't have the proper accese to modify procs.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 27, 2012 at 7:38 am
Silly me, I am able to work around it by right-clicking and selecting "Script Stored procedure as" and then "Alter to".
Don't know why modify is doing that but the above way will do.
June 27, 2012 at 10:49 pm
leesider (6/27/2012)
Silly me, I am able to work around it by right-clicking and selecting "Script Stored procedure as" and then "Alter to".Don't know why modify is doing that but the above way will do.
🙂
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply