Hi David,

Thanks for the quick help. This solves my problem

Regards,

GB

Hi All,

I can understand this problem may belongs to some network devices. But why every thing goes fine when I restart the SQL Server Service only (NOT THE SERVER ITSELF)? Furthermore,...

Hi,

My problem solved by doing this:

1) CHECKPOINT

2) sp_repltrans (i got some pending records)

3) EXEC sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0,    @time = 0, @reset = 1

4)...

Hello Asim,

Sorry boss for this late reply.

This is a nice trick to resolve this but SQLRS must have some native way to achieve the same. I think we can anything...

Hi All,

Before posting this Q, i've done all such routine inquires like: event logging, pinging, map-sharing and even i'd restarts my client stations. But the only way to resolve this...

Hi,

Even I'm very happy using drop/add trick. But changing the ordinal position doesn't look good when you see your table like your main field is lying at the bottom/most RHS....

Hi Gordon,

This can be a big missing element in Sql2k Server and I don't want that drop/add trick even-though I've not used * anywhere. What about Sql2k5 should we hope...

Thanks Sushila,

I've found the reason of this problem, actually I'm using a user-defined function in my derived query, also i'm using SP3. This is a bug in SQL2k and it's...

Thanks all,

Finally I successfully took backup on remote location by mapping a drive from Sql server. But initially when it was taking backup on network, the server got lots of...

Thanks Hanslindgren, indeed your suggestion is the needful solution of my current problem. Now I'll will do these things:

1) From now, I'll create small tables for each month (with m...

Yes this is exactly I want, but should I wait for Sql2k5 due to easy administration and a new way to implement it - TABLE Partition including the consideration of...

Exactly, how constraints will gonna work? This I don't know at the moment, let me try this on some sample database to get some results, but about performance, as Chris...

Chris, please guide me about partition on replicated data? Now is it possible to segregate data after its being published?

Govind

Yes, this will solve my problem but... My database is merge-replicated and It will take longer to re-create my subscribers. And dropping some table will be... but I'll try this.

Thanks...

Because I have queried those big tables directly by their name, I've not create any view as wrapper against them. So it will cause lots of code + stored-procedures changes....