Home

SQL Server

39 Conversations

Latest Activity

Custom List Message Item

SQL Server.png

 

 If you're attending Microsoft Ignite be sure to come to the Community Central booth right next to the hangout space for our SQL Server takeover day! 

Please come join us anytime from 12:30 - 5:00pm ET on Monday to connect with fellow SQL Server users w

... Read More
243 Views
1 Reply

what a great day - what a great event.
hope everybody enjoyed and get out as most from that awsome event.
looking forward to MSIgnite 2018

 

Cheers

Markus

Read More

Hello all,

 

Im noobie here and i dont know if i post this question to right community.

My problem is described like this. We have our Microsoft Identitiy manager which stores its data to SQL database and we need to store history of changes. What i need i

... Read More
39 Views
0 Reply

Dear Community,

I wanted to install the developer edition, however, I keep getting this error message:

"We failed to download the files we require. Please check your network connection and try again."install.PNG

 

 

My network connection is working fine; however, my loca

... Read More
848 Views
16 Replies

Managed to install the express edition after the network reset. No help on the development version though.

YEAH, I just did network reset and I installed it with no problem!

Me to, I don't know what to do. Any help ?

Same here, but only on one of my two devices on the same network. Cannot find any differences. Windows 10 both..

 

Any fixes?

Dear Community,

 

I've setup a Microsoft SQL Server 2017 Web Edition and downloaded afterwards the Reporting Services 2017, because its no longer included in SQL Installation directly. During the setup of the Reporting Service 2017 Installation I had to cho

... Read More
202 Views
3 Replies

Hi Joel or anyone else in the community.

Where can I download SQL Server 2017 Web edition?  

cheers

 
Read More
The problem is solved in the meantime. Cause of issue was version miss match. MS SQL Reporting Services Developer Edition only works together with an MS SQL Server Develo... Read More
 
Question
You cannot vote on your own post
0
 

 I have installed package Microsoft.SqlServer.SqlManagementObjects v140.17199.0

I generated Distributor, Publication, Subscription successfully.

but on SnapshotGenerationAgent.GenerateSnapshot() I

... Read More
54 Views
0 Reply

There is an extensive World War II forum that was adminsitered using MSSQL. What are the limitation on trying to convert the MSSQL data schema into either the 2014 or 2016 SQL releases.

115 Views
3 Replies

Hi Michael,

 

what is the current SQL Server version you are using? Are there any "special" features you are using or just plain DB-Engine functionality?

 

Wolfgang

Read More

Hi, my SQL server database was suspected. my friend said it was a user change to Guest acc. so anybody have a solution to solve it?

62 Views
1 Reply
Moved to SQL Server board as more likely to find someone who can help you there.

Hello,

 

I am evaluating Windows SQL 2016 Standard and it is just for me. I understand I need a license once the 180 days expire. Do I also need a CAL ? If so can I just buy one and I have seen prices everywhere and in some cases the CAL is almost as much a

... Read More
343 Views
6 Replies
I install the developer edition as well and it's free.

John,

 

You could download SQL Server Developer Edition 2016 from here:

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

 

This has all the features of Enterpri

... Read More

Hi everyone,

I'm running into a non-urgent problem in a test region.  I was trying to restore a backup from a newly migrated database (using the azure data migration service), but it has to be hung.  It's been at 50% completion for the last 5 hours.  Is th

... Read More
33 Views
1 Reply

My restore finished last night.  Apparently sys.dm_operation_status only shows percentages of 0, 50, and 100. 

I'm still curious if there's a way to kill a process in azur

... Read More

Hi Microsoft Community Members,

 

I have just recently installed Microsoft SQL Server 2017 Express Edition and then I download and Installed SSDT( Download SSDT for Visual Studio 2017 (15.4.0 preview)). I successfully installed everything but when I open vi

... Read More
123 Views
0 Reply

I have Reporting Services 2016 connecting to SharePoint 2016 onPrem.  I'm trying to create a report with distinct values from a list column (in SP2016).  Standard methods in Report Services don't allow a distinct, so searching the internet lead me to use

... Read More
49 Views
0 Reply

Hi..

i need to Create a View that query data from two tables as follows

Table1 as Project (its contain colums ProjectID, Resource1,Resource2, Resource3, Resource4 etc)

Table2 as ResourceTable (it contain column ResourceID, AccountNO etc)

 

i need to query the

... Read More
110 Views
1 Reply

Hi Mohamed:

 

Frankly speaking, build a view may inappropriate solution against your requirement. You can create a function in database or in your program code instead.

Plea

... Read More

Somebody have this error about the missing Product Key?

 

With English media works well.

119 Views
0 Reply

