I would get the required data that needs to be kept into a new table and rename that with the original one.Once i make sure verything looks good would drop...

The best i would do is select the rows that are to be keptin a new table and rename the old one to someting and rename the new one to...

Thanks Derek for your response. I tried the UNC path but for some reason the subscriber was not able to connect to the publisher. It tried to reconnect but ulimately...

Thanks Derek for the reply,

Yes we have both the Distributor and the Publisher on the same box. Can you please eleborate the UNC path, how it should be done on...

Since we were unable to find the Distribution Agent we tried to re create the subscriber abd then we were able to see the Distribution agent. Do you know why?

MK

I am looking on the computer which has the Distribution database.

MK

Thank you Once Again Allen, are there any KB articles for this.

Thanks,

MK

Thank You for the reply Allen.

I Want to keep the second node intact while rebuilding the OS on the First node. Once the rebuild is done I want to bring...

Hey Neil,

Hope this helps...........

DECLARE @a INT, @b-2 INT

DECLARE C1 CURSOR FOR select catalogid, odQuantity from oitems where orderid = 123456

OPEN C1

FETCH NEXT FROM C1 INTO

Can you post the query which you are trying to use.

Make it a Dynamic stored procedure it should work...

CREATE Stored Procedure My_user_sp

@Search_Parm VARCHAR(100)

AS

DECLARE @SQL VARCHAR(3000)

SET @SQL = 'SELECT

User.fields_i_want

FROM User

WHERE

User_id IN...

Try this ...

SELECT '''Group1'', ''Group2'', ''Group3'''

MK

If Index is the problem than droping the index on the view and recreating it after inserting the data should work right.

MK

Hey Julian, thank you for your input, Can you give me a example of the full text search.

Thanks,

MK

Thank you Aaron for your help.

MK