推荐:如何获取SqlServer2005数据库表结构1.获取表的基本字段属性 --获取SqlServer中表结构 SELECT syscolumns.name,systypes.name,syscolumns.isnullable, syscolumns.length FROM syscolumns, systypes WHERE syscolumns.xusertype = systypes.xusertype AND syscolumns.id = object_id('你的表名'
1、WIN2003需要打上sp1补丁。 2、注意数据执行保护里的设置。右键点“我的电脑”——“属性”——“高级”,“性能”框里的“设置”——“数据执行保护”,需要选择“仅为基本windows程序和服务启用DEP(T)”。设置完成后,查看“系统ODBC”里面的“DSN”的数据源驱动程序库里是否有内置的驱动程序,有则可安装。
3、修改注册表:(以下为注册表文件)
Windows Registry Editor Version 5.00
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC] [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI] [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\LocalServer] "Description"=""
"Server"="(Local)"
"Trusted_connection"=""
"UseProcForPrepare"="Yes"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources] "LocalServer"="SQL Server"
"TrioMotors"="Microsoft Access Driver (*.mdb)"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN] "DefaultDSNDir"="C:\\Program Files\\Common Files\\ODBC\\Data Sources" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TrioMotors\Engines] [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\TrioMotors\Engines\Jet] "ImplicitCommitSync"="Yes" "MaxBufferSize"=dword:00000200 "PageTimeout"=dword:00000005 "Threads"=dword:00000003
"UserCommitSync"="Yes"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI] [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver da Microsoft para arquivos texto (*.txt; *.csv)] "UsageCount"=dword:00000002 "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll" "Setup"="C:\\WINDOWS\\system32\\odtext32.dll" "APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.,*.asc,*.csv,*.tab,*.txt,*.csv" "SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Access (*.mdb)] "UsageCount"=dword:00000002 "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll" "Setup"="C:\\WINDOWS\\system32\\odbcjt32.dll" "APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="2"
"FileExtns"="*.mdb"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft dBase (*.dbf)] "UsageCount"=dword:00000002 "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll" "Setup"="C:\\WINDOWS\\system32\\oddbse32.dll" "APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.dbf,*.ndx,*.mdx" "SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Excel(*.xls)] "UsageCount"=dword:00000002 "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll" "Setup"="C:\\WINDOWS\\system32\\odexl32.dll" "APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.xls"
"SQLLevel"="0"
[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Driver do Microsoft Paradox (*.db )] "UsageCount"=dword:00000002 "Driver"="C:\\WINDOWS\\system32\\odbcjt32.dll" "Setup"="C:\\WINDOWS\\system32\\odpdx32.dll" "APILevel"="1"
"ConnectFunctions"="YYN"
"DriverODBCVer"="02.50"
"FileUsage"="1"
"FileExtns"="*.db"
"SQLLevel"="0"
分享:如何在SQL Server2005中还原数据库对于在SQL Server2000中的还原数据库,很多朋友都是使用过的,一起来也很简单,选择文件后,选择强制还原,问题即可解决,然而在2005中却不行了,原因是:2005中数据库的备份中记录了备份数据库的地址,在你还原的过程中,你必须将此地址换成你电脑上要还原