Thanks a lot for your answer.

The point is that the error was one test to can simulate the error that people return to me when executing the DTC syntax.

In this...

Thanks a lot for your answer, in the future i'll consider this post.

Regards,

JMSM

Thanks everybody, the solution was as follows:

Regards,

JMSM 😉

use master

go

grant select on master.dbo.sysperfinfo to {username}

go

grant execute on master.dbo.xp_sqlagent_notify to {username}

go

grant execute on master.dbo.xp_sqlagent_enum_jobs to {username}

go

grant execute on master.dbo.xp_sqlagent_param to {username}

go

grant...

The database is in Simple Recovery Model.

How can i put in 'pause' any transactions that are running to shrink the log without impact with database performance? Is this possible?

I've done...

Hello,

The SP in the SQL 2005 is SP2.

Regards,

JMSM

Sorry........ rename the .zip to .msg

Thanks and regards

JMSM

Thanks for your answer, but i've got three other question that i appreciate if you can ask me.

Q1:

Why when i've changed the query the one that is write down...

Thanks everyone.

Regards,

JMSM

Thanks a lot everybody.

Regards,

JMSM

Thanks a lot Jeff.

Regards,

JMSM

Thanks Paul.

Regards,

JMSM

Thanks a lot everybody, the solution was change the password of the user sqlserver_agent_proxy, the password was very strong and SQL Server didn't work fine with this password.

Thanks and...

Hello,

The point is that i've that account created but i dont know how to use it to permite other users to execute xp_cmdshell

Regards

JMSM

Hello Tommy Bollhofer,

We forgot that we need to run this feature for SQL 2000.

Can u help us?

Thanks and regards

JMSM

Hello again everybody,

But hope u can help me again.

As u say Tommy Bollhofer i see the link that u send me but i don't understand some of this points.

My...