Hi
I am running a SP from the SQL Server Agent, the job has one step that
looks like this.
exec sp_generatefly
and I got this error
Msg 8152, Sev 16: String or binary data would be truncated. [SQLSTATE
22001]
Msg 3621, Sev 16: The statement has been terminated. [SQLSTATE 01000]
however if I run that exact commandline from queryanalyzer it works
perfectly.
What does SQL Server Agent do different from query analyzer? this has
me totally stumped.
this problem start when I change servers(a new pc), in the old machine the job work fine. but I install the same programs, backups and sp4 for SQL 2000 in the new machine, but it doesn't work now!.....where is the problem, can anyone help me please? thank you......
I am running a SP from the SQL Server Agent, the job has one step that
looks like this.
exec sp_generatefly
and I got this error
Msg 8152, Sev 16: String or binary data would be truncated. [SQLSTATE
22001]
Msg 3621, Sev 16: The statement has been terminated. [SQLSTATE 01000]
however if I run that exact commandline from queryanalyzer it works
perfectly.
What does SQL Server Agent do different from query analyzer? this has
me totally stumped.
this problem start when I change servers(a new pc), in the old machine the job work fine. but I install the same programs, backups and sp4 for SQL 2000 in the new machine, but it doesn't work now!.....where is the problem, can anyone help me please? thank you......