Hi Timber...

Hope this is not too late...

Another thing to watch out for is when you "mix" database tables and temp. tables in your queries and stored procedures, errors can result...

Hi Brandon:

Make sure you are running the SQL server service using a domain account, and not the local system account.

HTH

I think this is it. I will try the workaround. Thanks for the link, it was very informative ...

Ooops, my mistake. I will post this on the appropriate forum. My apologies for posting on the wrong location... thanks for bringing this to my attention.

Additionally, you can also use xp_cmdshell from within transact-sql if you want to use osql, as Scott earlier suggested, instead of bcp.

If instead of using a cursor to fetch into a text file, how about putting the result set to a global temp table and use xp_cmdshell to execute BCP to...

Thanks to Phil and Manoj for all the help.

I will be using sp_rename; makes life easier; no need to drop constraints. I am looking forward to compressing thousands of...

Yeah, I realized the copy part was not necessary.

sp_rename interests me. I wonder what DBCC RENAMECOLUMN does behind the scenes. Does it do anything about the data? or system...

Hi Phil:

Thanks for the reply. I think in writing option 1 that is what i was trying to achieve.

Currently, I am doing option 1. I could just rewrite it...