Heh this is easy!

There are 86,400 seconds in a day and 1243012622 mod 86400 = 62,222 which, taken as the number of seconds after midnight, gives us 5:17:02pm.

The real question...

julioregalado110 (5/28/2009)

---

So in the Status columm, what does it mean to have numbers like 22 or 7? Is there a particular dictionary or index of what does codes mean? ...

Hey Tim - no worries, let me try to answer your...

1.79E+308 bottles of beer on the wall. Though it is impossible to be precise*

* a float joke! Nearly.

This...

Post #5,002. Woo hoo. 😎

john.arnott (5/27/2009)

---

Ah, the secret formula for building up points without actually demonstrating SQL acumen or adding value to conversations, yet not risking saying something completely wrong....

john.arnott (5/27/2009)

---

Ah, the secret formula...

I agree with Pradyothana. Could not disagree more strongly with G².

ROFL.

If a database is detached while in the recovering or standby state, it cannot be reattached.

Hope that helps.

I can haz more posting pointz?

Wow.

I posted, went to bed, and here we are the following morning with five (count 'em!) pages of posts to catch up on. You (y'all) have been busy! ...

Hey...

My guess would be to give them a work-around set of permissions just sufficient to allow the service to be managed either via SQL Configuration Manager or some hack like...

Heh. Yeah actually that might be it - though it was Commodore 64 BASIC in my case...not COBOL 😀

Paul

Grant Fritchey (2/17/2009)

---

If you think it'll help, with very serious caveats in place, I'd try going against sys.dm_exec_procedure_stats. This will give you the object ID and it marks whether or...

You what? :unsure: