Service Broker only works on SQL Express when it is connected to another SQL Server with a full license to Service Broker.

I don't think that you can get this.

I always just set a variable at the beginning of my stored procedures:

Declare @ProcName varchar(64)

Set @ProcName = 'spMy_SprocName'

...

Print @ProcName

...

Jeff, couldn't you use MAX(CAST(RestrictedID as int)) instead of SUM(SIGN(..))?

Let us know how it works out...

OK, now that's just wrong!

I'm keeping my eye(s) on you mister...

And don't think that I haven't noticed that your "No RBAR" avatar is...

Do you mean which queries have had the longest average run time since the server was started? Or do you mean which currently running queries are the oldest?

BEGIN TRY

drop table ##tmp_mj_jobSync

END TRY BEGIN CATCH END CATCH

Select * into ##tmp_mj_jobSync from mj_jobSync

This works also... 🙂

If you use PerfMon (and I do recommend it), then be sure to include these in addition to those already mentioned:

PhysicalDisk: %Idle and Disk Transfers/sec for each volume visible

Memory: Page...

Suggestion: Put a service wrapper around your license key validation DLL and call it with LPC.

Yeah, without the BEGIN..END it's an infinite loop!

In my experience, Dynamic queries are less likely than compiled ones (i.e., sProcs) to do that.

:crazy: Blimey! Whats with all of the smiley faces? :unsure: We've got more yellow dots here than a teenage fanboy with a chocolate addiction! :w00t:

😉

Matt Miller (5/16/2008)

Hey now! where the heck did THAT come from??? :hehe::w00t:

Sheesh - travel home to see the wife, and get smacked around on...

Here's the questions that I generally ask:

- Why do you thin that it is an Index problem?

- Is everything slow, or are specific things slow?

-- if specific: what are...

Actually, this all seems pretty consistent with the documented behavior for READPAST. From BOL:

READPAST

Specifies that the Database Engine not read rows that are locked by other transactions. Under...