Hi Anthony,

and thank you.. thought it would be simple.. (my skills are clearly shocking :/)

and yes in way but not fully. Im trying to work out how to do...

Used the psexec guide and worked a charm.. very cool to know..

thanks for all the help

S

ohh surprisingly simple!

Thank I will give it a go now!

yeah i think it has to be the shares but i have no idea why its not working.. all ive done is

Share permissions where Everyone full control

and Security permissions...

haha

yeah... that seems to do it as well!

thanks.. 🙂

Hi Bruce and Thanks!

Went back to the text file and found i had a blank spaces after the servers that werent being picked up.

Cleaned all that up and...

Just a note. If i run it directly against one of the boxes it fails on it works.. IE:

$property = "systemname","maxclockspeed", "numberOfCores", "NumberOfLogicalProcessors"

Get-WmiObject -ComputerName Server03 -class...

Hi,

Not sure why they implemented it, but yeah it don't work in SQL,

Soon as i changed the group to MSSQLGroupName i was in and working.

Lesson learned!

Thanks...

Hi,

thanks for the reply.. Good to know that its a expectable way of doing things..

I plan on doing a restore of the database. But when i right click...

hi thanks for all the links 🙂

currently using a combo of powershell scripts i can find online, SCCM, sqlcmd and just plugged in MAP to see what that brings...

yee gods man,

im playing around with sql and lightswitch trying to pick up some dev skills (clearly just beginning), as just working though books isnt doing it for me.....

Welsh,

While im thankful to any replies to my questions, and i have apologised for not asking it in the "correct" manner. Please.. please feel free to never reply to...

Hi Chris,

Thats got it working! thank you,

Welsh Corgi sorry for not explaining myself very well, I shall follow your links guide from now on.. Your free to breath a...

ohh sorry i was using your examples!

read the links when you replied.. Sorry for not adding them before :unsure:

hi,

so first attempt:

UPDATE UpdateCol2

SET col3 = col1 + " ," + col2

I get

Msg 207, Level 16, State 1, Line 2

Invalid column name ' ,'.

--

Then i thought maybe use...