How to Generate Script From Database with Where Clause

whats the error?

I feel that you are hitting the SSMS limitation 

check the TOOL menu--> Option--->Query Result 

Mukesh,

 

You can try database à tasks à Import Data --> [then choose source and destination] --> [write a query to specify the data to transfer] option à then write your query with filter [ where Id=12345].

 

Thanks. 

Hello

 

For generating script from db , there is a way like all data or nothing 

 

But you can try below link :

 

http://agilebi.com/mcole/2011/04/04/how-to-generate-insert-scripts-for-existing-data/

 

Thanks