Heh. ROTFLMAO! Oh, the irony!

It appears that your collection times were significantly larger than your run times. Since you have posted many of the statistics as rates we will need the length of...

Well, in my case, it only happens when my laptop has been working off-line for more than 24 hours. I can solve it by just going on-line to the...

Heh, NOW I remember it, I have used this before. The funny thing is every time I try to remember it or...

I have not had a chance to test it either, I am just taking it from conversations with MS PSS. I would love it if you could prove me...

Thanks Ryan, that did it!

ALZDBA (5/18/2008)

---

SQL Server 2005 Features Comparison

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

states :

Service Broker

...

Nice one, Jeff.

Great Article!

yeah, I can't figure out why though. I've got the right address in the IFcode, but somehow its coming out with this rogue pointer.

Here's what I put in:

[font="Times New...

You could start with this:

select s.text,

P.*

from master..sysprocesses P

Cross apply fn_get_sql(sql_handle) s

though you will get better info from a profiler sessions.

Yeah? Well let's jst see what happens when we extract your avatar and uncover the hidden right side:

Ha! I knew it!

sarkisp (5/16/2008)

---

I have restarted server, i have opened port on router and firewall ( I have also disabled firewall), I have changed port while connecting to server. According Microsoft docs...

Write a NET.BAT file like this:

ECHO Hi!

And put it in the default directory of your xp_CmdShell command.

I get this once in a while myself and (for me) it has always turned out to be a domain trust/authorization problem. YMMV.