You get this error when there is something wrong in the io path. This can be many things hardware problems, driver issues, anti virus software etc.

There is no easy place to...

The answer is incorrect.

The statement provided

ALTER QUEUE PublicationQueue

    WITH ACTIVATION (

        PROCEDURE_NAME = new_stored_proc,

        EXECUTE AS SELF) ;

would actually set the activation status to on as this is the...

Not being funny but try reading BOL and if you then still have some problems post a psecific question and I am sure someone will be please to help.

If you...

Rick is correct bit I believe this problem was fixed in SP1 although I am using the CTP of SP2 at the moment on my dev box so it might...

Try this

http://www.microsoft.com/technet/prodtechnol/sql/2005/tsprfprb.mspx#EFRAE

hth

David

SQLExpress can only be a subscriber in the replication topology so if both your instances are SQLExpress this is not an option.

Also you would need to have installed SQLExpress with...

It would help if you could post the script it created.

David

Not really the answer you want but in sql server 2005 using database mail is much more efficient as it uses service broker and is therefore asynchronous in nature. Also...

Setting up replication through the wizards in 2005 is no bad thing but once you have created it you should script this out so that the replication can be easily...

You should do this through EM.

Here's nice we article on the MS website which explains

http://support.microsoft.com/kb/283811

hth

David

This is because someone is connected to the database. If anyone is accessing the database you will be prevented

from restoring it.

If you look in activity monitor you will see...

This article should be helpful

http://www.sqlservercentral.com/columnists/sjones/removeduplicate.asp

it is also possible to remove duplicates rows using CTEs in sql server 2005

WITH

Dups AS