I am already using the schema's to group the tables domain wise,

so what the filegroup does ??

My DB is gone upto 5GB and it has only .mdf and .ldf files and i was thinking to implement the filegroups logic , before doing so , i was...

i am using Merge replication, and it doesn't rolling back the data that has been synchronized before the network connection was broken.

How could i Roll Back that data ?

Your quick...

I am using Merge Replication.

when synchronization was in process , i disabled the netwrok connections

then replication was stoped, but the subscription DB wasn't Rolled Back.

How the Subscription DB is Rolled...

You can get the row numbers in sql server 2005 using this

ROW_NUMBER ( ) OVER ( [ )

is this possible with sql server 2005 ?