Viewing 12 posts - 61 through 73 (of 73 total)
Lynn Pettis - Tuesday, October 24, 2017 3:55 PMReally need to see the code. Without it, we are shooting in the dark.
Lyn,...
October 25, 2017 at 5:44 am
October 25, 2017 at 5:38 am
I got it. It was syntax. Here is the new syntax
Declare @cmd
July 28, 2017 at 8:26 am
Steve, thank you for the reply. I am not a DBA by trade so I am a bit slow on the uptake here. the tables are in our ERP system...
July 28, 2017 at 7:32 am
They are select statements into tables such as:
Select ARIKey, fpono, fstatus,
fcreate, frelsno, OrderQty, OrigDate,
LastDate, FirstDate, LastModt,
IsConfirm, OrderQty0, DtOrderQty, IsBlanket,
IsMaster, frcpqty, OrigBlkQty
July 28, 2017 at 7:14 am
Its quite a convoluted program but in the end, I am selecting data from a table and want to export it. This is the last Select statement:
--write out to...
July 28, 2017 at 5:54 am
Thanks, but you would think there would be a better way. I have several fields that need to be included to see if I can replicate the same checksum as...
July 14, 2017 at 5:47 am
J Livingston SQL - Thursday, July 13, 2017 7:29 AM
I am looking at the Checksum() but am not...
July 13, 2017 at 7:32 am
Great Info, Thank you.
June 26, 2017 at 7:35 am
I posted a separate post and I think I got the answer to my question, I feel so stupid. The SQL Agent Service must also be started with a domain...
June 26, 2017 at 7:14 am
Duh, I didn't even think of that. So I need to change the SQL Agent Service logon also to the Domain logon. Wow, I feel so stupid.
June 26, 2017 at 6:37 am
I am having a similar issue but maybe we can brainstorm. My issue is I am getting access denied error when running as an agent but runs fine executed manually....
June 26, 2017 at 6:19 am
Viewing 12 posts - 61 through 73 (of 73 total)