Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

script generate and drop dependencies before changing collation on all tables

Posted on 2014-01-08
2
Medium Priority
?
281 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
ID: 39769851
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 10

Accepted Solution

by:
Matt Bowler earned 2000 total points
ID: 39778201
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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are some very powerful Dynamic 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 di…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

971 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