SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,732 questions
2 answers
SQL management studio v17.9.1
I got this restoring stuck here for our testing database. can't log into our ERP system right now. How to stop and don't lose anything? urgent help. THANK YOU!
asked 2021-02-08T19:36:39.637+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(265.6, 96%, 35%)' 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)
Molly
1
Reputation point
answered 2021-02-09T03:14:31.607+00:00
CathyJi-MSFT
21,096
Reputation points Microsoft Vendor
1 answer
SSAS Tabular model compatibility error
Hi, When i am going to deploy SSAS tabular model, i got this error, can anybody please help me to solve this problem, i am using SQL Server developer 2014 edition and SSDT 2017. "Cannot deploy to server localhost. Reason: The destination server…
asked 2021-02-06T23:32:18.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(316.8, 91%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAZ%3C/text%3E%3C/svg%3E)
ali zubair
21
Reputation points
answered 2021-02-09T02:19:17.36+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
Always On - Active/Passive Config
Hello, Please clarify for me this doubt I have about Always On - Active/Passive. I have 2 servers which are part of a WSFC. I have installed SQL 2017 Enterprise on both nodes separately. Not as a failover cluster. I set up an AG group, added…
asked 2021-02-08T19:52:56.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(128, 67%, 22%)' 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)
Veena Srinivas
251
Reputation points
answered 2021-02-09T02:11:24.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(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,606
Reputation points
3 answers
How to display size feature on final result where partc and partx not have same feature ?
I work on SQL server 2012 I face issue i can't display feature size on final result query this happen when replace temp table partc and part x not have value to same feature as size feature but if part c and partx have same feature no problem it is…
asked 2021-02-08T02:03:17.927+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
commented 2021-02-09T01:44:10.193+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(236.8, 76%, 32%)' 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)
EchoLiu-MSFT
14,571
Reputation points
0 answers
Field which can lookup against multiple tables
I have a SQL Database with multiple tables of similar but distinct data (e.g.: Workstations, Virtual Servers, Physical Servers, Switches, ...) All these tables have Primary Keys defined the same in the CREATE TABLE statement: ID UNIQUEIDENTIFIER…
asked 2021-02-08T17:37:32.677+00:00
Gary Burch
1
Reputation point
commented 2021-02-08T22:40:35.083+00:00
Erland Sommarskog
101K
Reputation points MVP
5 answers
One of the answers was accepted by the question author.
Resource governor: How to write a classifier function?
Dear colleagues, Our management wants a start screen with tiles for certain tasks. Each tile must show a number. The user (or an application manager or super user) must have the option of writing a query that produces a number to be shown on the tile.…
asked 2021-02-04T16:26:02.723+00:00
Chris Sijtsma
106
Reputation points
commented 2021-02-08T22:04:22.423+00:00
Erland Sommarskog
101K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Installing SQL Native Client 2012 on Windows Sandbox
Hello, I'm trying to install SQL Server 2012 Native Client using the 64-bit sqlncli.msi downloaded from here onto a Windows Sandbox environment. I get a missing DLL error whenever I reach the removing backup files step of the wizard. …
asked 2021-02-05T21:14:09.8+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, 32%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Joshua Brock
21
Reputation points
accepted 2021-02-08T20:52:41.337+00:00
Joshua Brock
21
Reputation points
3 answers
One of the answers was accepted by the question author.
Excel SQL not updating
Hello I created some pivot tables in Excel based on data from SQL table imported via Power Query (and upload in the Data Model). The data in the SQL table is changed daily but the Excel pivot tables do not pick up the update, every time I refresh the…
asked 2021-01-26T11:18:18.607+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, 45%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Alina alina
26
Reputation points
accepted 2021-02-08T17:38:17.487+00:00
Alina alina
26
Reputation points
4 answers
One of the answers was accepted by the question author.
SQL Server 2019 SSMS 18.8 Getting error running builtin Standard report
This is a newly install SQL engine with SSMS 18.8. When I try to run any of the Standard reports like Disk Usage and same thing when running the integration standard report I get the following error.... TITLE: Microsoft SQL Server Management Studio An…
asked 2021-01-18T20:03:48.293+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, 30%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Meunier, Alex
101
Reputation points
accepted 2021-02-08T16:59:02.417+00:00
Meunier, Alex
101
Reputation points
3 answers
One of the answers was accepted by the question author.
Resize the width of a report table by using a parameter
Good evening I have a report that uses a table to display a list of orders. This report includes a Boolean parameter used to hide/show two columns in that table. When true, the two columns are displayed. When columns are displayed, the table occupies…
asked 2021-01-29T17:43:48.847+00:00
Mario Formosa
41
Reputation points
answered 2021-02-08T16:41:48.817+00:00
Mario Formosa
41
Reputation points
3 answers
One of the answers was accepted by the question author.
Calendar style report
Hey Guys, I'm looking into creating a 2 dimension table report. On the left side I need different time stamp and on the top I need to have the lists of my different parks. Then in the middle I would put the different activities for that park at that…
asked 2021-02-05T14:29:46.467+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(236.8, 49%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jean-François Handfield
101
Reputation points
answered 2021-02-08T16:09:45.357+00:00
Jean-François Handfield
101
Reputation points
2 answers
One of the answers was accepted by the question author.
is it possible to output the trace using Invoke-ASCmd
Hello, trying to capture log processing cubes in tabular mood using Powershell script and we are using Invoke-ASCmd. I know it is possible to be done without Invoke-ASCmd. thanks for all the help in advance.
asked 2021-02-01T20:20:26.013+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(278.4, 48%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mina Kamel
101
Reputation points
commented 2021-02-08T15:31:07.957+00:00
Mina Kamel
101
Reputation points
3 answers
SQL Server always on , one of the nodes down
hi all, we had high availability always on clustering set up one of the nodes could not be booted up, so it is down. ever since the cluster has only one node. but there are errors in the windows log and informational messages in the sql server…
asked 2021-01-29T19:41:55.903+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(172.8, 99%, 26%)' 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)
NeophyteSQL
241
Reputation points
answered 2021-02-08T15:09:30.67+00:00
NeophyteSQL
241
Reputation points
0 answers
async Task InitializeAsync() throwing error about the SQLite.Create flags when trying to set up SQLite with my Xamarin project
I have been following this tutorial: https://learn.microsoft.com/en-us/xamarin/xamarin-forms/data-cloud/data/databases to set up a local db for my application in xamarin. However, I keep experiencing the errors: 'Argument 1: cannot conver…
![](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, 27%, 18%)' 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)
1 answer
One of the answers was accepted by the question author.
mssql how do i do c and rest of a
A) A functon that accepts a letter from the user, and returns the sum of sickleavehours of all employees whose last name starts from this letter. B) A function that accepts a letter from the user, and returns the sum of vacationhours for all employees…
asked 2021-02-06T16:36:33.073+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, 71%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BILIRIS MICHAIL
21
Reputation points
accepted 2021-02-08T14:56:42.623+00:00
BILIRIS MICHAIL
21
Reputation points
3 answers
One of the answers was accepted by the question author.
SSRS Evaluating an expression used to set default parameter value
I have this expression to set the parameter default values - how can I evaluate it without running the report? =DateAdd(DateInterval.Month, -1, DateSerial(Year(Date.Now), Month(Date.Now), 1))
asked 2021-02-05T16:21:39.08+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(51.2, 79%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERV%3C/text%3E%3C/svg%3E)
Ramon Venegas
21
Reputation points
accepted 2021-02-08T14:53:03.337+00:00
Ramon Venegas
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Daily Folders Backups Power BI Report Server
Hi, We have daily backups folders on the servers where PowerBIReport Server is installed. It is important to backup this folder: C: \ Program Files \ Microsoft Power BI Report Server \ PBIRS \ ASEngine \ workspaces \ Can we ignore it? just backup…
asked 2021-01-26T17:01:13.953+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(144, 76%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Luís Filipe Ramada
21
Reputation points
accepted 2021-02-08T14:31:28.2+00:00
Luís Filipe Ramada
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Need to process SSAS on prem Model using ADF v2
Hi, We have created SSAS tabular model and we are processing using agent jobs . we have adf v2 for ETL process . Problem :- we have to trigger manually agent job post adf pipeline finish . and we need to automate cube processing using adf v2 …
asked 2021-02-05T14:05:38.967+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, 66%, 21%)' 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)
Ravi Shukla
21
Reputation points
accepted 2021-02-08T13:11:32.977+00:00
Ravi Shukla
21
Reputation points
0 answers
sql server: clean database pages from buffer
How to clean all database pages from the buffer. I ran below commands checkpoint dbcc dropcleanbuffers and still when I am reading some data from the database it is showing logical reads means pages read are from memory not from disk.…
asked 2021-02-06T09:03:24.727+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(220.8, 11%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Chirag Sachdeva
281
Reputation points
commented 2021-02-08T09:20:10.85+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,961
Reputation points Microsoft Vendor
3 answers
SQL Server Access/Connection issue
When I install my software on a machine that is connected to a domain, I never have an issue opening my software from a connection string within my software and opening the license table to read the licensekey using the connetionstring through registry…
asked 2021-02-05T14:11:17.847+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(275.2, 3%, 36%)' 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)
MR BILL
256
Reputation points
commented 2021-02-08T09:19:23.593+00:00
Cris Zhan-MSFT
6,606
Reputation points