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
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