i get this error when i create new database

Msg 3609, Level 16, State 2, Line 1

The transaction ended in the trigger. The batch has been aborted.

Thanks guys.

i tried to find another way to resolve this issue without SQL Agent Job.

not that i have anything with SQL Server Agent jobs but it did try to find...

this is exactly one of my problem that i want to resolve by backing up newly created database on creation.

THX.

this was my thought too,but i was try to avoid the sql agent job for the check and backup.

i'll give it a try anyway.

I'm talking about backing it up once on creation automatically.

THX

yes i know.

but still what are my options of automatically backup new created database.(can't do it on the ERP that create the database)?

THX

I'm responsible for lots of SQL Server that have an ERP Program and this ERP program every few days creating new DB (companies) in the SQL.

i don't want to go...

no it's only from server 0 to server 1.(server 0 is the monitor server too).

Hi,

i use the latest script post and i get this error message

Insert Error: Column name or number of supplied values does not match table definition.

all my servers are Collation Binary...

Thanks for your replays.

i'll try to talk with the ERP developer.

in continuing to our discussion , i've a query that run for 34SEC.

if i remove the exec sp_executesql and fill all the parameters like in the query it run in...

THX.

thanks for your replays.

i can't touch the query because it come directly from the ERP(Priority).

can i do something else (beside DTA)to check this query to get better performance?

THX

I've a performance issue with some of the queries so i want to run them in the DTA,but the DTA can't run the query like that.

can i capture the query...

Hi,

every thing that you need to know is writing in the script details.

but for you i'll write it again.

this stored procedure move the LDF or MDF files to a new...