Viewing 2 posts - 1 through 2 (of 2 total)
No, but I solved the problem. due to Report schema there is a securty right error.
when i created sp B by owner dbo. Script and sp have same resulsets.
November 26, 2008 at 8:19 am
#903784
I found this message in ErrorLog file.
"2007-09-10 09:05:34.76 spid14s 1 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2007-09-10 09:05:34.84 spid4s...
September 11, 2007 at 3:18 am
#732710