December 15, 2003 at 8:04 pm
I have a stored procedure which runs on my computer but fails to bring up related fields on my shared server web site. If I run just the select statement in QA on the server, it works, but if I execute the stored procedure in QA, the related varbinary fields are null. The total record length is 3368 bytes. What server considerations could cause this failure?
Here's a simplified version of the stored procedure. S2.Signature is a varbinary gif file:
CREATE PROCEDURE dbo.usp_TestSelectCompletedDC
AS
Select
dc.Decedent ,
s2.signature as SignaturePhysician
FROM DeathCertificates dc
LEFT JOIN Signatures s2
ON dc.SignaturePhysician = s2.UID
WHERE DCID = 951
December 16, 2003 at 3:01 am
1.5 ct
maybe you could try to drop/create the proc with QA at your server ?
This could solve dependant settings (that are stored with the sp)
Edited by - alzdba on 12/16/2003 03:02:26 AM
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
December 16, 2003 at 5:20 am
use functions like convert and cast for every field in the query.
Same thing happend with me and cast and convert solved the problem.
*Sukhoi*
*Sukhoi*
December 16, 2003 at 5:20 am
use functions like convert and cast for every field in the query.
Same thing happend with me and cast and convert solved the problem.
*Sukhoi*
*Sukhoi*
December 16, 2003 at 7:57 am
Waste no more brain cells on this one, friends. I was able to repair it by replacing the stored procedure with the one from my computer. FYI, guess it was not a server configuration problem as I suspected, but an invisible gremlin in the code. You had the right idea al. ty.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply