Thanks Keith for the reply.

I tried querying the default trace log but endtime column only has null values. I have the start time but no data in the endtime. Am...

Thanks for the reply,

All the databases are on the same instance and list of tables are different in all the databases. The thing I am looking for is lets say...

Hey Lowell,

The copy worked but I am facing new problem with the object that is being copied. I have user defined data types created and I use them in the...

Hey Mark,

Thanks for the reply. If I use non SSIS task, I can either use Sql Import and Export Wizard or use SQL scripting for copying the data. If I...

Thanks Lowell,

It works great and I think this is the option which will create multiple copies with less work unless someone else has better ideas than this one. I did...

thanks Lowel for all the help.

Thanks Lowel,

I will probably have to do the generate scripts for creating DDL Scripts. But I need to have all the schemas in the same Database, so the second option...

Thanks Lowel,

But I have lot of tables and lot of data in the tables with lot of dependencies. The process you suggested was used once and it took a lot...

Thanks Guys,

For all the replies, so finally I would say the best way out is still script the objects out and run it in all the schema's. I was trying...

Thanks, I cannot separate it out to different DB's but I posted a reply. Please read and let me know if you know of any other ideas

Thanks for all the replies,

I already proposed all the things which were mentioned like, separating each schema into separate database. They don't want this to be done. They want the...

Hey Guys,

Any ideas?

Thanks for the reply,

I need to copy this as we need to create this for 30 counties, so I need to have 30 copies at one point of time. So,...

thanks a tonn for that reply, also is there a system table where I can find the same information??

thanks,

Nick

thanks jeff