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.
| Author |
Topic |
|
sbgitam
Starting Member
1 Post |
 Posted - 2008-09-22 : 17:44:52
|
| How do I find the current code page setting for the db as well as the server? how do I change the value.I think it is sp_configure but not sure what parameter we need to pass here.thanks, |
|
|
milamilos
Starting Member
7 Posts |
Posted - 2008-09-23 : 11:15:31
|
| You can get server defaut collation useing sp_helpsort stored procedure without parameter, and database default collation by: SELECT DATABASEPROPERTYEX('DatabaseName','Collation'). |
 |
|
|
|
|
|
code page setting