CraigIW (2/6/2012)

---

ALZDBA (2/6/2012)

---

as always, it depends 😉

- Can your need be solved using backup ( of prod ) and restore ( to report env ) ?

( one should...

as always, it depends 😉

- Can your need be solved using backup ( of prod ) and restore ( to report env ) ?

( one should be able...

EdVassie (2/6/2012)

---

Don't forget that if you are running on Windows 2008 or above, ther are useful performance benefits from having one MSDTC instance per clustered node if you are running...

Question to pose is:

- Why would you ignore a duplicate key ?

- is case sensitivity needed ? ( does it matter ? ) ( and would you want it only...

Always HTH.

Whatever you do, make sure you start with the appropriate upgrade adviser !

SQLua.exe can be found in the feature packs.

ref: Using Upgrade Advisor to Prepare for Upgrades

keep in mind the sql server errorlog file is archived ( to errorlog.1 ) every time sqlserver starts or one performs a cycle errolog.

Chances are you only got to see...

- did you disable connection pooling ?

- Could it be your tools are using an "auto refresh feature" every 10 seconds ?

e.g. like used with "job activity monitor" ?

maybe this article can shed some light on the topic for you ...

http://www.brentozar.com/archive/2011/12/consulting-lines-pilot-dog/

no ehum yes, well maybe.

Quorum with mirroring means it can connect any of the mirroring members to each other or one of the members to the witness.

Have a look...

Take control over your proprietary error codes and declare your own messages ( and alerts if needed )

Have a look at sp_addmessage in BOL:

exec sp_addmessage [ @msgnum = ] msg_id...

Jeff Moden (1/30/2012)

---

GSquared (1/30/2012)

---

Personally, I consider this pattern of data auditing to be more harmful than helpful. It gives the apparency of auditing without the actuality of it. It does...

here's another free sqlagent job visualizers 😉

http://www.idera.com/Free-Tools/SQL-job-manager/

maybe it can get you started on our quest...

To elaborate a bit on Pauls script ...

SELECT

t1.id,

t1.value as Val1 , 't1' as source

FROM @test-2 AS t1

WHERE

...

just to add to the previous comment...

The order by, used with a union(all) select can only perform its operation on a column that occurs in the select list !