Based on BOL:

NEW_BROKER

Specifies that the database should receive a new broker identifier. Because the database is considered to be a new service broker, all existing conversations in the database are...

Well BOL says:

A TRY…CATCH construct catches all execution errors that have a severity higher than 10 that do not close the database connection.

So it should work..

I just thought of this.....

Well that does present a problem.. And it won't respond to a try/catch block..

When you run it outside of agent, what severity does it give for the error, because...

I don't think you can have more than one MSDTC on a machine, even a clustered machine.

I would also question the additional instance. Are you going to an active/active...

Change the job step to continue to the next step in case of failure.. succeed or fail the next step runs..

And that was the question I was going to...

So the SQL Server is local to the web server? If so then NONE of those protocols would/should be used, it should be using shared memory.

How you...

seandeyoung-1145978 (11/12/2009)

---

Hello everyone,

I created the below sp but when I run it the output is "Sqlcmd: '-S': Unknown OPtion. Denter'-?' for help"

code snippet

CREATE PROCEDURE sp_eSiteProductionArchive

AS

EXEC master.dbo.xp_cmdshell "sqlcmd –S SQLSERVER760\MSSQLSERVERTEST -E...

Alright then no problem..

CEWII

I would be sure to test the performance penalty to do this.

I'm curious what is so important about the statement instead of the results of the statement..

CEWII

You can probably use fn_get_sql if you have SP3 or higher.

http://support.microsoft.com/kb/325607

CEWII

j.a.c (11/10/2009)

---

Ah technical debt... my group has it... lots of it that we are only starting to pay back.

We do unit tests for most things and they are very useful....

pruello-1014825 (11/10/2009)

---

Elliott, I saw the SQL Audit functionality but it's only available in the enterprise edition. As we only have the standard edition here, it's not helpful for us by...

First of all Jeff's stuff made me laugh, he is right on track. Unit testing is absolutely critical, especially as the code gets more complex. I test the...

You might try a script task NOT the ActiveX script. You would be running .NET instead of ActiveX script.

CEWII

Long ago, ok like a year ago.. I built a SQLCLR TVF to do this, and it was FAST! Other than that xp_cmdhsell is about the best. ...