I agree with the others. Something else is calling this job or starting it.

Check msdb.dbo.sysjobs joined to msdb.dbo.sysjobsteps to find any job steps that use the sp_start_job proc or call...

Start here:

http://msdn.microsoft.com/en-us/library/ms144267.aspx

1) Please don't use text or L33T speak in the forums. There's enough acronyms and such flying around these...

Your phrasing is unclear. What do you mean by join two tables using wildcards?

What have you tried? What is your table ddl? Give us create table statements, sample data, and...

Run PerfMon and a server-side sql trace. You might also check the default trace, see if it has enough back log to show you what was going on the last...

Grrrrrrr!

😛

I'm seeing two things. 1) In your result set, you refer to customer 9181, who doesn't exist in the test data. I'm assuming you meant 9151 and this is just...

FYI: I agree with the above statement. In fact, in SSRS, you can...

I'm taking a look at this now.

Just an FYI: Your DROP TABLE script will error out for those of us who don't have your table in our dbs. If you...

WhineWhine, RantRant, ComplainComplain.

Why does morning have to come so early? Can't it wait until I wake up for real?

[/rant]

So, are there any pastries or donuts at the water cooler today?...

Paul,

Thank you for that post. It was very informative.

Ah. Thank you for pointing that out.

I don't see either view or table called sys.objects$ (just did the Resource user db on my local dev copy).

Lowell, make sure to rename the db before you try...

Bad Lowell. We're not supposed to be selecting from Microsoft's secret...

...but I still love you guys. @=)