Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Sql Server Crashes when create/alter SP

Author  Topic 

ramsesiitr
Starting Member

22 Posts

Posted - 2010-08-05 : 04:02:30
Hi all,
First, sorry if the message is posted in wrong place.

Since yesterday, whenever I try to create a sp or update and existed sp, SQL Server stops working(stops the service) and gives this error:

Msg 109, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server.
(provider: Shared Memory Provider, error: 0 - The pipe has been ended.)


Has anybody faced that problem before? I am using SQL Server Management Studio 2005 SP3. I searched the error on the Internet and it seems like an old bug based on SP1, but it should have been fixed in SP2.

Any idea?
Thanks in advance

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-05 : 11:13:18
Look in the SQL Server Error Log for dumps or other errors and let us know what you find.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -