1. 下载 Microsoft Access 2016 数据库引擎可再发行程序包

https://www.microsoft.com/zh-CN/download/details.aspx?id=54920

2. 安装AccessDatabaseEngine_X64.exe
3. 运行SQL SERVER 201X 导入和导出数据（64位）

4. 可以修改注册表，让sql默认启动64位的导入导出向导

   [HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Microsoft SQL Server\120\SSIS\Setup\WizardPath]
   @="C:\Program Files\Microsoft SQL Server\120\DTS\Binn\DTSWizard.exe"

用word打字的时候如果用系统自带的输入法打字非常卡，输入中文需要等待字母一个一个跳出来
用搜狗输入法的时候，明明只按了一下键盘但是会跳出两个字母。比如说我打安全，会显示 aan quann

严重影响使用效率，并且只有在word打字的时候才会出现这种现象，在其他软件打字不会

希望能够尽快解决

Tao Deng
您好：

该问题只有在Word中打字的时候才会出现对吗？建议您检查Word“文件--选项--高级”，在“编辑选项”栏目下查看【输入法控制处于活动状态】是否处于勾选的状态，请您尝试取消其勾选。

另外，您可以尝试将输入法重新安装试试，或者使用其它的输入法来测试效果。

希望以上信息可以帮助到您。

在Chrome 59中已经支持对整个页面进行截屏1.在你要截屏的网站上右键-检查2.单击一个有手机和平板的图标，进入 Device Toolbar3.在最上面选中模拟的设备分辨率，比如我选了iPad Pro4.单击最右侧的三个点，选择 Capture full size screenshot5.一张整个页面的截图就会直接下载到你的电脑

–服务器级权限
WITH CTE AS
(
SELECT u.name AS 用户名,
u.is_disabled AS 是否禁用,
g.name as 服务器角色,
‘√’ as ‘flag’
FROM sys.server_principals u
INNER JOIN sys.server_role_members m ON u.principal_id = m.member_principal_id
INNER JOIN sys.server_principals g ON g.principal_id = m.role_principal_id
)
SELECT * FROM CTE PIVOT(MAX(flag) FOR 服务器角色 IN ([public],
[sysadmin],
[securityadmin],
[serveradmin],
[setupadmin],
[processadmin],
[diskadmin],
[dbcreator],
[bulkadmin])) AS T

–数据库级权限
WITH CTE AS
(
SELECT u.name AS 用户名,
g.name AS 数据库角色,
‘√’ as ‘flag’
FROM sys.database_principals u
INNER JOIN sys.database_role_members m ON u.principal_id = m.member_principal_id
INNER JOIN sys.database_principals g ON g.principal_id = m.role_principal_id
)
SELECT * FROM CTE PIVOT(MAX(flag) FOR 数据库角色 IN ([public],
[db_owner],
[db_accessadmin],
[db_securityadmin],
[db_ddladmin],
[db_backupoperator],
[db_datareader],
[db_datawriter],
[db_denydatareader],
[db_denydatawriter])) AS T

–数据库级单独权限
select c.name as 用户名,b.name as 对象名,
CASE b.type
WHEN ‘U’ THEN ‘Table’
WHEN ‘P’ THEN ‘Procedure’
ELSE ‘OTHER’
END AS 对象类型,
CASE WHEN a.ACTION = 26 AND a.PROTECTTYPE = 205 THEN ‘√’ ELSE ‘’ END AS ‘REFERENCES’,
CASE WHEN a.ACTION = 193 AND a.PROTECTTYPE = 205 THEN ‘√’ ELSE ‘’ END AS ‘SELECT’,
CASE WHEN a.ACTION = 195 AND a.PROTECTTYPE = 205 THEN ‘√’ ELSE ‘’ END AS ‘INSERT’,
CASE WHEN a.ACTION = 197 AND a.PROTECTTYPE = 205 THEN ‘√’ ELSE ‘’ END AS ‘UPDATE’,
CASE WHEN a.ACTION = 196 AND a.PROTECTTYPE = 205 THEN ‘√’ ELSE ‘’ END AS ‘DELETE’,
CASE WHEN a.ACTION = 224 AND a.PROTECTTYPE = 205 THEN ‘√’ ELSE ‘’ END AS ‘EXECUTE’,
CASE a.PROTECTTYPE
WHEN 204 THEN ‘GRANT_W_GRANT’
WHEN 205 THEN ‘GRANT’
WHEN 206 THEN ‘DENY’
ELSE ‘OTHER’
END AS PROTECTTYPE
from sysprotects a inner join sysobjects b on a.id = b.id
inner join sysusers c on a.uid = c.uid