using sp_helpindex 'TableName' will give you the details of the index on particular table

Try with sp_dropserver and sp_addserver stored procedures

Please check the authentication mode under security. For all the linked servers, it should be Mixed mode. if the below error is logged in windows application log,

SSPI handshake failed with...

It is because the server is not able to connect properly. Check the port number and the servername (should match with My Computer --> properties --> Network Identification--> Name) in...

Try to add the server in SQL client network utility. Keep an entry for the server in C:\WINNT\system32\drivers\etc\hosts

ya.. I have changed the compatability level at database level only. I am facing this in development server only.

The database compatibility level is 90. Actually, this server act as a subscriber of another replication(let it be AB). So, please let me know if am changing the compatibility to...

Check the server name in My Computer --> Properties

Using the same name add an entry in SQL client Network Utility. (Start --> Run --> cliconfg). Give the correct port number....

Thanks Deba....

Your solution worked fine for me also...

I have changed the path in the registry. The agent is working now.

\software\Microsoft\Microsoft SQL Server\90\VerSpecificRootDir to correct path.

Thanks for all replies....

When i have run from command prompt as DISTRIB.exe -publisher<> PublisherDB [] -subscriber [] it is throwing the error "The system cannot find the path specified"

I have created the publication and then I checked the snapshot agent status, where I got the error "The system cannot find the path specified". I tried to create another...

This is the error code I obtained when I run from command prompt today

2009-12-09 11:06:51.52

2009-12-09 11:06:51.52 Microsoft (R) SQL Server Snapshot Agent

2009-12-09 11:06:51.52 [Assembly Version = 9.0.242.0, File Version =...

I checked the permissions and all. It is full control only for the agent login.

I checked the permissions and all. It is full control only for the agent login.