I had to add COLLATE Database_Default, in order to get it to work.

As in:

/********************************************************************************************

*

* Author Rafal Skotak

* Purpose Created view displays all text columns' collations in the current database,

*...

Josep,

A Very nice script. Very useful.

I've added 2 features:

a) to have a MOVE xx to yy clause, so that the files can be restored to different drives/directories.

b) Stats=1, so...

Francis,

Thanks for reminding me.

Henrik

Kenneth,

I work in a place with over 13000 employees, and 700+ h/w & s/w developers.

Naturally there are a lot of SQL installations.

The listed ones are just the ones that my...

Kenneth,

Thank you for bringing this to my attention.

Nice way to test the solution.

We have these collations

Danish_Norwegian_CI_AI

Danish_Norwegian_CI_AS

SQL_Latin1_General_CP1_CI_AS

SQL_Scandinavian_Pref_CP850_CI_AS (the only problematic, as far as I can see)

Latvian_CI_AS (the next one on...

Noel,

But it requires room for two copies of your database.

Our main database (at our biggest site) is about 800 GB, so having a backup ready at hand, and an additional...

John,

>>Be warned that if you change...

Which is exactly why we want to change the collation.

We upgraded a lot of databases from sql 2000 to sql 2005, and the tempdb no...

Kenneth,

Hurraaaa. 🙂

Thank you for testing, and sharing.

Henrik

Noel,

Are you saying that "ALTER TABLE xx ALTER COLUMN yy COLLATE zz" does not change the data in the table, that it only changes how the table appears to the...

Hi Kenneth,

My colleague has written the script in order to invalidate the "old proven" way.

We have tested it on our database, but have not had the currage to go live...

hi,

This only change the collation on the database, not the objects in the database.

Best regards,

Henrik Staun Poulsen

http://www.sql.udstyr.com

here is a small enhancement that will make it show more characters on a SQL Server 2005 box.

USE vdc

exec usp_DeleteIfExists 'dba_ShowCodeLine', 'STORED PROC'

go

CREATE PROCEDURE dbo.dba_ShowCodeLine

(

@SPID...

Here is my suggestion.

Tested on SQL Server 2005, with sp_send_dbmail instead. Tests all drive letters.

SQL Code only:

--Author : Addanki Reddyprasad

--Usage : According to threshold value the respective person will get...

Wayne,

Thank you for your suggestion. I'm not sure I like mirrowing, as it is not simple. Currently we have problems with the backup/restore process we have, as restores have started...

I have a small "Attribute-Value" table, and a UDF to go with it.

Then I can do SELECT * FROM Orders where PaymentType = dbo.fn_SystemInfo('VISA'). Unfortunately this results in a convertion...