While I was in college, I believed that anyone could work in IT.  All it would take is study, experimentation, and hard work.  And after...

Either way will keep your database in a consistent state (i.e. roll back the transaction).

I forgot to mention, you've got the option to use sp_stop_job.

Run sp_who to get the spid of the job.  Then run kill spid

Yes.  Use the "Execute SQL Task" and make sure it uses a connection using the appropriate server and database.

No Stephanie.  Believe it or not, there are actually people in the world that WANT to do the right thing.

Anyone that has to ask, "What's the right thing to do?" has a problem with their moral compass. 

If you agreed to the terms of the sale, you honor it. ...

It wasn't me

I didn't do it

Looks like we've got another one:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1243

May want to nip this in the bud before it gets out of hand.

Harsh?  I sure hope you never had to go through boot camp...

A simple statement of fact: Pre-RedGate, I never noticed anyone retracting posts.  Post-RedGate...ONE.  I just hope this isn't a...

My point is this:

Regardless of policies, misunderstandings, anonymity, or accusations, the RedGate buyout has had an affect, albeit small at this point. 

I have found SSC invaluable in my job...

Show me where I can get the source for the Script-O-the-Day dated 1/26/2007 on SQL Server Central?

The sad thing is, in the short few weeks since its purchase by Red-Gate, SSC is already starting its decline.  I noticed the Script-O-the-Day contributor for 1/26 withdrew his/her script...

Yes

Try using DATEADD(ms,-1,your_date)