Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

script generate and drop dependencies before changing collation on all tables

Hello,

I search a script to generate and drop dependencies before changing collation on all tables.

Thanks

Regards
0
bibi92
Asked:
bibi92
1 Solution
 
David ToddSenior DBACommented:
Hi,

Adam Machanic had a script I used.
http://sqlblog.com/blogs/adam_machanic/archive/2010/04/04/rejuvinated-script-creates-and-drops-for-candidate-keys-and-referencing-foreign-keys.aspx

Its not the whole answer, but a good part of it.

Regards
  David
0
 
Matt BowlerDB team leadCommented:
This also provides a pretty useful step by step of the process.

http://www.codeproject.com/Articles/302405/The-Easy-way-of-changing-Collation-of-all-Database
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now