Thanks, Naomi. That's a great post and is very useful. I'm sure some of the information there will come in handy in the future.

( BTW, for anyone who does SQL who is not familiar with lessthandot.com I really recommend taking a look. Besides Naomi's contributions there are some great articles from a range of experienced SQL people, including Denis Gobo ( sqlDenis ) whom I had the pleasure of working with when he was our DBA at Dow Jones )


>I think you can get ideas from this blog post
>
>http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/how-to-get-information-about-all-databas
>
>
>>How would I create a single script that would do an alter table on every table in a database (over 100) changing the datatype of every column that is char(36) to uniqueidentifier?
>>
>>I'm thinking sp_msforeachtable but the logic after than is based on a columns data type ...
>>
>>And while I'm asking, then make every column named cid ( and uniqueidentifier) the PK
>>
>>(okay that one may be able to do with sp_msforeachtable)
>>
>>(this is part of a conversion of VFP/VFE data and is going to possibly be needed if I can't figure out how to hack the Sedna upsizer to recognize C(36) NOCPTRANS as a uniqueidentifier.
>>
>>( And yes, I probably will explore grabbing the data from the SQL side with SSIS but I'm not sure that will be any easier - isn't there an issue with memo fields?)
>>
>>TSQL gurus, your help appreciated.