The only thing I have found running a standard trace is that SQL Agents runs stored proc about every half-minute called msdb.dbo.sp_sqlagent_get_perf_counters and it also runs a select statemen... SELECT...

This is a production database, the errors appear in the SQL Server Agent log only and not in the normal Sql Sever log so naturally when I stop the Agent...

Hi Thanks for that advise, I have disabled the only trigger I have on the database and have run a trace in sql profiler for error logs, SQL batch exec...

Hi, just want to bump this post again. I'm still having this issue and no luck with it so far. Has anyone experienced this with the SQL Agent?

Anyone... :crying:

SQL 2008 , Windows Server 2003 Standard x64

Dude, you're a genius! I Can't believe that just moving the statement onto one line made all the difference!

Thanks 😀

Thanks, but still the same result. I've also tried the code below but still the same result

DECLARE @cmdstr varchar(200)

Declare @path varchar (100)

set @path = 'D:\ppc_auctions.txt'

SET @cmdstr = 'bcp "select sku,auction_type_id

from...

I did eventually go down that route and just review new users flagged up by the report on a daily bases.

Well, on the website front-end's users sign-up page, when the user clicks the submit button it returns an authorisation error message to the front-end that refers to the trigger and...

its a very simple table with two columns, ID and IP_Address. The thing is that for a country like the UK there are about 1700 rows in the table each...

Thanks dude, works now. Never though of doing a select in the FROM, that's where experience comes in handy, cheers! 😀

Thanks guys, working now!