I was thinking the built in WMI one. The File Watcher would be a separate article (also would be good). One could build on the other.

I don't have a reference that does this exactly, but here are a few things to get you started in PBM:

Video on policies: http://www.sqlservercentral.com/articles/64789/

Standardization Article: http://www.sqlservercentral.com/articles/Policy+Based+Management+%28PBM%29/88486/

Basically you'd want to...

john barnett (4/24/2012)

---

Steve - you don't buy the software. What you buy is a license to use the software in accordance with the terms and conditions in the accompanying license...

jay-h (4/24/2012)

---

Steve Jones - SSC Editor (4/23/2012)

---

djackson 22568 (4/23/2012)

I'm not sure I want a law enforcement official suggesting that drugs are acceptable, or drinking and driving isn't a big...

Nice job, Ryan.

Please do. Keep it simple, take a quick scenario, show some images of how they configure things, how the task flows the data in. Assume a simple Excel -> table...

No change to move from image to varbinary(max). You could mess with the text in row properties to better handle the storage of the data, but no change for the...

Have you looked at Merge? http://msdn.microsoft.com/en-us/library/bb522522%28v=sql.105%29.aspx

You could use PBM to limit objects that don't fall into certain schemas. A little complex, but it could work.

I like Paul's suggestion. Since you have some of the data in the database, I wouldn't think you need to export that. You can load a new table with the...

I'd be curious why they couldn't get Filestream to work. Was it something with the application changes? The coding is a little tricky.

You could get away from Filestream and go...

djackson 22568 (4/23/2012)

---

Steve,

You are right to have concerns, but it doesn't sound like you have taken the time to think this all the way through, or maybe, you don't feel...

Grant Fritchey (4/23/2012)

---

Huge congratulations....

Jeff Moden (4/23/2012)

---

I used to do that. What I found it is that I usually can't change those people that frustrate me, so I just avoid them. It'll...

Good point, Perry. I don't think of the distributor database as a system database, and even from Microsoft's use of it, it's in some type of purgatory between system and...