Hello folks, this month I’m working building a Multidimensional OLAP Cube and my customer asks me to implement the Row Level Security, then instead create a lot of roles for each profile is better to create just one Dynamic role. Let’s assume you already create all tables and views and has created the correct connections…
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……
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…
Em um servidor de SQL com o serviço de SQL paralisado, ao tentar abrir o configuration manager para iniciar o serviço em Start -> Microsoft SQL Server Versão XXX -> Configuration Tools -> SQL Server Configuration Manager. Recebi a seguinte mensagem de erro: ”Cannot connect to WMI provider.You do not have permission or the 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…
