Connection string will be a standard connection string for SQL Server. Try ConnectionStrings.com[/url] for help if you need it.

Have a search via you favourite search engine...or even search SQLServerCentral.com[/url] for...

As a developer who started with home computers to program (Vic 20 in my case) I missed the whole compile a day thing but was taught using non-IDE compilers. This...

Eric M Russell (1/10/2012)

---

The thing about querying remote tables, especially when joining remote tables with local tables, is that the performance impact of the SQL coding tequnique is critical. I'm...

As a developer who often takes full advantage of the split between developer and DBA roles (please read as a healthy respect for another's technical speciality), I like the use...

I know I am late and that maybe no-one will read this but I have to write it anyway (for self-evident reasons):

Pure Muppetry = where the reason for doing something...

You are missing the pipe to Table-Format i.e. what was line 13 for me should be as follows:

$Output = Get-WmiObject Win32_logicaldisk | Format-Table DeviceId, MediaType, Size, FreeSpace -auto

I guess I should have been more thorough in my code review 😉

opc.three (12/21/2011)

---

I imaging it is possible to do this using the pipeline with far less code but this will get the job done:

$dir = "C:\@\1"

foreach($file in (ls "$dir\*.pdf"))

{

...

I believe that your first problem is that $share is a collection. To resolve that try $share[0] either in place or by assigning to another variable. $share[0] is a ManagementObject...

No worries Jeff. I just wanted a little clarity for I am a developer of very little brain!!!

I only wish I understood more about the lack of security inherent in...

Jeff Moden (8/17/2011)

---

Heh... xp_CmdShell. 🙂 One of my favorite...

I have just tried running mine locally using the exact same command (copy & paste) in the Run box. It worked successfully so I can only think of three possible...

You might get some assistance if you specify what is and what is not working. Otherwise you are asking someone to do all of your job for you. I am...

Martin Bastable (10/25/2010)

---

Back to the scenarios - i've found myself in similar situations on many occasions.

My tips are always to document everything, keep evidence trails (and these don't have to...

giaks0wn (10/22/2010)

---

I agree that there is a substantial amount of this activity going on and I would not want to be still doing the same thing at 60 that I...