Amen, no matter how much I have learned...

I would probably handle the starting of the job as a Service Broker task. It separates the initiator from the executor very cleanly. It also means that the...

In every version structures are either added or changed, code is removed, added, changed, and the agent is expecting certain code and structures.

In most cases a service pack won't fix...

You are asking for trouble, if the server was in-place upgraded you MIGHT get away with it. But I've got to say I wouldn't do it. Why are...

Alright Jared, I stand corrected on the reg key.

Personally I have never needed to retrieve it after I did an install. But YMMV..

CEWII

jared-709193 (11/2/2011)

---

Elliott Whitlow (11/2/2011)

---

I think we may be over-thinking this. Licensing is a function of paperwork. I have 5 SQL 2008 Standard servers and 5 SQL 2008 Standard...

Probably, but if you have MSDN you can probably just go there and download it.

CEWII

I think we may be over-thinking this. Licensing is a function of paperwork. I have 5 SQL 2008 Standard servers and 5 SQL 2008 Standard licenses. The...

I have it running on every SQL server.

CEWII

Well, lets break the parts down first.

To get access to the other server you will need a share and access to that share, you will also need access at the...

I am 99.9999999% sure it won't, especially anything with a data-flow..

I think 2008 and R2 will but I'd have to test that for certainty.

I am pretty sure if you try...

NJ-DBA (11/1/2011)

---

Elliott Whitlow (10/31/2011)

---

I see two things wrong with this approach.

1. You use xp_cmdshell, which we have been having quite a raging discussion on in another thread.

2. It implies that...

Create a condition, I'd call it Except DBAMonitoring

Facet will be Database

Expression will be @Name != 'DBAMonitoring'

Within the Policy see Against Targets, Choose Except DBAMonitoring

This should do it I think.

CEWII

Welsh Corgi (10/31/2011)

---

Elliott Whitlow (10/31/2011)

---

I have seen it happen much more when "My Documents" was not on a local drive but instead of on a network or offline folder. ...

I have played (emphasize played) with this in the past but I seem to remember that I included some commands that were never executed in the code like ALTER LOGIN...