paul.knibbs (2/2/2012)

---

As a set in my ways C programmer, I find it irritating enough that SQL overloads the = operator to mean both assignment and a test of equality (I...

Sheesh...and I thought I was a pedant. Really guys, is this not straying off topic? 😉

I am a developer and am here to improve my knowledge of SQL Server especially my T-SQL

As a bit of a pedant when it comes to coding, I read the...

I used the following:

try

{

# Open Connection to Server #

$conn = New-Object System.Data.SqlClient.SqlConnection "Server=$s;Database=$d;Integrated Security=SSPI;";

$conn.Open();

#...

I think you are trying to utilise two different error handling mechanisms/techniques. Only one can "win" thus you end up with an Either/Or situation.

Can you not achieve this by placing...

Jeff Moden (1/25/2012)

---

Nicely done.

Shifting gears a bit (and no implications about...

TravisDBA (1/23/2012)

---

This is exactly why I have never given developers sysadmin access to either the servers or the databases. Unfortunately, I have been overridden on that a couple of times...

L' Eomot Inversé (1/23/2012)

---

When is something "jiggling" (bad practise) rather than "experimentation" (an essential component of research)? When I'm learning something new, I play with it to see what...

Agreed with all. Sometimes you have to research through experimentation but the key difference is the output of any such experimentation:

Output: Knowledge - This is research and is a invaluable...

I am always amazed when people (a minority - I hope!!!) post on forum (it happens here) looking for a script to use in production. From the way some of...

GSquared, I concur!!!

I went back to University after working as an IT professional for 2 years. I got a job in a bar, not unusual for a student, but it was important...

Thanks for sharing!!!

The only way I know is to kill the process and I would NEVER recommend doing that as a standard procedure.

Sorry that I can't be more helpful.

It sounds as though they are console applications as opposed to Windows Services. If so, I assume that they are waiting for a keypress from the console that launched them....