How to copy objects like View or Tables from on SqlServer 2005 to another?

If you are talking about just hte DDL then script it out and run that script
on the other server. If you need data as well you can use the wizard in
SSIS.

Show quoteHide quote

How to access SQL Server 2000 Jobs in 2005?
One large database or a few smaller databases?
Example of binary data type in SQL Server
Help interpreting DBCC CHECKDB output
How do i block SQL browse list?
Supported TDS versions in SQL 2005
Asking for a little help with sql 2000
...unable to begin a distributed transaction
Remove Non alphanumeric
Object Browser in Query Analyzer