Thanks - I thought of that but my concern is that I moved the database being mirrored to new hardware but used the existing witness server so I have 2...

johnbrown105 56149 (1/3/2013)

---

Michael R. OBrien Jr (1/2/2013)

---

I guess I have never been a fan of triple quoting, I usually use CHAR(39) I find it is a lot easier to read...

You could use the stucture available in SQLPS. Set your location to SQLSERVER:\SQLRegistration\Database Engine Server Group\<your group name> then set a variable equal to get-childitem and do a foreach loop...

I can address the -f operator. It is used to format a string. You can specify how to format a series of numeric or alphanumeric values.On the left side of...

2 - I don't get out much :crying:

I discovered Powershell a couple of years ago and I now open Visual Studio just to get TFS Explorer. 😀

I just voted for the Powershell script button. Great idea since it certainly seems to be the way MS wants us to work in the future.

I think setting $ErrorActoinPreference = Stop will do it for you.

Thanks - I was hoping to just be able to annotate my copy. There may somethings I don't wnat to share witht the rest of the community 😀

I tried it on 2008 and 2008R2 and got a NULL on both.

Thanks - that sounds like a good work around - I'll try it!

As Alen said, do it in small chunks. I would add printing a message for each chunk so you know that something is happening. Of course, it takes a while...

I answered based on SSMS 2008. I haven't used the 2005 client tools in quite some time and the question did not specify which version of SQL tools was being...

Voice Recognition - Ugh! I cannot and do not want to think about an entire building of cubilcles talking continuously. ARGGGGHHHH!!!:crazy:

Magnolia, Texas

Moved from Cypress, Texas

Moved from Wellington, Florida

Moved from Tomball, Texas

Moved from Katy, Texas

Moved from Key Biscayne, Florida

Moved from Ft. Lauderdale, Florida

Moved from Middletown, New Jersey

Moved from NYC, New...