Who can get the system codepage from SQL Server 7.0

Limu 2000-07-18 05:25:00
I want to know the system codepage in SQL Server 7.0,but I cann't find any function or system variable that give me my request.Who can help me? Please send the result to my email address (llizimu@21cn.com)
...全文
182 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
hostname 2000-07-23
  • 打赏
  • 举报
 回复
使用sp_configure，不过正常情况下sp_configure只显示基本的信息
要想看codepage须把一开关打开，也就是把advance置1，具体办法你可
通过查看sp_configure的T_SQL帮助。要耐心看！！！
dukeli 2000-07-19
  • 打赏
  • 举报
 回复
试试sp_helpsort
Christy 2000-07-19
  • 打赏
  • 举报
 回复
Use sp_helpsort. If you want to change the codepage, try to run mssql7\binn\rebuilm.exe. But be careful!
码狂 2000-07-18
  • 打赏
  • 举报
 回复
用T-SQL来实现。
微软内部资料-SQL性能优化3
If a row is locked, SQL Server will apply intent locks at both the page and the table level. If a page is locked, SQL Server will apply an intent lock at the table level. SIX locks imply that we have...
sql server 7.0/2000 转 2005 完全手册【官方】
The Upgrade MechanismFor all components, SQL Server 2005 provides an upgrade from SQL Server 2000 or 7.0. Note that Microsoft distinguishes between a SQL Server 2005 upgrade and a migration.An upg
SQL Server Configuration Performance Checklist
Performance Audit Checklist ...ServerConfiguration Settings AdvancedSetting? RequiresRestart? Default Value Current Value affinity mask Yes Yes 0 awe enab...
improving sql server performance
Improving SQL Server Performance   Retired Content This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still ...
SQL Server security
of authentication, one at the SQL Server level and the other at the database level. These two stages are implemented using Logins names and User accounts respectively. A valid login is required to ...
MS-SQL Server

34,587

社区成员

254,588

社区内容

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章