Re: Stored Procedure only works in when app uses trusted security
- From: "ZRexRider" <jerryg@xxxxxxx>
- Date: 23 Dec 2005 17:08:03 -0800
Dan you nailed it - SUSER_SNAME() in my trigger blows up because there
isn't a '\' and I didn't code for it.
Happy Holidays to you as well!
Dan Guzman wrote:
> Check the proc (or invoked trigger) to see SUSER_SNAME() is being parsed
> into separate domain/account components. The code may fail with a standard
> SQL Security connection because a '\' is assumed to be present.
>
> --
> Happy Holidays
>
> Dan Guzman
> SQL Server MVP
>
> "ZRexRider" <jerryg@xxxxxxx> wrote in message
> news:1135358521.631291.106350@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> > Hi,
> >
> > I have a .NET application that connects to a SQL 2000 database using
> > trusted security. It eventually calls a stored procedure that receives
> > 3 parameters - nothing special.
> >
> > If I simply change the connection string to use a valid Userid and
> > Password it still connects to the DB w/o problems but when it executes
> > the SP I get the following:
> >
> > System.Data.SqlClient.SqlException: Invalid length parameter passed to
> > the substring function.
> >
> > I change nothing but the login. Same store procedure, same parameters.
> >
> > Any ideas?
> >
.
- References:
- Stored Procedure only works in when app uses trusted security
- From: ZRexRider
- Re: Stored Procedure only works in when app uses trusted security
- From: Dan Guzman
- Stored Procedure only works in when app uses trusted security
- Prev by Date: Re: Stuck with sorting columns
- Next by Date: Re: Stored Procedure only works in when app uses trusted security
- Previous by thread: Re: Stored Procedure only works in when app uses trusted security
- Next by thread: Re: Stored Procedure only works in when app uses trusted security
- Index(es):
Relevant Pages
|
