Viewing 6 posts - 1 through 6 (of 6 total)
Although the user did not have an account, after running EXEC sp_dropuser 'Fareed' the error went away.
March 30, 2006 at 1:21 pm
#629967
After overlooking the step history....
Executed as user: NT AUTHORITY\SYSTEM. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The...
January 23, 2006 at 1:05 pm
#616523
The error doesn't tell much:
The job failed. The Job was invoked by User sa. The last step to run was step 1 (Logged_in_users).
January 19, 2006 at 1:06 pm
#615914
That worked! After you mentioned it, the variable to one value issue made perfect sense.
Thanks
January 18, 2006 at 2:49 pm
#615636
After further review I realized the problem is caused by certain dates missing from the dbo.tblTime.[Date] table.
This was a mistake on my part. The statement works as expected...as long as...
January 13, 2006 at 11:34 am
#614709
Ed,thanks for replying.
Yes, if anyone has an example of how to handle this, I would greatly appreciate it.
September 15, 2004 at 9:18 am
#523186