StrataFrame Forum » .NET Forums » General .NET Discussion » Unusual Stored Procedure Behavior...InstantForum 2017-1 FinalStrataFrame Forumhttp://forum.strataframe.net/StrataFrame ForumTue, 09 Jun 2026 02:04:19 GMT20Unusual Stored Procedure Behavior...http://forum.strataframe.net/FindPost10008.aspxWhen I logged into SQL Server 2005 using windows authentication to execute a stored procedure it worked fine.<br> <br> HOWEVER when I logged into SQL Server 2005 using SQL Server Authentication (the sa account) and executed the SAME stored procedure I got no results.<br> <br> I have no idea why that would make ANY difference. Any advice?<br> <br> ThanksFri, 06 Jul 2007 18:30:34 GMTStarkMikeRE: Unusual Stored Procedure Behavior...http://forum.strataframe.net/FindPost10055.aspxLOL...yeah...when he made the earth go backwards or something :DFri, 06 Jul 2007 18:30:34 GMTTrent L. TaylorRE: Unusual Stored Procedure Behavior...http://forum.strataframe.net/FindPost10053.aspx[quote]How do I get the last two days of my life back? LOL! :w00t:[/quote]</P><P>I think Superman has done this before, hasn't he?Fri, 06 Jul 2007 18:10:56 GMTIvan George BorgesRE: Unusual Stored Procedure Behavior...http://forum.strataframe.net/FindPost10041.aspx[quote]Question: How do I get the last two days of my life back? LOL! <IMG title=w00t src="http://forum.strataframe.net/Skins/Classic/Images/EmotIcons/w00t.gif" align=absMiddle border=0> [/quote]</P><P>Well I don't know how to get your last two days back...but I know for a fact you will know where to look next time :DFri, 06 Jul 2007 15:05:07 GMTTrent L. TaylorRE: Unusual Stored Procedure Behavior...http://forum.strataframe.net/FindPost10039.aspxThis was that .01% of the time... it was a problem hidden in T-SQL.<br> <br> Question: How do I get the last two days of my life back? LOL! :w00t:Fri, 06 Jul 2007 15:01:00 GMTStarkMikeRE: Unusual Stored Procedure Behavior...http://forum.strataframe.net/FindPost10024.aspxIt sounds like you are fighting strictly a permissions issue.&nbsp; When you start having behavior like you are describing, in my experience, it is security permissions 99.99% of the time.&nbsp; Of course, this could be that .01% of the time....but probably not :DFri, 06 Jul 2007 09:57:25 GMTTrent L. TaylorRE: Unusual Stored Procedure Behavior...http://forum.strataframe.net/FindPost10013.aspxHere is another clue... when i was trying to log in using Windows Authentication I was using my username (mmurphy) ... so i tried another user through windows authentication and I got this error:</P><P>Login failed for user 'Domain\WShuey'</P><P>Could that be part of the same problem?Thu, 05 Jul 2007 20:30:32 GMTStarkMike