If you really need to go down the route of changing the collation of your database, maybe this utility can help:

http://www.codeproject.com/script/Articles/ViewDownloads.aspx?aid=12753

It was a lifesaver for a sql2000-to-2008 migration...

It seems to me that schemas need to be part of the initial database design and will be used mainly for larger databases that need a formal design phase.

Many...

What were you trying to do at the time?

If it was when opening a file, then read on:

I used to get this a lot when running SSMS via "Run...

I took a slightly different route. After a few basic HowTo exercises from the Web I worked my way through "Windows PowerShell in Action" and found it very enjoyable. Of...

Producing and refining a mock UI up front is invaluable, but be careful to manage user expectations. For many users the UI is the application and they may not understand...

For a single database this codeproject solution (updated for SQL 2005) may still be worth a look:

http://www.codeproject.com/KB/database/ChangeCollation.aspx

Of course we care - well done!

I admire your self-confidence but (with apologies...

Same here. As a "lone developer" I value sites like SqlServerCentral and StackOverflow...

PowerShell is built on top of the .NET framework. I expect that Powershell will take off as a management tool / API of choice for managing SQL Server, in the...

Apart from creation dates, I tend to use default constraints for bit flags, like this:

Active bit NOT NULL DEFAULT 1

When used in this way, a new record begins life as an...

I can see one possible benefit of the MCA program:

With the release of Visual Studio 2005 Mcrosoft is has begun to address the development of enterprise-level applications and systems. No doubt...

Check this out:  http://www.theregister.co.uk/odds/bofh/

After several redundancies in the eighties I decided to strictly separate my social life from my work life, in order to provide continuity in one while coping with problems in...

Same here. I dont mind ads as such, but for me personally anything that moves/flashes completely dominates everything else on a page - just as if someone is screaming into my ears....