Try this instead:

CREATE PROCEDURE [dbo].[InsertTRIGGER](@databaseA varchar(50))

AS

BEGIN

DECLARE

@sql nvarchar(max),

@statement nvarchar(max)

SET @statement = '

CREATE TRIGGER [P62XB1].[JPDSAD1] ON...

To say it with Bertolt Brecht's words: " What is robbing a bank compared to founding a bank?" 😉

70% of Italians own the house they live in.

Well, sort of.

Who owns the house while you're paying the mortgage? You...

I would recommend SQL Server Data Tools.

It's the new development IDE for database projects that Microsoft released with SQL Server 2012 and it works with databases from 2005 on.

See here...

This should get you on the right track:

http://msdn.microsoft.com/en-us/library/ms187445.aspx

paul.knibbs (5/25/2012)

---

He did say he felt SQL Agent is more robust than Windows task scheduler, but it would be interesting to know why he feels that...I've rarely run into issues...

Not sure what you mean.

DDL can be part of a transaction:

BEGIN TRAN

CREATE TABLE test (someColumn int)

ROLLBACK

SELECT *

FROM test

Msg 208, Level 16, State 1, Line 7

Invalid object name 'test'.

Sorry to say that, but I don't think you should be using SQL Server Agent as a job scheduler if you don't need SQL Server in the first place.

There are...

What are you all talking about?

Oh, I see .... the "other" football, the one with the lousy-shaped ball. 🙂

Revenant (5/22/2012)

---

Gianluca Sartori (5/22/2012)

---

Thanks everyone for the suggestions and opinions.

If everything goes well, I won't be working as a trainer any more.

I'm negotiating a contract as DBA/DBD. It's going to...

Thanks everyone for the suggestions and opinions.

If everything goes well, I won't be working as a trainer any more.

I'm negotiating a contract as DBA/DBD. It's going to be a life...

Lynn Pettis (5/22/2012)

---

Gianluca Sartori (5/22/2012)

---

L' Eomot Inversé (5/22/2012)

---

Gianluca Sartori (5/22/2012)

---

2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me...

opc.three (5/22/2012)

---

Possibly, a good recommendation depends on a lot of info we do not have. does the app need cross-database access? does the app need access to server-level metadata? are...

Revenant (5/22/2012)

---

Yes, I did -years ago, for IBM.

I mention it because they expected, and paid, 5 days...

L' Eomot Inversé (5/22/2012)

---

Gianluca Sartori (5/22/2012)

---

2 - In every class there's at least one smartass that thinks he knows better than the instructor. So, let me ask, why did you...