How To Backup Database In Sql Server with 100 records each tables?
I want to backup sql server database with all the objects along with data but data in all the tables should be limited that is 100 records each tables. I can do this in mysql very easily but in sql server I don`t know how to do??

Please help me out.

Thanks

Nitesh Kumar
How To Backup Database In Sql Server with 100 records each tables?
===

I want to backup sql server database with all the objects along with data but data in all the tables should be limited that is 100 records each tables. I can do this in mysql very easily but in sql server I don`t know how to do??

Please help me out.

Thanks

Nitesh Kumar