No problem. 😉

In many cases production continuity is more important than going for the bug.

However, if this re-occurs, you may have to invest time to figure out why it stops...

How about some feedback, so others can your this thread as a ref.;-)

If that one is free on your server, that should be ok.

However, I must admit, I haven't found a list of "reserved ports" yet.

There must be some kind of convention,...

Also keep in mind there may be some firewall configuration stuff to perform on both sides !

(allow the port numbers)

Paul White NZ (12/13/2010)

---

OMG there's a guy called Dr Seward, who has a free eBook called:

"Gila Monster Propagation"

I have not yet summoned the courage to hit 'download'...

edit: ok so I...

SSB is something you need to prepare !

Make a checklist and tick the items you actually perform, as you do it !

Off course, Adam Machanics articles are wonderful, and I...

- So, do your apps still receive deadlock errormessages ?

- can you enable the traceflags to write the deadlock info into sqlservers errorlog ( 1222,.. ) ?

dbcc traceon(1222, -1)

btw todays...

Steve Jones - SSC Editor (12/12/2010)

---

Tom.Thomson (12/12/2010)

---

Steve Jones - SSC Editor (12/11/2010)

---

Excellent response from Lowell and Gus.

Tom,...

I would suspect some malfunctions in your SSB environment and start SSB debugging actions.

- did ERRORLOG indicate a queue shutdown or something you can link to event notifications ?

- have...

with 32-bit, it was restricted to 1,7GB by default. One could even use a /3GB parameter at OS level, to have it consume up to 3GB.

Now, with 64-bit, the OS...

there are a couple of nice articles regarding SSB at SSC too.

A simple walk trough I've written can be found at:http://www.sqlservercentral.com/articles/Service+Broker/2897/

There is no need for a clustered index to be unique !

However, if it isn't unique, sqlserver will "uniquify" it for you by adding a 4-byte part to it.

The clustered...

Is this a named instance or a default instance ?

IMO it should be doable for a default instance, provided you follow the "rename server" procedure sequence after you restored the...

IMO you should split your @consultants string using another split character !!

Your data contains a comma, and your current split function is called using a comma as split character, so...

sql2008 uses compression to ship log records to its mirrored dbs.