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 !

both will be equal;

However, I always advise to use the join syntax because it nicely distinguishes join conditions and filter conditions.

This is especially interesting with outer joins.

BTW as of...

HTH

another reason to switch to a more intelligent solution in stead of a maintenance plan.

there are a couple of alternatives at SSC.

Ola Hallengren has a very nice one at http://ola.hallengren.com/

What about servername, instance name for your standalone server ?

Are they equal to the original servername ?

If not, you may have some issues with msdb (sqlagent), and master sysservers

have a...

with numeric data, leading zeroes do not play a significant role, so don't worry.

If you want leading zeroes in your result, handle that in your presentation layer (gui, report, ...)