Thanks Tim. I tried IP address as well (TCP://10.10.10.10\Prod:1103) and I did not get an error message; however, the mirroring did not occur. I am going to scrap...

Thanks Matt. I'll try this.

Phil,

How do I capture the results of the query in a variable so can perform subsequent business logic in my procedure?

Thanks.

Ken

Nice solution. Where would I find the .RDL file mentioned in the article?

The problem was that the SQL Server Agent was running on the publisher but not running on the distributor.

Additional information:

sp_addmergepublication executes fine.

sp_addpublication_snapshot @publication executes fine but returns this message.

sp_startpublication_snapshot @publication execution fails with this message.

Thanks for the reply.

Thank you for the reply. Would your answer change if a stored procedure was used as opposed to a function? What I am looking to do is select...

DECLARE @Cmd AS VARCHAR (50)

DECLARE @Result AS INTEGER

SET @Cmd = 'C:\DIR /P' --build appropriate command line

EXECUTE @Result = Master.dbo.xp_cmdshell @Cmd

IF (@Result = 0) BEGIN

-- Do something

END...

After canceling out of the SETUP and going into the server to check for encrypted columns, I saw the version is now 9.0.1399. Should I attempt to install SP2...

Not that I am aware of. There are other instance of SQL Server on this server, though. Posibly in one of them? Or am I only concerned...

That is awesome! Thanks.

Thanks Ramesh. This part I am Ok with. It is the SELECT in the anchor recursive sections that I am having trouble with.

Thank you. Is it possible to include it as a column in the table returned or does it have to be returned on its own?

Thank you. The overwhelming trend seems to be to do this at the client level.