SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions
3 answers
Mirror sync between two servers
Hi to everyone, We are going to deploy a mirror sync between two servers with Microsoft SQL Server 2019. Before this, we want to know whether the entire database is synchronised in the mirror or whether we have the option to choose individually which…
asked 2021-02-09T16:02:28.033+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(131.20000000000002, 39%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
OptimalPyme
1
Reputation point
answered 2021-02-14T11:30:22.883+00:00
Alex Bykovskyi
1,841
Reputation points
2 answers
Process to move sccm DB?
So we have installed sccm and it's DB onto a single VM. But now we would like to move it's DB onto our dedicated clustered sql server. Is it as simple as just re-running the MS Endpoint config manager setup wizard and pointing it to our dedicated sql…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(3.2, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC4%3C/text%3E%3C/svg%3E)
1 answer
Master Data Services: Weird automatic Date conversion
After migrating to MDS2019 there is now an issue when adding members to our entities. We have a datetime column with an input mask dd/mm/yyyy, however when adding a member and filling in the date a weird automatic conversion happens. Everything works…
asked 2021-02-08T16:06:12.387+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 31%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
ErikJan
1
Reputation point
commented 2021-02-12T13:47:30.477+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 88%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Pollet, Peter-Jan
1
Reputation point
1 answer
DW Upgrade (VMWare with SSD or Physical box)?
Good day, I am designing architecture for new DW that can handle paralism 3 tiers (Data storage, persentation, vizualizer) External company has done an assessment on the environment, the feedback is that the 3 ties on VMWare would work currently…
asked 2021-02-09T13:15:11.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 39%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Ismail Cassiem
226
Reputation points
answered 2021-02-10T17:46:08.88+00:00
Ismail Cassiem
226
Reputation points
0 answers
Master Data Services Automatic Generated Code Field Fills To XX_CopyXXXX When Adding A New Member Via Copying Existing Member
I am using the Web application of MDS. Recently we migrated to the newest version of MDS and all functions are working properly. However, since the migration we have been having issues when copying existing Members (Records) in an Entity within the…
asked 2021-02-08T16:08:55.297+00:00
ErikJan
1
Reputation point
commented 2021-02-09T10:11:04.383+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
1 answer
user migration sql server
Hi Expert, I have windows user(domainx/userA) with domain x who has account to 7 sql server instance and i want to migrate this windows new server client with domainy/userA. Do i have to migrate or copy or move access all from 7 servers to new server…
asked 2021-02-01T03:11:36.843+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 35%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Shelar, Rupesh
21
Reputation points
commented 2021-02-04T07:48:57.287+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
1 answer
VS2019 SSDT - Object reference not set to an instance of an object
Hello, I'm beginning a Database Project using SSDT in Visual Studio 2019 and am currently facing issues loading tables in the SQL Server Object Explorer. After connecting to the Azure DB (SQL Server 12.0.2000.8), I'm receiving the error "Object…
asked 2021-01-15T00:13:52.183+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 41%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
olioxenfrees
6
Reputation points
commented 2021-02-01T17:43:23.177+00:00
olioxenfrees
6
Reputation points
1 answer
One of the answers was accepted by the question author.
Sql Server 2014-Maintenance Plan
Hello, How can i add Maintenance Plan in Sql Server 2014? I add Management Tools in the Feature Selection and it still does not appear Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 28.000000000000004%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
How do I migrate InfluxDb to SQL Server?
We have been trying to migrate InfluxDb to SQL Server. Since InfluxDb is time series database, the time will be the primary key. But in SQL Server we are using GUID as the primary key. Is there any way to migrate large data sets from Influx to SQL Server…
asked 2021-01-25T08:55:18.267+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(243.2, 92%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
L_k_code
1
Reputation point
answered 2021-01-26T06:51:09.777+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,966
Reputation points Microsoft Vendor
1 answer
SSMA connectivity to DB2 ( with SSL enabled on IBM Bluemix platform ) is failing. Does SSMA support this type of connection to DB2 database?
59169-db2errorlog-ssma.log Attaching the error log for your reference. Does SSMA (mentioned version in the log) support connectivity to IBM Bluemix DB2 connectivity? Does SSMA support or provide option to connect DB2 database which is SSL enabled?…
asked 2021-01-21T19:58:49.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 26%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Siddhesh Manjrekar
1
Reputation point
commented 2021-01-25T16:24:47.777+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 65%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAI%3C/text%3E%3C/svg%3E)
Alexander Ivanov
491
Reputation points
4 answers
One of the answers was accepted by the question author.
C#-Sql How do I connect DataGridView-label?
I saved the text "** EXAMPLE **" in the first picture to the "Kurallar" column in the database and as 123 to the "Id" column. In the second picture, when I type 123 into the TextBox under the DataGridView and click the…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,214 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,579 questions
asked 2021-01-21T11:17:09.897+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(163.2, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOU%3C/text%3E%3C/svg%3E)
Oğulcan Akca
196
Reputation points
accepted 2021-01-25T12:14:32.827+00:00
Oğulcan Akca
196
Reputation points
2 answers
How can I check whether I can downgrade from SQL Server Enterprise 2016 to SQL Server Standard?
I have a SQL Server Enterprise license for a system which I "think" does not need that. Is there a way to check that I am not using features only available in SQL Server Enterprise?
asked 2021-01-20T13:13:43.787+00:00
Eric Mamet (MSDN)
6
Reputation points
commented 2021-01-23T22:19:16.097+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 30%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETH%3C/text%3E%3C/svg%3E)
tibor_karaszi@hotmail.com
4,306
Reputation points
2 answers
One of the answers was accepted by the question author.
Hi Team we are using sql 2008 R2 problem is that after some time instance unable to show in sql
Dear Team, we are using sql 2008 r2 after restart SQL Server Browser after that sql instance show in sql . this issue happen frequently ,Please suggest
asked 2021-01-17T14:37:47.597+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(288, 18%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rahul Borate
21
Reputation points
commented 2021-01-18T15:48:53.227+00:00
Rahul Borate
21
Reputation points
0 answers
Importing data from AS400/DB2 into SQL Server 2008R2 Via Linked Server
I am importing a AS400/DB2 table to SQL Server 2008R2. One column has chinese characters in the table, the rest is english. The CCSID (Code Page) for that one columns in the table were specifically set to 937 and others are 65535. When I try to import…
asked 2021-01-13T12:25:06.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(224.00000000000003, 73%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
Praneetha Reddy
1
Reputation point
commented 2021-01-18T01:57:41.52+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,611
Reputation points
4 answers
One of the answers was accepted by the question author.
Migrate SQL 2012 Clustered Instance to SQL 2016 Standalone Instance
I'm about to migrate a SQL 2012 failover clustered instance to SQL 2016 standalone instance. At the end of migration I will have to reuse the SQL virtual network name and IP address. I'm planning to perform the below: Setup a SQL 2016 standalone…
asked 2021-01-14T17:25:39.217+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Marcus Wong Theen Nam
1,111
Reputation points
accepted 2021-01-15T08:33:26.677+00:00
Marcus Wong Theen Nam
1,111
Reputation points
0 answers
Error assessing database with Data Migration Assistant
I'm getting this error: The assessment of database 'xxxx' on server 'xxxx' failed. Feature is expired. FeatureName=CoreEngine I found the license file - looks like it expired on 1/1/2021. Is it possible to get an updated one?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 76%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
2 answers
Encryption key - do I need to restore it or not ?
I am testing some SSRS migration process. I noticed if I migrate from a server to a different server, I do need to restore encryption key after restore the report dbs. But if I just change an existing server from one name to another , even I don't…
asked 2021-01-04T23:31:28.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 18%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anne
276
Reputation points
commented 2021-01-11T07:43:00.927+00:00
ZoeHui-MSFT
34,836
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server 2020 Release Date
Hello, Do you know when is the release date of the SQL Server 2020 (Also named SQL2020 and SQL Server 16.0 (?) I realize this has been asked here: when-is-the-release-date-for-sql-server-2020-aka-sql2020 and the direction was that, roughly, MS…
asked 2021-01-07T17:20:12.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 5%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESH%3C/text%3E%3C/svg%3E)
Sean Halverson
26
Reputation points
answered 2021-01-08T13:24:49.467+00:00
Olaf Helper
42,841
Reputation points
2 answers
SQL server 2019 database backup
Hi All, I need to backup my sql database either as a whole (*.bak) file or as each table as separate .sql scripts. .bak file can be done as database backup .sql script for each table was done by generate script options. The bottleneck which I…
asked 2021-01-05T06:31:16.457+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 81%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVP%3C/text%3E%3C/svg%3E)
Venkadesh P
1
Reputation point
commented 2021-01-08T06:10:08.453+00:00
CathyJi-MSFT
21,116
Reputation points Microsoft Vendor
3 answers
Upgrade SCCM 1902 to 2002
We are in the middle of a server refresh and will be installing SCCM 2002 on a new server, different server name. What would be the best approach to do this? Current SCCM Primary is on Server 2012, new SCCM Primary will be on Server 2019 The…
asked 2021-01-06T01:55:52.693+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 5%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EVANS Michael
1
Reputation point
commented 2021-01-06T19:13:03.437+00:00
Jason Sandys
31,186
Reputation points Microsoft Employee