摘要：
Office Add-ins Dynamics AX2012 阅读全文
|
摘要：
Office Add-ins Dynamics AX2012 阅读全文
摘要：
Develop a simple AX2012 report by Visual Studio 2010 阅读全文
摘要：
In previous AX version, we can use security keys to manage user's permission by user group.AX2012, user group hasn't used. And security keys just keep for compatiblity with old version.You can create security keys in AOT directly and object's security key property is disabled through you 阅读全文
摘要：
First, you should insure SSRS installed and AX2012 installed correctly.And configure it in AX2012->Sys Admin module->Setup->BI->Reporting services->Reports Server.1, SSRS services account should have administrator permission (Local server administrator permission)2, This account also 阅读全文
摘要：
In Dynamics AX2012, it uses security policy(AOT->Security->Policies) to replace Record-Level security. Record-Level security will not be deprecated in the AX2012 andfuture version will be not supported.So let's create a simple policy step by step.1, Define a Query named Test1as a record in 阅读全文
摘要：
1, How to use a sharedconfiguration file for Dynamics AX2012 client.Option 1, when you install Dynamics AX2012 client,you can point ashared configuration file for users on Specify a location for configuration settings. If the configuration file on the network, you should map a path for the configura 阅读全文
摘要：
User group will be not used in AX2012 for security managementA user should be mapped to one or more roles with privileges, permissions, sub-roles& process cycle. Then he has permissions.One or more duties consist of a roleOne or more privileges consist of a dutyRecord level security still exist 阅读全文
摘要：
As Microsoft's recommendations, we should install most of Dynamics AX2012 server componentson Windows 2008 R2(64bit).Microsoft's AX2012 virtual machine needs 8GB memory to run. (As my try, it is very slow when we use AX2012 in a 8GB memory PC).As some try, we can install most of components o 阅读全文
摘要：
When i re-installed office 2007 and found Excel reported an error when i open or closed it as below:Object library invalid or contains references to object definitions that could not be foundAs tested, we should delete .exd file on the below path:C:\Documents and Settings\%username%\Application Data 阅读全文
摘要：
Terminal Server Printer 阅读全文
摘要：
The virtual machine could not be started because the hypervisor is not running 阅读全文
摘要：
Change Tracking 阅读全文
摘要：
FILESTREAM,SQL2008 阅读全文
摘要：
It will report error when you save a table if you use SQL keyword as your feild name of a tableSQL error description: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'SET'.SQL statement: CREATE TABLE X50709X (PRODUCTID VARCHAR(20) NOT NULL DEFAULT '' 阅读全文
摘要：
XPO File: /Files/JackyXu1981/ProdReport.rarObjective: Develop a complex report by X++ (Axapta or Dynamics AX)Key point: pass parameter, temporary table, query, programmable reportSteps:Step 1: Create a table as temporary named myTableTMP. Step 2: Create a Report named myReport.Step 3: Create a clas. 阅读全文
摘要：
1, Select 50 unit unique records select distinct top 50 SalesId from salesline2, Selecttotal amount> 1500 recordsselect salesid,sum(amount) from salesline group by salesid having sum(amount)>15003, Define temporary tablecreate table #SalesCustom (UserName varchar(30), CustName varchar(30), Emp 阅读全文
摘要：
工作站终端过期的处理方法 现象：连接后出现“由于授权协议中的一个错误，远程计算机中断了会话。请重新跟远程计算机连接;或者跟服务器管理员联系。” 处理方法：到客户机（本机）中，打开“开始”选择“运行”，输入“regedit”确定打开注册表编辑器中删除此键值：[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSLicensing ]。这样终端就可以继续使用90天，90天后还会提示过期，可再按如上方法处理。 要想使终端短期不出现过期提示而连接不上，可如下操作：1、删除上边键值，2、调整服务器时间，调后几年（如调到 2015年）；3、此工作站重新连接服务器，出现windows2 阅读全文
摘要：
May be you haven't enabled Agent XPs for SQL2005, and when you try to access maintenance plan, SQL will report message like this:Agent XPs component is turned off as part of the security configuration You should enable it as below:sp_configure 'Agent XPs', 1reconfigurego 阅读全文
摘要：
When you are using SQL2005, maybe you'll meet the SQL error log like isA significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 921 seconds. Working set (KB): 2486348, committed (KB): 14694960, memory utilization: 16%%.It may mee 阅读全文
摘要：
command命令大全开始→运行（cmd）命令大全（绝对经典） CMD运行指令 开始→运行→CMD→键入以下命令即可: gpedit.msc-----组策略 sndrec32-------录音机 Nslookup-------IP地址侦测器 explorer-------打开资源管理器 logoff---------注销命令 tsshutdn-------60秒倒计时关机命令 lusrmgr.msc----本机用户和组 services.msc---本地服务设置 oobe/msoobe /a----检查XP是否激活 notepad--------打开记事本 cleanmgr-------垃圾整 阅读全文
摘要：
We have a database user Ato access database B. But it can't work.When we try to connect B using A, but it failed and reported error 18456.Then we checked, A has a public permission on users mapping. Normally it should be OK.Then we checked the database role:public. In servers roles, the public m 阅读全文
摘要：
SQL2005分区表可以在一定程度上解决海量数据的性能问题，比如可以规避高访问量数据区段的io竞争，可以缩小你查询数据范围的索引大小。 msdn参考 http://msdn.microsoft.com/zh-cn/library/ms345146.aspx 一个完整的脚本示例 --drop database dbPartitionTest--测试数据库 create database dbPartitionTestgouse dbPartitionTestgo--增加分组alter database dbPartitionTest ADD FILEGROUP P200801alter data 阅读全文
摘要：
1, Ping例如ping www.yahoo.com Pinging www.yahoo.akadns.net[216.115.102.78] Reply from 216.115.102.78:bytes=32 times=114ms TTL=233 ... 表示www.yahoo.com其中一台服务器的IP地址是216.115.102.78,ping默认发送4个包，bytes=32表示每个包32个字节，不算底层协议的包头长度，times=114ms是对方服务器的响应时间，TTL=233是生存期，也就是这个报文最多可以被转发233次2, Tracerttrace... 阅读全文
摘要：
Understanding a TracertThe tracert utility determines the route taken to a destination by sending Internet Control Message Protocol (ICMP) echo packets with varying Time-To-Live (TTL) values to the destination. Each router along the path is required to decrement the TTL on a packet by at least 1 bef 阅读全文
摘要：
以前一直使用AX3,先学一下AX2009.之前接触AX2009,是MS的VPC, 现在自己找了个空闲的服务器,一步一步的安装了AX2009.基本安装很简单,一步一步操作就是了.1, 数据导入如果是MSSQL数据库,建议大家直觉下载MS的.bak文件去还原数据库比较好, 如果是Oracle,只能采用AX2009的导入操作,极易出错,下载文件里面有导入文档.我试了很多次,虽然数据可以使用,但是报错不断. 所以建议MSSQL就直接还原数据库吧.2, 安装SP1, 这个比以前简单多了,允许升级程序,选择Application和AOS即可.3, AOS安装, 和以前大不同, AX3每个AOS实例只要你去 阅读全文
摘要：
有时我们不想登录SQL服务器去查询数据库,那么我们怎么做呢?1, SQLCMD命令:首先你的本地机器的域登录名必须有访问远程SQL数据库的权限2, 输入SQLCMD -S 计算机名(\数据库实例名,如果有) S必须大写3,如果以上正确,则会提示1>这样的行提示,否则连接没有成功1>use dbname2>select * from tablename3>go这样就可以查出数据库的信息了. 阅读全文
摘要：
In AX, we can define an EDT which string size's type is MEMO.Memo is text type in SQL2000/2005 and can save 2GB data. Actually, we needn't use so big field in a table. But in futher, text type will be not used. So when we customize the AX, we need to consider it.The standard max string size 阅读全文
摘要：
I want to understand RECID and index mechanism through this blog.All tests were done in AX3 (SP3+KR3) +SQL2005(SP2)1, For the system tables which created by Microsoft will create index on RecID+Dataareaid. Other indexs also can be created but on the index of RecID+Dataareaid.For user tables which cr 阅读全文
摘要：
1, 第一张盘只有部分安装文件,如果安装涉及第二张盘,需要刻成光盘安装2, SQL管理工具在第二张盘steup->SqlRun_Tools.msi. 如果安装后发现没有管理工具请直接安装这个文件 阅读全文
摘要：
SQL SERVER DBCC命令解释八点钟起床一直搞到现在，好多还不太记得，先放上来以后慢慢修改2007-05-01 12:56:28-----------------------1 dbcc trraceon DBCC TRACEOFF--对于数据库死锁，通常可以通过TRACE FLAG 1204、1205、1206，检查ERRORLOG里面的输出，和分析SQLTRACE的执行上下文判断死锁问题的来由。--TRACEON函数的第三个参数设置为-1，表示不单单针对当前connection，--而是针对所有包括未来建立的connection。这样，才够完全，否则只是监视当前已经建立的数据库连接 阅读全文
|