Category: SQL Server

XML data type is not supported in distributed queries

Hello guys, today I’ll talk about queries with Linked Server and XML Data. When you try to make a SQL Server query using Linked Server, and the table has an XML Data you will receive the following message: It easy solves the problem, you need to use an OPENQUERY like this: SELECT Name, Description, XML fields……

The Database Engine instance you selected is not valid for this edition of Reporting Services – SQL Server 2012

Depois de instalar o Reporting Services no Modo SharePoint 2013 a seguinte mensagem de erro foi exibida no log: ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: “The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the…

Erro de divisão por Zero no SQL SERVER.

Quem usa constantemente SQL Server ja deve ter recebido algumas vezes este aviso . “Divide by zero error encoutered”. Para testar o erro, use o codigo abaixo. Sempre quando estamos fazendo alguma divisao e esta divisao é feita por um valor igual a zero, a mensagem acima sera mostrada no SQL Server.  Para evitar e/ou corrigir…

Blog do Project

Tudo que você queria saber sobre Microsoft Project, Project Server e Project Online

ppm4all

by Allan Rocha

Paul's Project Server and Project Online Blog

Microsoft Project Server and Project Online (PPM)