Here's the query Activity Monitor runs, database is coming from the sysprocesses table:

SELECT

[Session ID] = s.session_id,

[User Process] =...

Bear in mind you'll only be able to see your own subscriptions on that report, those created by other logins won't show.

Edit: I'm talking rubbish if you're looking in the...

Lowell (2/3/2015)

---

oh, i wish i was running pure 2012 and above...that...

Lowell (2/3/2015)

---

i don't update the registry, but i have a lot of admin scripts that do things like read the registry data/log/backup folders from the registry, so i can use...

Ed Wagner (2/2/2015)

---

SQLRNNR (2/2/2015)

---

I have to agree. ...

I'd expect them to pretty much identical in terms of query speed, but this is true:

The ISNULL version will only return 'Automatically Filed' if...

Looks about right to me, is it not working?

Be careful using DBCC FREESESSIONCACHE, DBCC FREEPROCCACHE, DBCC DROPCLEANBUFFERS, particularly if you're running this against production servers.

Cheers 🙂

FROM [CreditControl].[Testing$] - this is trying to find an object called Testing$ in a schema called CreditControl.

Change the query to include the schema name (presumably dbo):

FROM [CreditControl].dbo.[Testing$]

or

FROM [CreditControl]..[Testing$]

For the test1...

It'll be adding a hidden column needed for replication to the tables, you'll need to do it when the database is not under heavy load.

David Burrows (1/26/2015)

---

Koen Verbeeck (1/26/2015)

---

GilaMonster (1/26/2015)

---

Sean Lange (1/26/2015)

---

Jack Corbett (1/26/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster....

LUN ID I'm not sure about, but this will do Drives & Mount Points:

gwmi -ComputerName servername -Class Win32_Volume | ? {$_.DriveType -eq 3}

Brandie Tarvin (1/26/2015)

---

GilaMonster (1/26/2015)

---

Steve Jones - SSC Editor (1/23/2015)

---

Sioban Krzywicki (1/23/2015)

---

GilaMonster (1/23/2015)

---

I haven't got any clue for a costume. Maybe cheat, buy a green hoodie and go as Arrow (but...

Ed Wagner (1/26/2015)

---

Jeff Moden (1/23/2015)

---

Sean Lange (1/23/2015)

---

Jeff Moden (1/23/2015)

---

Sean Lange (1/23/2015)

---

Oh lordy...I just handed a stored proc and was asked advice on how to make it faster. The proc is...

No problem!