How intrusive (or permormance affective) would it be to run SQL Profiler for the entire day to capture SQL Objects name?  I am not sure if its going to affect...

I have done similar to what Sam has done, but I am not using SSIS, instead I am using BULK INSERT.  I have everything in one proc :

1. open a...

Actually this was a great help. I was looking for same thing. Thanks.

Great scripts.  Very useful. 

Thanks

Vipul

Thats not good. I liked the idea of using DR machine for reporting purpose.  How can we achieve the goal?

I agree with above post. There are three correct answers.

sp_tableoption N'Employee', 'text in row', '2000'GO

sp_tableoption N'Employee', 'text in row', 'ON'GOsp_tableoption N'Employee', 'text in row', '2000'GO

sp_tableoption Employee, 'text in row', 2000

But...

The files were fine.  I was able to attached it fine.  Only thing I noticed a problem in a product.  My generate script for missing objects doesn't include the file...