Oops! I just need to add brackets:

 

IF NOT EXISTS (SELECT * FROM ::fn_get_sql(@who_sql_handle))

UPDATE  BLOCKS_HISTORY

SET who_sql = 'NOT AVAILABLE'

WHERE  (dt=@dt) and (who_sql_handle=@who_sql_handle)

ELSE

UPDATE  BLOCKS_HISTORY

SET...

Hi!

Various college jobs, trainer of computer courses/network admin, network admin -> DBA!

I really like my job!

quote:

---

How do you want the users to start the jobs? Are they going to have Enterprise Manager installed?

If you have...

2s_popovski:

Greate args. Thanks!

quote:

---

I might be tempted to build some app or job that will read the msg from a table and then send it...

Developers guys need it to send a message to MSMQ.

quote:

---

Do I consider the above values very high since ... disk queue > 2

---

As...

quote:

---

But if you only have one Controller then a seperate channel is advised.

---

The RAID1 (with...

This is what I did for my stored procedures, used in multiserver jobs:

I created a publication, named multi_server_procs and replicated it to other servers with snapshot replication. When I...

2alzdba:

quote:

---

I've build a workaround to achieve this by having the users raising an alert. SqlAgent then reacts to that alert...

quote:

---

Missing a hyphen in from of outputverbose - maybe just a paste error on post?

---