Database collation Name return null

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Database collation Name return null

Author

Topic

sahili
Starting Member

3 Posts

Posted - 2006-06-13 : 10:26:18

Dear Sir,
We have created the SQL Database with Arabic_CI_AI collation.When we try to get the database collection by displaying the database property from Enterprise Manager,the collection name is not displayed

OS : Windows XP + SP2
SQL Server : SQL Server 2000 + SP4

waiting ur commants

Ammar

sahili
Starting Member

3 Posts

Posted - 2006-06-14 : 06:00:57

Dear ,
i want to the following note that we are using SQL Server Personal Edition ..

Ammar

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2006-06-14 : 08:12:41

What result do you get when you run this statement in Query Analyzer?


-- Change 'DBName' to the name of your database

exec sp_helpdb 'DBName'

select [Collation] = DatabasePropertyEx('DBName','Collation')

CODO ERGO SUM

sahili
Starting Member

3 Posts

Posted - 2006-06-15 : 08:09:37

Dear ,
Applying the below T-SQL Command will return results ( no problem) ,but if we try to get the database collation from Enterprise Manager (by clicking on the database property ,the collation name will be blank,null no collation name

Regards

-- Change 'DBName' to the name of your database
exec sp_helpdb 'DBName'
select [Collation] = DatabasePropertyEx('DBName','Collation')

Senior Database Administrator

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources