When I logged into SQL Server 2005 using windows authentication to execute a stored procedure it worked fine.



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.



I have no idea why that would make ANY difference. Any advice?



Thanks

This was that .01% of the time... it was a problem hidden in T-SQL.



Question: How do I get the last two days of my life back? LOL!

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

I think Superman has done this before, hasn't he?

LOL...yeah...when he made the earth go backwards or something