Truncating Parameters in VS.Net 2003

From: Scott Bieker (sbieker_at_gmail.com)
Date: 10/28/04 

Date: 28 Oct 2004 12:22:07 -0700

I have some stored procedures that accept a text parameter
(specifically I am sending an XML string). If I run the stored
procedure in Query Analyzer, everything works perfectly. However, the
parameter is truncated after about 10 characters in the following
scenarios from VS.Net.

1) Right Click on sproc in VS.Net Server Explorer. Fill in parameter
when prompted. Choose OK. Sproc runs, but SQL Profiler shows
truncated parameter

2) Use Preview/Data option when building a SQL Report Services report.
 sproc runs, but SQL Profiler shows truncated parameter.

This was working awhile back. Not sure what upgrade caused the issue?
 Was there one? Is there a setting I need to change/modify/update?

Thanks for the help.

scott

Relevant Pages

  • Re: Distributed queries
    ... I myself have no problem with the practice of a sproc getting data from ... The BLL approach is nice, because as you say, it is obvious. ... database deployments is that the network is not free. ... > the question really comes down to using stored procedures or .Net code to> implement our business logic. ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Complex Database Transactions
    ... Yes, stored procedures can offer a performance benefit, mainly because ... the code is executing on the server, ... If your sproc ... But if you have multiple operations and/or ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: STORED PROCEDURE IF STATEMENT
    ... at errors from a statement that IMMEDIATELY precedes it. ... one statement executed in the sproc. ... > Im recently started using stored procedures and have inherited many for a ... it is placed at the bottom of a stored procedure. ...
    (microsoft.public.sqlserver.programming)
  • Re: **follow "login" activities**
    ... SQL Profiler can help you do this. ... You can also use some third party tools like Lumigent Explorer which let you ... read the contents of a transaction log from where you can get this ... > look in the Master dB at the stored procedures and extended procedures. ...
    (microsoft.public.sqlserver.security)
  • SQL profiler and index tuning wizard permissions
    ... index tuning wizard. ... however I recently read an article saying that sql profiler can be run by ... I can't find any reference to any kind of stored procedures used by index ...
    (microsoft.public.sqlserver.security)