How to Change the Collation of Particular Database

See more:

SQL-Server

Hello,

I am working in one windows application and for that i use sqlserver 2008 for database connectivity.

Now i want to change default collation as Indic_General_90_CI_AS for my database but sql server not allow to do that.it show me the error like

Collation 'Indic_General_90_CI_AS' is supported on Unicode data types only and cannot be set at the database or server level.

And Here is my store Procedure for that

USE [gujarati_demo]
GO

ALTER DATABASE gujarati_demo COLLATE Indic_General_90_CI_AS 
GO
/*select COLLATIONPROPERTY ('Indic_General_90_CI_AS','@gujarati_demo')*/

/****** Object:  StoredProcedure [dbo].[SP_guj]    Script Date: 05/31/2013 17:10:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_guj]
(	
	@Parameter int = 0,
	
	@Name Nvarchar(max)= Null

	
)
			
AS

set QUOTED_IDENTIFIER ON

begin transaction

	DECLARE @SQL_Query VARCHAR(max)
	
	if @Parameter = 1 /* Inserting Party */

	begin
		insert into gujarati_demo values (@Name)
	end
	if @Parameter = 2 /* Inserting Party */

	begin
	
		select Name FROM gujarati_demo WHERE Name=@Name 
	end
	
Commit Transaction

If any one have the solution of this error please help me.


Advance Thanks and Regards