SQL Server.png

 

 If you're attending Microsoft Ignite be sure to come to the Community Central booth right next to the hangout space for our SQL Server takeover day! 

Please come join us anytime from 12:30 - 5:00pm ET on Monday to connect with fellow SQL Server users w

... Read More
243 Views
1 Reply

what a great day - what a great event.
hope everybody enjoyed and get out as most from that awsome event.
looking forward to MSIgnite 2018

 

Cheers

Markus

Read More

Dear all,

 

attached you will find a little Document regarding patch management strategies for sql server deployments. Would be great if you would let me know your suggestions and comments about it.

 

Cheers

Markus

 

Read More
177 Views
0 Reply

Execute query "BACKUP DATABASE [CreditSummary] TO DISK = N'R: \\ Ba ..." failed with the following error: "Can not perform differential backup of database" CreditSummary "because there is no current database backup. Please remove the WITH DIFFERENTIAL opt

... Read More
273 Views
2 Replies

It looks like the backup chain got broken at some point and you need to generate a new full backup

Something tells me that you need to perform a full backup before you perform a differential backup...

I am delighted to announce the public preview of our latest security development from the Microsoft SQL product team, the new SQL Vulnerability Assessment (VA). SQL Vulnerability Assessment is your one-stop-shop to discover, track, and remediate potential

... Read More
600 Views
0 Reply

Hi..
I have this statement:

UPDATE Table1 SET status = 'DoSomething'

WHERE status = 'Ready' AND TabId IN
(SELECT TabId FROM Table2 WHERE xData IS NOT NULL)
.
If I run only the subselect I get an error:
Invalid column name  'TabId' - and that is correct: TabId is

... Read More
272 Views
2 Replies

I recommend that you change the script as below:

 

UPDATE Table1 SET status = 'DoSomething'

FROM Table1 INNER JOIN Table2 ON Table1.TabId = Table2.TabId

WHERE Table1.status =

... Read More

you need to fully qualify the query to get the error, like below.   Because it's not fully qualified, it tries to auto-resolve, by referencing the outer query.  

 

UPDATE T

... Read More

Hi,

Is it possible for a in memory optimized table to have partitions? If yes, can you show an example of how it can be achieved. I have seen examples of how it can be done using a hold/cold/staging table.

https://docs.microsoft.com/en-us/sql/relational-databases/in-memory-oltp/application-pattern-for-partitioning-memory-optimized-tables

... Read More
176 Views
1 Reply

@Anuradha Banerjee

 

I have moved your post to the SQL Server discussion board, someone here should be able to assist with your query.

Read More

Hi SQL-guys,

 

I'm running into this error during the last days and could not find a solution:

I am trying to import a database .BACPAC file from SQL Azure into my local SQL Server.

When doing so, I get this error on my local machine:

 

Could not import package

... Read More
1,031 Views
3 Replies
Hi all, I figured out that the reconfiguration works properly with _most_ of my databases (but not all). So it seems, the issue is dependent on the database and the authe... Read More

Execute query "BACKUP DATABASE [CreditSummary] TO DISK = N'R: \\ Ba ..." failed with the following error: "Can not perform differential backup of database" CreditSummary "because there is no current database backup. Please remove the WITH DIFFERENTIAL opt

... Read More
114 Views
0 Reply

I ran into a situation and wonder whether someone knows how to fix it.

 

I am using Microsoft SQL server Management Studio to update the database.  There is one row which I could see but could not update because it is more than 200 rows (I did learn my less

... Read More
189 Views
2 Replies

 


Shih-Hua Fu wrote:

I ran into a situation and wonder whether someone knows how to fix it.

 

I am using Microsoft SQL server Management Studio to update the database.  There

... Read More

Just wondering if it is possible to have claims based authentication with Power BI Server? Been asking in the MVP DLs but no response.

I know it is not supported out of the box, perhaps possible with with WAP and ADFS which I have setup with SP only.

I cam

... Read More
233 Views
0 Reply

Hello, can someone assist me to locate the Tutorial.SSISDeploymentManifest file listed as step number 2, under the "To install the Packages" heading on the url below? Thank you, jdbooze

 

https://docs.microsoft.com/en-us/sql/integration-services/lesson-3-2-running-the-package-installation-wizard

Read More
92 Views
0 Reply

Hello everyone,

 

Appreciated if you could share with me an offline installer for SQL Server 2016 Express edition to me for download.

 

Thank you in advance.

10.6K Views
1 Reply

Does SQL Server all Express Editions are free?

 

Download Links:

SQL Server 2016 Express SP1: https://www.microsoft.com/en-us/download/details.aspx?id=54284

Read More

Whether the MS SQL Server 2016 Ent contains the SAP Bundle function?

Thanks !

236 Views
0 Reply