SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,749 questions
1 answer
One of the answers was accepted by the question author.
sql server management Studio Generate scripts - programatically
Is there a way to to "generate" source of commnads of Generate Scripts dialogue? Eg. I have 200 tables but I want to export only 60 of them and I do not like to click it manually. I have a txt list of table. If it were a tsql commnad icon…
asked 2021-03-15T15:09:25.773+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(316.8, 72%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJV%3C/text%3E%3C/svg%3E)
Jan Vávra
231
Reputation points
commented 2021-03-16T10:40:18.567+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,301
Reputation points
1 answer
One of the answers was accepted by the question author.
How do you tell which is the most updated SQL database? The server that has the most recent entries.
Hi, I was given a server to manage my ERP, I have 5 databases siting on a server. How do you tell which is the most updated SQL database? Thank you.
asked 2021-03-16T04:00:44.817+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(192, 94%, 28%)' 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)
Joshua Tay
246
Reputation points
accepted 2021-03-16T10:19:36.993+00:00
Joshua Tay
246
Reputation points
1 answer
One of the answers was accepted by the question author.
'lead' is not a recognized built-in function name.
I am executing query in sql 2014 ,it is working fine ,but i am executing same query in 2008 it giving error Msg 195, Level 15, State 10, Line 22 'lead' is not a recognized built-in function name. Msg 102, Level 15, State 1, Line 40 Incorrect…
asked 2021-03-16T07:18:16.54+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(12.8, 75%, 11%)' 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)
Analyst_SQL
3,551
Reputation points
commented 2021-03-16T10:13:06.373+00:00
Analyst_SQL
3,551
Reputation points
4 answers
sql 2016 alwayson question about failover
Hi guys, i have this question. we have 2 sql 2016 standard with some databases replicated with basic alwayson. So last night the primary server crashed (BSOD and reboot) and the secondary sql has started the failover. This morning i have done a manual…
asked 2021-03-15T13:19:44.48+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, 48%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
geradmin
1
Reputation point
commented 2021-03-16T09:28:10.247+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Server 2008 SP3: There are no SQL Server instances or shared features that can be updated
I'm currently using SQL server 2008 SP3 10.0.5500.0 (2008 SP3) Express Edition I've been trying to upgrade the build version from 10.0.5500.0 to 10.0.5538.0 but there is an error shown below when I used this KB2977321. Error: There are no SQL Server…
![](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(70.4, 59%, 16%)' 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)
2 answers
SQL server anonymous authentication error - issue setting up constrained delgation
I'm facing anonymous authorization issues that appear to be related to a delegated TGT that expired and coudn't be renewed. There is an event log entry (EventID 18) on the middle tier SQL instance (SQLInstanceA) that references an expired TGT and the TGT…
asked 2021-03-09T19:57:35.393+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(192, 45%, 28%)' 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)
Luke
1
Reputation point
commented 2021-03-16T08:57:50.923+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Group Every 3 Years?
Hi Everyone. I'm having trouble trying to get my data to display properly. For every three years, I need to add the year to a new group. Here's an example: 2018 - 1 2019 - 1 2020 - 1 2021 - 2 2022 - 2 2023 - 2 2024 - 3 2025 - 3 2026 -…
asked 2021-03-15T21:21:23.35+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(19.2, 97%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECB%3C/text%3E%3C/svg%3E)
Chris Bridge
21
Reputation points
commented 2021-03-16T08:08:29.13+00:00
ZoeHui-MSFT
33,126
Reputation points
2 answers
One of the answers was accepted by the question author.
Can you load and store data into an SSAS Cube?
Hello, I need to find a way to load data into an SSAS cube (preferably tabular) which can then be opened on a different computer (via USB transfer). Is it possible to "store" data into cubes and then open them on different devices via power…
asked 2021-03-15T18:32:25.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(243.2, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Chase G
21
Reputation points
answered 2021-03-16T08:02:47.817+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, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,816
Reputation points
3 answers
Why Azure data factory is throwing error when pulling data from on premise sql server?
Dear All, I am new in Azure Data Factory, and trying to pull data from on premise SQL Server database AdwentureWorks2019 Employee Table. When I loaded same Employee data into csv file on Azure Blob storage, its get succeeded very easily. But…
asked 2021-03-12T16:14:43.303+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(240, 45%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESO%3C/text%3E%3C/svg%3E)
Sonu Ojha
1
Reputation point
commented 2021-03-16T05:43:04.51+00:00
CarrinWu-MSFT
6,856
Reputation points
1 answer
Siebel Migration from Oracle Platform to SQL Server
We have Siebel 19.11 version on Oracle DB Version 12.2 on Linux OS. We would like to migrate this setup from Oracle to SQL Server with Windows Servers. Please provide any documentation specific to Siebel Migration from other DBs to SQL Server with OS…
asked 2021-03-12T06:55:51.587+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, 25%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Srinivas Kammari
1
Reputation point
commented 2021-03-16T05:40:51.577+00:00
CarrinWu-MSFT
6,856
Reputation points
2 answers
Initial size of the log file is changing back to its original size.
I have a database whose log file initial size is 1MB, I have changed it to 4MB. But when I check the initial size after some time its size shows again to 1 MB. The auto shrink option is set to false for the database. Could any please let me know why it…
asked 2021-03-11T13:50:44.583+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(60.8, 70%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TheDBLearningGuy
171
Reputation points
answered 2021-03-16T02:01:23.367+00:00
CarrinWu-MSFT
6,856
Reputation points
2 answers
Case When with Over Partition
Hi, I am trying to so a CASE statement with an over partition (if it's possible), but struggling to get the correct syntax for it. Is anyone able to please help me with this? case when a.top_key in ('85','99','129','142') over (partition by…
asked 2021-03-12T11:49:41.187+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, 40%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bone_12
361
Reputation points
commented 2021-03-16T01:47:54.413+00:00
MelissaMa-MSFT
24,176
Reputation points
3 answers
One of the answers was accepted by the question author.
Simple MS Access DB with thin front end on MS Azure
My Organisation currently has a simple MS Access application with a size currently around 5MB and future growth is expected to be around another 5-10 MB per year. They wish to have this migrated to the cloud so that a website can communicate with this…
asked 2021-03-12T20:00:25.58+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(249.60000000000002, 30%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Anil Nanu
21
Reputation points
answered 2021-03-15T22:15:46.86+00:00
Erland Sommarskog
101.2K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
How to get partid that have two category and exist on 2000,2200 ?
How to get partid that have two category for same part and exist on 2000,2200 ? I work on sql server 2012 i face issue i can't get partid that have two category for same part and these two category must be on category 2000 and 2200 as partid…
asked 2021-03-15T20:13:37.057+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(262.40000000000003, 77%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
ahmed salah
3,216
Reputation points
accepted 2021-03-15T20:51:50.287+00:00
ahmed salah
3,216
Reputation points
3 answers
One of the answers was accepted by the question author.
Visual Studio 2019, SSIS Script Task Error: The binary code for the script is not found. Build does not help.
I believe this is a bug. *The first mistake a made was accepting the upgrade from Visual Studio when prompted. This is what I have done: Opened an existing Script Task on a package that was working and has been built and tested. Click Edit Script.…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,619 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,455 questions
asked 2021-03-05T19:28:58.25+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(256, 20%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Elaena Bakman
31
Reputation points
accepted 2021-03-15T17:55:07.03+00:00
Elaena Bakman
31
Reputation points
2 answers
One of the answers was accepted by the question author.
DateDiff Error
Hi, I have a DATEDIFF query but upon executing my code, I get an error message that I am unsure how to resolve, any ideas please? Arithmetic overflow error converting expression to data type datetime.strong text DATEDIFF(month, Comp_Date,…
asked 2021-03-15T13:44:28.403+00:00
Bone_12
361
Reputation points
answered 2021-03-15T15:22:46.273+00:00
tibor_karaszi@hotmail.com
4,301
Reputation points
1 answer
One of the answers was accepted by the question author.
SSMS Extension Development
I'd like to bind additional options to the results view in SSMS via extension development. I utilize SSMS regularly for work and it's a fantastic tool. I was curious whether it'd be viable for me to add additional context menu items through extension…
asked 2021-03-11T00:01:10.937+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(86.4, 31%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFR%3C/text%3E%3C/svg%3E)
Francis Rohner
21
Reputation points
accepted 2021-03-15T12:49:33.19+00:00
Francis Rohner
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Configure 100 database on Azure PAAS Service and SSRS need to be configured on it
We have two on-premise SQL Server (Azure SQL VM) and each server has 70+database. We are already in Azure and we need to move to Azure PAAS, but the issue is we want SSRS as well. Now, Azure SQL MI has limitation of 100 database only and Azure SQL DB…
asked 2021-03-05T12:05:14.913+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(160, 57.00000000000001%, 25%)' 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)
Sarvesh Pandey
141
Reputation points
accepted 2021-03-15T11:59:14.17+00:00
Sarvesh Pandey
141
Reputation points
3 answers
One of the answers was accepted by the question author.
Error running a Stored SSIS Process created by 64 bit import wizard
Hi All, I am using SSMS (SQL Server 2019 Developer Edition - Latest Build) Windows 10 & Office 2010 (64 Bit) I have an existing Table (with historic data) in one of my server instances and I frequently need to add data to this table. …
asked 2021-03-11T03:54:22.21+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, 99%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIB%3C/text%3E%3C/svg%3E)
Imran Buhary
96
Reputation points
accepted 2021-03-15T09:51:46.177+00:00
Imran Buhary
96
Reputation points
5 answers
ODBC Driver for SQL Server - SQlite3 interfacing with SQL Server
I have the sqlite3 installed in my Windows 10 64-bits. In order to have communication between sqlite3 and other Windows apps, I installed the SQLite3 ODBC Drivers (from www.ch-werner.de/sqliteodbc). Until now I have accomplished to connect the…
asked 2021-03-10T15:47:14.87+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(246.4, 21%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
JDias
71
Reputation points
answered 2021-03-15T08:17:20.487+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor