This should do the trick:

DECLARE @code_positions nvarchar(max)

DECLARE @column_names nvarchar(max)

DECLARE @sql nvarchar(max)

SET @code_positions =

STUFF

...

I'm sorry, you need AD and DNS to build a cluster.

I can't find a MSDN KB to point you to, but I'm sure it is so. Try google that...

bitbucket-25253 (4/7/2011)

---

In those days the TV tubes were round and covered with a rectangular frame. To change channels you turned a dial, remote controls, the only remote was me,...

Crap! I hit "quote" instead of "edit".

Stefan Krzywicki (4/5/2011)

---

Gianluca Sartori (4/5/2011)

---

Stefan Krzywicki (4/5/2011)

---

I have no idea what that...

Fred + Ginger?

Another one: http://www.spiceworks.com/free-sql-server-monitoring-tool/

There's also Idera SQL Check: http://www.idera.com/Products/Free-Tools/SQL-check/

There's always Nagios. With some plugins you can monitor the most important metrics: http://labs.consol.de/lang/en/nagios/check_mssql_health/

Very far from paid products, anyway.

kstjacques (4/4/2011)

---

If you have a windows administration team, you should inquire if they are using SCOM to monitor the windows environment. If they are, you can ask them to...

You could try Red Gate's SQL Monitor:

http://www.red-gate.com/products/dba/sql-monitor/

Glad I could help.

Neither does Chrome FYI

msdb.dbo.sp_start_job just starts the job, but doesn't wait for it to finish.

If this is the behaviour you want, you will have to code some procedures to do this.

I do this...

I hope I'm not offending anyone, but... have you checked this from SSMS? I'm sure you're aware that newline chars...