Thanks for the ideas Sean and Lynn. I'm actually helping another DBA. There are a few other requirments such as stripping out some characters and he wrote a...

Sure. A client wants it that way. They want a CSV file with the contents of a view and they say they need the first row to be...

I have a resolution. I was able to get the import to work with the SSIS import wizard. Thanks for the help.

I thought I needed the format files because my data file has columns from two tables. I need to tell import #1 to handle fields 1-54 and ignore the...

I have not tried BULK INSERT yet. You can see, my export query requires a SELECT * and a join so I must do two imports to handle the...

Thanks again for the suggestion. I now have all errors ironed out but that leads to another question. When I run the IN command to import the data...

Thanks. I will be trying that. And that would not require a format file would it?

I don't know the answer to that. If I remember correctly a rebuild index maint plan step will rebuild all indexes regardless of their fragmentation. Have I got...

In my experience, a 2005 ALTER INDEX REBUILD ONLINE will fail if it finds a LOB column. I have a script that checks alloc_unit_type_desc in sys.dm_db_index_physical_stats to decide whether...

I support the databases behind web-based banking apps. We have a weekly maintenance window on Sunday morning from 00:00 to 06:00. But it's mainly for making changes to...

Thanks. Have you used it on a Win 2003 server running SQL? Just want to ask since you say "Win 2008 for sure."

Thanks for the thoughts. Yes, I realized 2012 RTM was out after I posted my message so I won't be messing around with RC0.

Thanks for posting this. It's exactly what I needed today.

Thanks for the ideas guys. I had in fact unpinned the tab. But it sure seemed invisible yesterday even after closing and opening SSMS. But this morning,...

Yes. All the View options work (object explorer, object explorer details, utility explorer) except for registered servers.