Updating as a function....probably not very efficient for large data sets...

--test table creation

CREATE TABLE TEST (c1 varchar(128))

--dummy data

insert into test (c1) values ('0154 6548647 11235')

insert into test (c1) values ('0154...

What kind of output are you looking for?

declare @string varchar(500) = '1564 163546 10352 124 142587'

declare @nSpaces int = LEN(@string) - LEN(REPLACE(@string,' ',''))

declare @i int

while @nSpaces > 0

BEGIN

SELECT @i =...

This has something to do with UAC I guess. I can reach local cluster information in an elevated powershell session..

That was it. Awesome, thanks!

Turning off Remote DAC causes both apps in question to fail to connect entirely. This only occurs from my machine. I checked firewall rules, no luck there. ...

Yeah, I appreciate the response. The servers are using dynamic ports, so that is not the case. Additionally, I've noticed another 'application' (a series of powershell scripts) I've put...

Can you change the service account?

Did you create additional filegroups? Did you create extra files and add them to the primary FG?

Disregard, user error. I had been tinkering around with script() functionality, but never changed my ps script back to querying the database.

Yes definitely the quickest. OP, are you using mixed mode authentication or strictly Windows authentication? I'm having issues with SQL logins and the encrypted passwords becoming corrupt. ...

I'm working on this problem as well. The reason this does not work is because the output from both stored procedures are different.

sp_helpdb outputs its results to...

here you go:

http://support.microsoft.com/kb/918992

The developer edition is identical to Enterprise edition but with different licensing requirements and costs.

You can migrate a database from 2008 to 2008 r2, but not the other...

So this system is a vast modular monitoring system. The odd thing is that many of the other modules work totally fine. I added some logging to this particular...

Got it

$RecoveryModel = "$($DatabaseObject.RecoveryModel)"