But all other articles are getting replicated except for a couple of them. Is there something that needs to be checked? thanks

Sorry, but sometimes the response is too poor on anything other than administration and so i tried on this section too.

Just a quick question before anyone logs off. Can data ever cause a h/w failure specially on EMC machines? Reason is we had a prodn failure yday morning wherein 1 disk...

Yeah good to stay away then and help the rest of us with your great brain.thanks

Thanks Noel. Thats what i was looking for. good mind reader..

I know from sysobjects you get all tables where xtype= 'U' but what i need is to know which tables are replicated and which arent.

TIA

Thanks Noel. You have always been a great help...

Heres the proc. error shows up on the lines marked in RED

CREATE PROCEDURE dbo.XXXXX

   (@rpttype varchar(3),  

   @CorrID char(4),     @prsnid char(6) = NULL)  -- for logging purposes only

AS

SET NOCOUNT ON

BEGIN

IF @rpttype NOT IN ('S','D')

BEGIN

 RAISERROR ('ERROR:...

But what if there isnt any date column in the table. All i need to check is the number of rows inserted in last 1 hour.

Thanks gusy i kneew this is indeed not diable unless you have an identity column and a where clause. BUt thought of checking up before i finally say abt this....

lets say you have 6 rows as follows. Is there a way i could get 5th row without using a where clause so that my results are EEE, 888. I know...

Thanks guys everyone did  a great jobs. thanks so much...

Yeah what if my value goes beyond 3 .'s. parsename doesnt work there. any other way to get this resolved?

Thanks you are awesome...

Noel, this result

1        

2        

3        

4        

2.1      

2.2      

2.3      

2.99     

2.100    

2.101    

2.102    

2.1.1    

2.1.2    

2.1.3    

2.1.4    

2.1.5    

2.1.6    

2.1.7    

2.99.1   

2.100.1  

2.1.1.1  

2.99.1.1 

 doesnt match up with my initial...