No announcements
-
1 VotesIntroducing the new Wide World Importers sample database for SQL Server (replacing AdventureWorks)
So long AdventureWorks, we’ll miss you! It’s the end of an era for the SQL Server sample database AdventureWorks as development has been suspended for the popular sample ...Sticky | 0 Replies | 6451 Views | Created by Samuel Lester - MSFT - Wednesday, November 30, 2016 9:35 PM
-
1 Votes
Finding the Correct Version of the AdventureWorks Sample Database
As the AdventureWorks sample database has evolved over the years, there are many different editions to decide from. The following blog post will help you pick the correct version to ...Sticky | 3 Replies | 16034 Views | Created by Samuel Lester - MSFT - Thursday, August 23, 2012 8:18 PM | Last reply by vuelveteloco - Sunday, June 2, 2013 1:38 PM
-
0 Votes
No Default Instance when Launching SQL (Error Text in Body Below)
Hello all, I am currently receiving the following error message in SQL 2017: I launch SQL and have no default ...Unanswered | 1 Replies | 96 Views | Created by BillGates_Sr - Friday, December 27, 2019 2:11 AM | Last reply by Cris Zhan - Friday, December 27, 2019 2:57 AM -
0 Votes
Problems with SQL Concatenation + Missing Documentation On This
TL; DR: If you want to tell someone who IS successfully using SQL concatenation NOT to use SQL Concatenation - how can you 1) Show them how their working example ...Unanswered | 5 Replies | 1211 Views | Created by OneLChela - Wednesday, November 6, 2019 11:38 PM | Last reply by Erland Sommarskog - Friday, December 20, 2019 10:39 PM -
0 Votes
SQL Server Agent Job with red x icon.
Hello, In SSMS SQL Server Agent job shows red x(cross) symbol even though my job completed successfully. Can someone help me to understand why it is showing ...Answered | 2 Replies | 257 Views | Created by ShyamReddy - Friday, December 20, 2019 3:18 PM | Last reply by ShyamReddy - Friday, December 20, 2019 3:46 PM -
1 Votes
Microsoft SQL Server 2016 Express EULA
Hi, Can someone give me the Microsoft SQL Server 2016 Express EULA? The main Microsoft website link only shows up to ...Proposed | 1 Replies | 498 Views | Created by Callum 12345 - Wednesday, December 11, 2019 2:18 PM | Last reply by Cathy Ji - Thursday, December 12, 2019 2:25 AM -
3 Votes
Repair a corrupt SQL database in SQL 2005
My server crashed. most stuff lost. I recovered the .mdf .ldf files through DaRT. I can not use the files. It advises that the header is corrupt. Please advise what the best way to resolve ...Answered | 4 Replies | 2885 Views | Created by jackmorgan - Sunday, September 6, 2015 10:51 AM | Last reply by Robin Shanab - Friday, December 6, 2019 6:42 AM -
1 Votes
Missing include file in XA sample
Looking at: https://docs.microsoft.com/en-us/sql/connect/odbc/use-xa-with-dtc?view=sql-server-ver15 Using XA ...Proposed | 3 Replies | 1011 Views | Created by StarQuest - Wednesday, November 20, 2019 11:00 PM | Last reply by StarQuest - Thursday, December 5, 2019 3:58 PM -
0 Votes
Question about SQL 2014 STD license
Hello everyone! I have a single SQL 2014 STD server + cal on a two node Windows Cluster. Its really necessary to get a second license of SQL to license the other ...Unanswered | 2 Replies | 750 Views | Created by Rafael Scariot - Wednesday, December 4, 2019 1:36 PM | Last reply by Dedmon Dai - Thursday, December 5, 2019 3:13 AM -
0 Votes
SQL Server 2017 Express License terms
Hi In the License terms for SQL Server 2017 Express MicroSoft writes that they collect data about the user interactions with the program. It is a "take it or leave it" ...Answered | 1 Replies | 955 Views | Created by SPeterB - Friday, November 29, 2019 10:23 AM | Last reply by Cris Zhan - Monday, December 2, 2019 5:32 AM -
7 Votes
How to find the first SQL Server version where new functionality was introduced?
Hi everybody, I think there needs to be something in the documentation that would say when (which SQL Server version) this function first appears. In particular, ...Answered | 6 Replies | 3422 Views | Created by Naomi N - Thursday, November 14, 2019 6:07 PM | Last reply by Dan Guzman - Sunday, November 17, 2019 10:12 PM -
0 Votes
SQL Server - Core Factor
Hi, I'm looking for information about the core factor for SQL Server. I found the tables from 2014, do you know if it is current ? Processor Type --- Core Factor ...Unanswered | 2 Replies | 1020 Views | Created by T9omek - Monday, October 21, 2019 5:42 AM | Last reply by Amelia Gu - Tuesday, October 22, 2019 6:08 AM -
0 Votes
Visual C++ 2010 and 2013 Installed along with SQL server 2016
Hi, After installing SQL Server 2016 SP2-CU8 following components get installed: Microsoft Visual C++ 2010 x64 Redistributable - ...Proposed | 5 Replies | 1071 Views | Created by Hellfire2260 - Thursday, September 5, 2019 7:54 PM | Last reply by Luigi Bruno - Friday, September 6, 2019 7:14 AM -
0 Votes
Licensing
I have two questions regarding properly licensing sql standard. If I have sql server 2016 standard on 2016 OS...do I need core licenses for both, or just SQL because its more ...Proposed | 2 Replies | 1447 Views | Created by John72x - Sunday, August 25, 2019 8:23 PM | Last reply by Dedmon Dai - Monday, August 26, 2019 1:08 AM -
0 Votes
Database Experimentation Assistant - Question about analysis report
I used Database Experimentation Assistant and captured an 8 hour trace of my production on-premise SQL Server. It includes lots of stored procedure executions and select queries, but always with ...Unanswered | 3 Replies | 1438 Views | Created by noamo48 - Friday, August 2, 2019 4:26 AM | Last reply by YKN123 - Friday, August 23, 2019 9:24 AM -
1 Votes
Question about online material to prepare for SQL 2016 exams (70-764 and 70-765)
Hi I am preparing for the SQL Server 2016 Administration exams (70-764 and 70-765). So far I have found the Microsoft press book "Introduction to SQL Server 2016 ...Proposed | 6 Replies | 4035 Views | Created by SQL Admin Canuck - Tuesday, February 7, 2017 2:59 PM | Last reply by Sandy Martin - Tuesday, July 30, 2019 11:48 AM -
0 Votes
RAISERROR N'<\<%7.3s>> syntax, is there documentation that explains this syntax?
Dear Microsoft Forum Member, I am reviewing the RAISERROR Microsoft documentation and reference is made to the error message with the ...Proposed | 2 Replies | 1232 Views | Created by lt_Pax79 - Monday, July 29, 2019 9:36 PM | Last reply by Erland Sommarskog - Tuesday, July 30, 2019 10:19 AM -
0 Votes
SSMS 2017 system requirements
where can I find the system requirements for sql server management studio 2017?Proposed | 3 Replies | 1730 Views | Created by sqlguy10 - Tuesday, June 18, 2019 1:27 PM | Last reply by Dedmon Dai - Wednesday, June 19, 2019 6:05 AM -
0 Votes
Unicode conversion in MSSQL 2017 using 13.1 odbc drivers
Hi, I am trying to convert a code to insert and select a SQL query, which I am running in Windows to Linux. It is a Unicode conversion part where I am trying to convert between ...Unanswered | 1 Replies | 2439 Views | Created by Ash46 - Monday, February 12, 2018 9:33 AM | Last reply by pituach - Sunday, June 9, 2019 11:39 AM -
0 Votes
Partitioning table is available on SQL 2016 with SP2
HI guys, I always figured that sql table partition was available only in the enterprise edition of sql 2016, but I was reading this blog and it seems to me that from SP2, this ...Answered | 5 Replies | 1620 Views | Created by Adriano Neiva - Friday, May 31, 2019 3:37 PM | Last reply by Cathy Ji - Monday, June 3, 2019 7:48 AM -
0 Votes
How do I deploy reports in Visual Studio 2019
Please explain how to deploy reports with Visual Studio 2019. Specifically I would like to see the steps for downloading Visual Studio 2019 Community Edition into a cache ( us the layout command ...Unanswered | 2 Replies | 1595 Views | Created by David.Brinckman - Tuesday, May 28, 2019 6:22 PM | Last reply by Olaf Helper - Wednesday, May 29, 2019 6:41 AM -
0 Votes
SQL Server Patching
Hi, I would like to have documents for SQL Server patching checklist with troubleshooting & roll back. Also patching process is ...Answered | 6 Replies | 2073 Views | Created by SQL_Dave - Friday, May 3, 2019 6:17 AM | Last reply by Shanky_621 - Friday, May 3, 2019 11:04 AM - Items 1 to 20 of 1054 Next ›
No announcements
