You should look into building or buying WMI querying services that allow you to monitor for such events remotely.

The problem with trying to have the server send you...

Would there be a downside to that data getting published to the world?...

Jeff Moden (11/10/2009)

---

Alexander Kuznetsov-291390 (11/10/2009)

---

These are incredibly smart techniques, but after playing with such approaches I decided that I don't want to put it into production - they are just...

GSquared (11/17/2009)

---

Use cursors when you need to iterate through databases and tables where the command isn't something that can be written as a single T-SQL command.

For example, if you want...

Paul White (11/16/2009)

---

Matt,

Where did I say that a running total MUST be deterministic? (Your capitalization)

It seems good practice to me that the 'order by' part of a ranking function...

Alexander Kuznetsov-291390 (11/16/2009)

---

Matt Miller (#4) (11/16/2009)[

Not that I care to get in the middle of a good brawl, but where is the presumption that a running total MUST be deterministic...

Paul White (11/16/2009)

---

sqlservercentralitgeekry (11/16/2009)

---

Granted, the non-unique rows may have incorrect running total values, but ROW_NUMBER preserves the integrity of the series as a whole.

---

For that application, an arbitrary tie-break is...

I'd say - invest in something like Business Objects, etc.... You can control WHAT they ask (while givng them a lot of freedom), while maintaining some control over HOW it...

Try putting brackets about and of the places you concatenate the column name. It's possible you have column names with spaces in them, or reserved words.

in/*use master; select * from sys.users*/jection

Do the checking to see if you have NULL values first. Assuming there are no nulls, THEN run the sum.

in other words:

IF EXISTS (select * from #myValns where rate...

If you need this functionality, then it might be worth testing out what happens when you...

You may have trouble with this one. It's having a hard time with with XML data type column you have (XML wasn't a valid data type in 2000), so...

Michael Valentine Jones (11/10/2009)

---

There may be jobs where knowing the answers to those questions would be important. I have encountered consulting companies that seem more interested in the “star...

It's converting a month "number" to a month "text". In other words:

You type in '4' and you get back "April', 5 gets you "May", etc....

In SQL Server - I'd...