May 3, 2006 at 8:02 am
We have a problem where intermittently the results from a stored procedure do not display in the database output window. The SELECT statements work all of the time but the UPDATE and PRINT statements hardly ever show the results.
It runs a PRINT statement the first time you go into Visual Studio but doesn't again unless you go back out and in. Something isn't being reset.
Has anyone else had this problem? We are running Visual Studio 2003 enterprise .Net framework of 1.1.4322 SP 1.
Thank you.
Susan
May 5, 2006 at 7:02 am
I am having the same type of issue. I have SQL 2000 loaded locally on my pc and I created a simple stored procedure that only has a PRINT statement inside. If I use the SQL's Query Analyzer to run the procedure the output returns properly every time. If I run the same stored procedure from within Visual Studio the results returned to the Output window are intermittent. If I execute the procedure 10 times in a row, it’s never the same but, on average 4 times out of 10 I get the output returned from the PRINT statement and the rest of the time all that is shown is “Running dbo.spTest”. I have also noticed that the same issue is happing with the output for my UPDATE and INSERT statements, but my SELECT statements work perfect every time. I would greatly appreciate any help with this annoying issue.
My specs are:
AMD Athlon 64 3200+ w/ 1GB RAM
XP Professional 2002 w/ SP2 (all updates)
Visual Studio .NET Enterprise 2003
.Net Framework 1.1.4322 SP1
SQL Server 2000 w/ SP4 [Developer Edition 8.00.2039]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply