Viewing 3 posts - 1 through 3 (of 3 total)
Here is some clearer code. The stored procedure created as dbo and run as cmss_user fails on the second select with 'aarobtmp not found'. cmss_user has db_owner permissions.
CREATE PROCEDURE rob_tmp_1
AS
...
April 16, 2002 at 4:40 am
#427261
The first bit works but the second bit doesn't:
SELECT LEFT(mas_firstname, 1) AS t_initial,
mas_lastname AS t_lastname,
adr_address_code AS...
April 15, 2002 at 10:09 am
#427223
We are both on SQL7 by the way.
April 15, 2002 at 9:42 am
#427214