Many thanks ALZDBA for all your help.

Many thanks ALZDBA,

It is valid for me to update SQL Server services.

But the procedure is the same to update MS DTC service?

Thanks.

Thank you for your response Dan.

The main difference between the development and production server is that development is only the database server while the production server have installed many other...

Many thanks to all for your help.

Hi Lowell,

Suppose you have the next scenario:

Suppose that you have web application with a main screen to buy cinema tickets. In this main screen you have to select the next...

I put blank password 'MyUser' login on both servers and now the dynamic query works correctly.

But for security I need to put a password for that user.

Could anyone tell me...

Hi,

Comment that i already set up a transactional replication between the server where the stored procedure 'P1' is and the server named 'MYDBLink' and it is running very fine.

The...

Hi Adiga,

Many thanks for your help.

Ok, thanks for your help.

Yes, i'm sure.

Ok,

Thanks for your help.

Hi SSC,

It is very interesting script to backup databases but this action already is doing correctly with my SQL Server maintence plain who is using SQL Server 'Back up Database...

Thanks for your response SSC, but unfornately it is not valid for me.

For example each time i add a new database to my SQL Server instance i have to update...

Hi,

I've identified the problem but i dont know how solve it.

If I open two MS-DOS window and run parallely on each of them the next commmands:

...

Thanks all for your help.