I'm sure there must be a topic on this forum about this but you can also try this link:

http://vyaskn.tripod.com/moving_sql_server.htm

If you know few things about ASP, it's not very dfficult. You can also do it in PhP. You can find many examples on the web. All you need to...

In our company we have many distribution agents, so it's very dificult to manage through alerts. For example, if SQL Server Agent is down it can't send alert. So we...

You simply can not detach a database if it is published.

Thanks for your answers.

I can't just let the password unchanged. Too much personel know it and even if I disable the option "Log on interactively" they still can access...

How can I just stop replication? Disable publishing?

When I have 130 subscribers this is not a solution!

I'm interested although in your method.

Maybe they thought that only a service could run a scheduled job. I think you could use Windows Scheduler and run Profiler with some parameters.

Replication jobs have the category name starting with "REPL-", so its easy to sort your jobs by category.

You could also rename the distribution jobs to what ever you like (I...

The developers sad that nothing has changed in the program that acceses the linked server. Here is what the SP look like:

exec [Database]..sp_table_statistics_rowset;2 N'Database', N'dbo', N'Tablename', NULL, NULL, NULL

Since this...

It seems nobody has solution to this problem.

This stored procedure is killing my server. It is executed every time a linked server is accesing my production database. I don't think...

Outlook 2003 is not MAPI compliant.

Outlook 2000 is.

You have to make a MAPI profile defined on your computer in order to use it with SQL Mail

If you are talking about the distribution database, then I don't understand why your recovery model is Full, Hilary.

I saw your topic. The script I've submmited should work for your problem too.

I'm waiting the webmasters to publish it.

What do you mean by "protect"? I don't understand your question.

select @@version