SQL

4555 2

Cannot connect to WMI Provider SQL server configuration manager error

I am trying to open SQL server configuration manager, after following this question "How to open sql server configuration manager in windows 10?" and steps to show it on Start menu, but when opening configuration manager getting error pop-up with message

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.
Invalid namespace

...

Type
Question

4523 0

SQL Server Management Studio (SSMS) Alternatives (Mac, Windows, Linux)

In this article, I have mentioned SQL Server management studio (SSMS) alternatives for windows, mac and Linux, which you can try to use.

Type
Article

4218 0

Import data from Excel to SQL Server

In this article, I have provided step by step procedure to import excel in SQL Server database using SSMS or using SQL Query.

Type
Article

4167 0

Free SQL Server Reporting Tools

In this article, I have provided list of free SQL server reporting tools with their features, so you can easily which sql server reporting tool will be good for your company.

Type
Article

4094 0

How to Edit More than 200 rows in SQL Server

In this article, I have mentioned how we can increase limit to edit more than 200 rows in sql server using SSMS.

Type
Article

4094 0

Download and Install SQL Server Management Studio (Step by Step)

In this article, I have mentioned how you can download and install SQL Server management studio (SSMS) in your local pc and how to use SSMS.

Type
Article

4043 0

TRIM(), LTRIM(), RTRIM() Functions in SQL Server

In this article, I have discussed about SQL Server TRIM(), LTRIM(), RTRIM() Functions in SQL Server with example

Type
Article

3913 0

Convert Int To String (varchar) in SQL Server

In this article, I have mentioned how we can convert Int to string (varchar) in SQL Server using examples

Type
Article

3881 0

Get Date From Datetime in SQL Server

In this article, I have mentioned how to get date from datetime in sql server using various examples.

Type
Article

3856 2

How to retrieve an int from Stored Procedure and not an objectResult using EF ???

Hi,

im trying to set data from my project (mvc.net,c#) by web service and im using a store Procedure to set the data.

after setting i should recive an int id of the record that was created.

my problem is that the SP returns an objectResult when i run it from my project but when i execute it in SQL it returns int...

How to retrieve an int from Stored Procedure using EF ???

...

Type
Question

Page 7 of 11