i have a table for cities and data which has entries in LACS , now i want to copy that table from one database to another, is it possibe ? i googled but couldn't find reliable solution mean i have fear to loss data .s o anybody , plz suggest me a way to copy . thanks
Sure you can. If your user has access to both databases then you can just use a query (after creating the same table on the other database). If you don't, just make a backup with SSMS and restore it on the other database.
Simplest way is probably in SSMS, right click your database, select Tasks, and then Generate scripts.
If you're in one of those predicaments where cls.__private attributes just aren't enough since they can easily be accessed through inst._cls__private, and you need something a little more secure, here's ...