Looks like you changed the post after ratbak replied?

What I would recommend is rather than executing the dynamic SQL, print it so you can see exactly what will be run...

A few ways I can think of to fix this.  I think the BEST solution to fix it is to change the SQL Server Agent service to be an AD...

Is there a reason you don't want to do it from the web interface?

Offhand, I am not sure how to remove them using rs.exe or any other utility, but I...

Wouldn't that be related to parameter sniffing in the scenario I gave vs function in a WHERE clause in the OP?  And if so, the performance could tank due to...

Without seeing any of your data or datatypes, I am really just guessing, but I would be willing to bet that it is related to your group by statement on...

Offhand, the best way I have found to search for it is to use SQL Search OR to script out all of the jobs and do a search in those. ...

Yeah, I wasn't saying it was "good", it is just what it was doing.  I prefer the "WHERE (A=@a) OR (@a IS NULL)" approach myself... and depending on how often...

if @Parameter3 is null, then use table1.id2.

My first step would be to load up the execution plan on both systems and make sure they look similar, if not identical.

Next, I would check for blocking while your...

I am a bit confused why this is dynamic SQL and what you are trying to do.  You have 2 stored procedures that appear to be unrelated.  The first uses...

As a thought - is your master database valid (ie not corrupt) prior to installing that update?  I would run checkdb on it and verify that it is valid as...

Is that your entire stored procedure or did you strip something out?  It looks to me like you are missing a FROM.

My understanding, it won't work QUITE like that.  BUT what you could do is something like:

SELECT Itemcode,Itemname,ItemGroup
FROM tbl1
WHERE (itemgroup IS NULL and @ItemGroup IS NULL) 
 ...

DISREGARD THIS POST

I agree with Grant - you shouldn't need to do anything with the Antivirus.  I also agree that it is likely going to be firewall related on either...

• This reply was modified 4 years ago by Mr. Brian Gale.

Sometimes it is good having a lot of detail, sometimes people are looking for a "quick and easy" answer and my detail just gets skimmed or ignored.

The XE trace will...