Note : Download Windows Azure Platform Training Kit – December Update by Microsoft
I wanted to read some good SQL Azure related to documentation, I tried to do searching online. While searching I landed over Windows Azure Platform Training Kit. This contains lots of SQL Server related content.I downloaded it and started to explore, I suggest if you are interested in Azure Platform you download it as well.
The Azure Services Training Kit includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Windows Azure platform including: Windows Azure, SQL Azure and AppFabric. The December release includes new and updated labs in addition to information about Microsoft Codename “Dallas”.
This training kit contains lots of Hands On Labs, Presentations and Videos, Demos and Samples and Tools.
Download Windows Azure Platform Training Kit – December Update
Abstract courtesy : Microsoft
Reference: Pinal Dave (https://blog.sqlauthority.com)
1 Comment. Leave new
When i tried to insert the new field into the ax dynamics custtable it is not synchronizing while that particular table is configured for the transactional replication—– throwing the error as—> cannot execute the data definition language command on (). the sql database has issued an error.
and problems during the sql data dictionary synchronization.
In the even viewer the error description is as bellow…..
Object Server 02: The database reported (session 3 (Admin)): [Microsoft][SQL Native Client][SQL Server]Only members of the sysadmin fixed server role or
db_owner fixed database role can perform this operation. Contact an administrator with sufficient
permissions to perform this operation.. The SQL statement was: “ALTER TABLE CUSTTABLE ADD FIELD1 NVARCHAR(10) NOT NULL DEFAULT ” ”
But the user, whose is logged in AX and trying to add a new field is having the full rights to SQL Server.
He is having sysadmin & db_owner rights.
What could be the problem?