your sp_stop_job procedure ends normally.

So, your next statement is still executed in the "begin try" part.

Declare @rc int

BEGIN TRY

print 'start'

Exec @rc=msdb..sp_stop_job 'yourjob'

if...

We receive many "sspi handshake failed" at dns-server reboot time (win 2003 domain). transparency with secondary dns servers doesn't seem so transparent after all 🙁

another alternative might be

SELECT *

, ROW_NUMBER() OVER ( ORDER...

- What's the actual error message your apps receive ?

- Can it be applying win updates on a dns server ( including reboot ) somewhere in your chain causes this...

-- removed xpost notice because Steve already pointed the other thread --

Good job, Steve

Sheer luxury :Wow:

at least if you compare it to most of us :blink:

:w00t:

gary.morey (1/24/2011)

---

I have 2 tables. The first table has a SessionID and other columns. There will be multiple SessionID's with the same value in this table.

The second table has a...

A primary key _MUST_ be unique !

none of the columns can be NULLable and the combination of all columns must be unique.

Can you elaborate a bit on your "normalization criteria"...

I already had the impression such...

Grant Fritchey (1/24/2011)

---

Based on most of the comments, I'm alone on this one, but what the heck, I'll stick my neck out.

I'm not crazy about it. I don't like the...

books online topic "FROM (Transact-SQL) " states

[ FROM { <table_source> } [ ,...n ] ]

<table_source> ::=

{

table_or_view_name [ [ AS ]...

please adjust your size settings and preview the result before posting:crazy:

enjoying star wars episodeIII for the moment. scene = the assembly of darth vader :w00t:

Michael Valentine Jones (1/21/2011)

---

I think the big mistake that beginners make with triggers is using them at all. They see them as a sort of event driven solution, and...

Lutz covered it perfectly :w00t:

Further info can be found in books online topic "Using Table Aliases"