SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,376 questions
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 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.
517 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,656 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,616
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
35,556
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
43,331
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,136
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,196
Reputation points Microsoft Employee
2 answers
Adding SQL2014 Sharepoint DB to Sharepoint Portal 2013
Hi all, I am having a problem while adding SQL 2014 database to Sharepoint portal 2013. Scenario is previously we are using SQL 2008 Server with Sharepoint Portal 2013, We have now upgraded SQL Server to 2014. I have multiple Sharepoint Site databases…
asked 2020-12-25T18:36:48.09+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(307.2, 53%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sarfraz Aslam
166
Reputation points
commented 2021-01-04T06:23:08.78+00:00
Sarfraz Aslam
166
Reputation points
2 answers
Using Azure Dms is it possible to migarte sql databse of 5Tb to azure Vm with ? What are limitations and known issues while migrating huge dbs to azure vm with azure DMS tool?
We are planning to migrate 5 Tb of sql db to azure Vm with help of azure DMS ? does dms support sql db with huge sizes like this? Azure Dms does supports only offline migration for azure vm . what is avg time taken by for migrating sql db with…
asked 2020-12-18T09:51:35.783+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, 97%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vishnuvardhan Settipally
1
Reputation point
commented 2020-12-30T06:09:38.497+00:00
Vishnuvardhan Settipally
1
Reputation point
4 answers
Questions about creating active active clustering server 2012 R2
Aloha All, Been a long time since I've posted in a forum, forgive my lack of etiquette if any. Here's my scenario: I have a 2012 R2 domain with two servers who's primary functions are, web-app<-(DC) and SQL database<-(member server). We are…
asked 2020-12-11T23:47:12.28+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(150.4, 99%, 24%)' 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)
Sperle, Raymond (CAI - Manheim Hawaii)
1
Reputation point
answered 2020-12-19T00:19:44.547+00:00
Alex Bykovskyi
1,851
Reputation points
1 answer
One of the answers was accepted by the question author.
SSMA for Sybase - Server side data migration failed
I am doing sybase ASE to SQL server 2017 data migration. I have converted schema and did synchronize. Now tables are created in SQL server. Then I have to load data from sybase for that I have changed the project settings to use server side data…
![](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, 97%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
7 answers
Migrating Sql server DB to another Server
Hello, I am planning to migrate the some Sql server databases to another Server on same domains but some of the databases have cross connection dependency. I mean some of the database either View or Stored procedure I found that it's calling to…
![](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(150.4, 17%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
1 answer
SSMA Oracle Migration to SQL Server - Automation
Hi We're looking at using SSMA to do a regular build of a SQL Server database from an Oracle database for a client datawarehouse team. I've been able to set this up using SSMA and run it using the application. I'm now looking at automating this using…
asked 2020-11-18T21:54:26.577+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(22.400000000000002, 68%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rob Stevens
1
Reputation point
answered 2020-12-04T06:04:44.007+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
1 answer
One of the answers was accepted by the question author.
Does SQL Server Migration Assistant (SSMA) support Sybase SQL Anywhere 16 (Sybase ASA) migration to SQL Server.
Hi, I want to migrate Sybase SQL Anywhere 16 Database to SQL Server in my current project using SSMA . I am planning to use SQL Server Migration Assistance for this. But i can see in the Microsoft documentation that it supports for Sybase ASE but not…
asked 2020-10-30T07:11:58.41+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, 83%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Ather Hussain
26
Reputation points
accepted 2020-11-30T07:17:33.27+00:00
Ather Hussain
26
Reputation points
4 answers
SQL 2014 Migration
Hi, I am reposting as the previous thread was closed. Please clarify my list below and recommend changes Realtime Refreshes with Parallel Jobs, Equivelant to MPP (PDW, Multiple Physical Servers with VM) • Infrastructure 2 VM (Storage &…
asked 2020-11-21T21:06:48.203+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 2020-11-27T12:12:52.877+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(300.8, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EII%3C/text%3E%3C/svg%3E)
IC IC
236
Reputation points
12 answers
One of the answers was accepted by the question author.
SQL14 Migration, Infrastructure, Software Options
Good day, i need help please! I have tried reaching out to vendors but they more keen on having their solutions within the businnes as i require infrastructure, software specifications for the next 5-7 years with improvong the analytics & speed &…
1 answer
High availability group
Hi Expert, Can you help me in explaining about High availability group in sql server database and how to find it and how it will affect to mirroring in database from sql server 2008 to sql server 2016. Any query that we can find high availability…
asked 2020-11-15T00:20:20.407+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(54.400000000000006, 55.00000000000001%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Shri
21
Reputation points
commented 2020-11-20T09:42:21.107+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,971
Reputation points Microsoft Vendor