Solved

script generate and drop dependencies before changing collation on all tables

Posted on 2014-01-08
2
246 Views
Last Modified: 2014-01-17
Hello,

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

Thanks

Regards
0
Comment
Question by:bibi92
2 Comments
 
LVL 35

Expert Comment

by:David Todd
Comment Utility
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
 
LVL 9

Accepted Solution

by:
MattSQL earned 500 total points
Comment Utility
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

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now