Error while running a script sql server 2005

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 2000 Forums

SQL Server Administration (2000)

Error while running a script sql server 2005

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-08-28 : 08:03:51

hello friends!

I am facing while running a script for my Stored Procedures

I have sql server 2005...my server is on client side and i am tried to run my updated script for Stored procedures here on my side within instance then i am getting error like..

.Net SqlClient Data Provider: Msg 0, Level 11, State 0, Line 0
A severe error occurred on the current command. The results, if any, should be discarded.

what is that error

please help me out

T.I.A

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-28 : 08:16:24

Post connection string here, together with the query you are trying to run.

Peter Larsson
Helsingborg, Sweden

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-08-28 : 08:27:55

hi peso ..!

can you elaborate it or any link you provide for it....

thanks....

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-08-28 : 11:20:18

www.ConnectionStrings.com

Madhivanan

Failing to plan is Planning to fail

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2006-08-28 : 11:33:14

hi

i really dont know what to do now see

i just created one stored procedure script

like

USE [Test_data]
GO
/****** Object: StoredProcedure [dbo].[In_Emoc_GetListEmp] Script Date: 08/28/2006 20:55:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[In_Emoc_GetListEmp]
AS
BEGIN
SET NOCOUNT ON
SELECT * FROM RATE ORDER BY ID asc
SET NOCOUNT OFF
END

and i ran in instance of sql server 2005 and i got above error

where is connection string here i really dont know @ that i am sql server guy

please help me out

T.I.A

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources