sql-server-2014

How to revoke login/connection access to SQL Server Analysis Services (SSAS)

感情迁移 提交于 2020-01-17 06:14:27
问题 I've got a SQL Server Analysis Services Server 2014. I revoked the access of a user by going into the security tab of properties window of the SSAS server instance and then performing remove operation. Then I launched SQL Server Management Studio (SSMS) in the context of the user which I had

combining Geography data

不问归期 提交于 2020-01-17 05:09:13
问题 Using something like this works: DECLARE @Shape GEOGRAPHY = 'POLYGON EMPTY' SET @Shape.STSrid = 4326; SELECT @Shape = @Shape.STUnion([PolygonData]) FROM [Bla].[Polygon] SELECT @Shape.STAsText(); on a table like this: CREATE TABLE [Space].[Polygon]( [Id] [UNIQUEIDENTIFIER] NOT NULL, [PolygonData]

error message: Format of the initialization string does not conform to specification starting at index 0

 ̄綄美尐妖づ 提交于 2020-01-14 22:33:41
问题 I searched SO but have not found a solution to my error. I am using VS 2013, and SQL Server 2014. Below is my connectionstring: using (SqlConnection sqlConnection = new SqlConnection("cnInvestTracker")) { } My web.config is: <connectionStrings> <add name="cnInvestTracker" connectionString="Data

error message: Format of the initialization string does not conform to specification starting at index 0

[亡魂溺海] 提交于 2020-01-14 22:32:17
问题 I searched SO but have not found a solution to my error. I am using VS 2013, and SQL Server 2014. Below is my connectionstring: using (SqlConnection sqlConnection = new SqlConnection("cnInvestTracker")) { } My web.config is: <connectionStrings> <add name="cnInvestTracker" connectionString="Data

SSIS and Informatica [closed]

*爱你&永不变心* 提交于 2020-01-12 11:45:04
问题 Closed . This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last month . SQL SERVER 2014 SSIS has been released,we have already got lot of facilities

SSIS and Informatica [closed]

女生的网名这么多〃 提交于 2020-01-12 11:42:11
问题 Closed . This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last month . SQL SERVER 2014 SSIS has been released,we have already got lot of facilities

SSIS and Informatica [closed]

↘锁芯ラ 提交于 2020-01-12 11:38:12
问题 Closed . This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be answered with facts and citations by editing this post. Closed last month . SQL SERVER 2014 SSIS has been released,we have already got lot of facilities

SQL function for converting string expression to proper value

半腔热情 提交于 2020-01-07 10:00:22
问题 I need a function to convert mathematical expressions to a float value: create function dbo.ExpressionToValue ( @expression nvarchar(max) ) returns float as begin declare @result float --convertion codes return @result end expected usage: select dbo.ExpressionToValue('2+3') expected result: 5 回答1