Hi
Have recently upgraded a Server to 2008 SP1 (from 2000) and am getting an error on the following procedure run by SQL Server Agent:-
if '$(LOGIN)' = '['+'LOGIN'+']'
begin
print 'Trusted connection'
EXEC MAPS_UpdatePeopleForLeave
end
else
begin
print 'Explicit connection'
EXEC MAPS_UpdatePeopleForLeave 'UID=$(LOGIN);PWD=$(PSWD)'
end
The error is:-
The job step contains tokens. For SQL Server 2005 Service Pack 1 or later, you must use the appropriate ESCAPE_xxx macro to update job steps containing tokens before the job can run.).
Can anybody help me resolve this please
Thx