SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,743 questions
2 answers
Oralle to SQL conversion "start with" and "connect by prior "
Hi I am currently converting Oracle database to SQL Server 2016 Sp2 database and hitting some issue with coversion on following key works "start with " "connect by prior " ++++++++++++++++++++++++++++++++++++ with equip_parent…
asked 2020-11-17T05:41:02.633+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(208, 42%, 30%)' 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)
Ashwan
521
Reputation points
answered 2020-11-18T09:09:57.607+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
0 answers
All dependencies and entities on sql server
Hi Expert, I am trying to find the dependent jobs, linkked server, users,ssis packages,source target mapping,db stats,sql files, impacted files, impacted codes, ssis package variable, ssis config tables, ssis packages, sql agent schedule on sql server…
asked 2020-11-15T20:20:21.55+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-16T08:56:14.01+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
10 answers
One of the answers was accepted by the question author.
SQL SERVER 2012 TO 2017 data mirror
Hi Expert, How will data mirror SQL Server Application from one server to another . How to check which server machine depended on this server and how will move it from sql server 2012 to sql server 2017 with all dependency, jobs, agents etc together …
1 answer
dependency jobs on sql server
Hi Expert, How to find the dependent jobs in sql server database, I found below method .any other methods to be check to check any other server or SQL database from any other Server machine has any dependency or any ssis or any other jobs dependency…
asked 2020-11-14T23:10:26.873+00:00
Shri
21
Reputation points
answered 2020-11-15T13:24:30.403+00:00
Erland Sommarskog
101.1K
Reputation points MVP
3 answers
From SQL 2008 to SQL 2019
My organization has migrate the instance I use from SQL 2008 to SQL 2019. Since then a query I run to get the users that are using the different database in the instance just work for one of them SELECT sdes.nt_user_name as Utilizador …
asked 2020-10-30T18:13:23.3+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(28.799999999999997, 23%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJO%3C/text%3E%3C/svg%3E)
João Simplicio Rodrigues
1
Reputation point
answered 2020-11-02T06:48:40.213+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
need Microsoft.SQLSERVER.sqlclrprovider.dll version 14.0.0.0 to be in assembly
I am having missing DLL error while running an EXE. I am looking for Microsoft.SQLSERVER.sqlclrprovider.dll version 14.0.0.0 to be in my assembly. While searching I found two msi are suggested to install for it. 'SQLSysClrTypes.msi' and…
asked 2020-10-26T16:08:13.023+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(73.60000000000001, 42%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Seuli Das Majumder
101
Reputation points
commented 2020-10-28T13:17:37.487+00:00
Seuli Das Majumder
101
Reputation points
2 answers
SQL Migration Office 365: DAO missing
Hello What I want to do: Migrate a acessdata.accdb to SQL Database 2019 with SSMA 8.14. OS, Office and SSMA are 64 bit. The error I get when loading the database: Retrieving the COM class factory for component with CLSID…
asked 2020-09-30T10:08:06.55+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(153.6, 67%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Monika Badertscher
1
Reputation point
answered 2020-10-20T02:26:54.57+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
6 answers
Problem importing into SQL Server 2012 from AS400
Hi, We've quitted using the AS400 for a SQL Server based software. We'd like to migrate the databases from it into a server having OS Windows Server 2012 Standard and SQL Server 2012. We're talking about around 20 databases with hundreds of tables. …
asked 2020-09-25T08:35:17.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(22.400000000000002, 22%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Simone Pagliani
1
Reputation point
commented 2020-10-15T14:10:06.78+00:00
Simone Pagliani
1
Reputation point
6 answers
ORA-12541: TNS:no listener". (.Net SqlClient Data Provider)
Hello, I am having issue with connecting oracle from Sql Server using Linked Server. I have installed Oracle client and Sql Server on both the same server. I have tested TNSPING ORCL coming fine Blockquote C:\Windows\system32>TNSPING…
asked 2020-10-02T18:58:38.027+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, 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)
pdsqsql
391
Reputation points
commented 2020-10-15T00:06:45.73+00:00
Alexander Ivanov
491
Reputation points
3 answers
SSMA (SQL Server Migration Assistant) for MariaDB
I have on-premise MariaDB. I am Planning to migrate it to Azure SQL Database. Can i use SSMA (SQL Server Migration Assistant) for Migration??? Does SSMA supports MariaDB as source ??
asked 2020-07-09T11:54:32.753+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(118.4, 85%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Swapnil Solanki
1
Reputation point
answered 2020-10-14T23:43:46.333+00:00
Alexander Ivanov
491
Reputation points
1 answer
Using SSMA for oracle with user having READ ONLY permission
Hi, https://support.microsoft.com/en-in/help/2020711/you-may-get-permission-related-error-messages-when-using-ssma-for-orac With the reference to above link, we do understand the SSMA needs some additional permissions. Its mentioned as To obtain…
asked 2020-07-20T10:49:50.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(38.4, 71%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Madhavi Hardas
1
Reputation point
answered 2020-10-14T23:39:01.08+00:00
Alexander Ivanov
491
Reputation points
3 answers
One of the answers was accepted by the question author.
SSMA challenge with Oracle 0000-00-00 zero date fields
I am using the SSMA migration tool to migrate a large Oracle db to SQL Server 2016. In many of my Oracle date fields I have zero date values 0000-00-00 and records with these date values are not migrating over. I get a Arithmetic operation resulted in an…
asked 2020-09-22T22:36:08.823+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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
Becky Kent-Dobias
21
Reputation points
answered 2020-10-14T23:07:05.29+00:00
Alexander Ivanov
491
Reputation points
10 answers
One of the answers was accepted by the question author.
SSMA for Access - How can I figure out exactly what table and column or index these warning messages pertain to?
SSMA for Access - How can I figure out exactly what table and column or index these warning messages pertain to? A2SS0030 Identifier name might cause problems A2SS0030: Foreign key '{5A15D9A6-64CE-44B3-AD29-21EAF86F0328}' has a name that might cause…
asked 2020-09-11T09:48:48.66+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, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBA%3C/text%3E%3C/svg%3E)
Bob Alston
121
Reputation points
answered 2020-10-08T21:48:23.697+00:00
Alexander Ivanov
491
Reputation points
1 answer
One of the answers was accepted by the question author.
Connectivity to source DB2 database via SSMA for DB2
I have source database DB2 in IBM Bluemix platform, that need to be migrated on Azure SQL DB using SSMA for DB2. I am trying to make connectivity from SSMA to source DB2 database but not able to do so. I have a very basic question, does SSMA for DB2…
asked 2020-10-04T21:08:07.683+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(156.8, 0%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
jyoti tiwari
21
Reputation points
commented 2020-10-08T01:32:41.427+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
Getting error while trying to migrate data to Azure SQL Database from Oracle using the "SSMA for Oracle" tool
I am using the "SSMA for Oracle" tool to migrate Oracle databases to Azure SQL Databases. I am able to migrate the schemas. But I am getting the below error while migrating the data: Error occurred while inserting table information into the…
asked 2020-04-16T03:29:24.827+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, 87%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Navneet
1
Reputation point
commented 2020-04-16T23:41:09.663+00:00
Ronen Ariely
15,096
Reputation points