SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,734 questions
5 answers
One of the answers was accepted by the question author.
Basic Availabilty
Dear Experts, Can you please help with the fact that does SQL 2019 Standard edition basic availability group support more than one databases i.e. one database per availability group. This way if there are 3 databases - 3 availability group's can be…
![](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, 60%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
ssrs drill thru to a report in a different folder
hi we run 2014 developer in our dev environment and we use vs 2017 to develop reports. I want to drill thru from my report A to a report B in a different folder. right now i have my report drilling thru to itself. and have deployed it to our dev…
![](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(41.6, 70%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
9 answers
Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database 'dbName'. [CLIENT: <local machine>]
I'm getting this error every night at 8:33PM. The NT AUTHORITY\SYSTEM is also added to the SQL Server Security/Login with Sysadmin permission. Login failed for user 'NT AUTHORITY\SYSTEM'. Reason: Failed to open the explicitly specified database…
asked 2021-02-02T14:48:01.697+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' %3EC%3C/text%3E%3C/svg%3E)
CharlieLor
551
Reputation points
commented 2021-02-05T21:59:49.167+00:00
Erland Sommarskog
101K
Reputation points MVP
3 answers
How to store the result of **DBCC PDW_SHOWSPACEUSED("dbo.TableName")** in a Temporary table in Parallel Data Warehousing (APS PDW)?
How to store the result of DBCC PDW_SHOWSPACEUSED("dbo.TableName") in a Temporary table in Parallel Data Warehousing (APS PDW)? Below is my query which is not working. create table #TempSpace( [ROWS] bigint, RESERVED_SPACE bigint, …
asked 2020-10-03T11:36:04.993+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(0, 74%, 10%)' 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)
Sunny Singh
1
Reputation point
answered 2021-02-05T21:13:05.433+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, 66%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Anthony Perkins
1
Reputation point
1 answer
bottom line on cascading parameter nuances
hi we run 2014 developer in our dev environment. i've always been under the impression that with cascading parameters, there's a possibility of a drop down somewhere in the "chain" acting funny. Even if that behavior is by design. i've…
3 answers
One of the answers was accepted by the question author.
Script table components but not table itself.
Greetings. I need to drop/ recreate > 250 tables w LOB data to a new filegroup, as this is the only way to reclaim unused space for the files in that filegroup. The common approach for dealing w this is to 1) export the data to a new table in the…
![](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(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
3 answers
SQL Server Error in SCCM
Good Afternoon Team. In my client I have a lot of SQL server alerts, I don't know why this is happening and I don't know where to start. Can you help me please? Thank you.
asked 2021-02-04T20:25:34.557+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' %3ERA%3C/text%3E%3C/svg%3E)
Rafael Aguilar
496
Reputation points
answered 2021-02-05T17:57:43.04+00:00
Rafael Aguilar
496
Reputation points
5 answers
Login Failed
I have recently installed SQL Express 2019 with SMSS. I now have a database that I want to connect to with Visual Basic. When I attempt to connect to the database I get the message below. I have been unable to find out where I need to go to…
asked 2021-02-03T01:36: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(12.8, 51%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGW%3C/text%3E%3C/svg%3E)
Glenn Walker
251
Reputation points
answered 2021-02-05T16:50:55.77+00:00
Glenn Walker
251
Reputation points
3 answers
One of the answers was accepted by the question author.
Only 3 stored procedures are presented to me in the SSRS designer when I am trying to create a dataset
Only 3 stored procedures are presented to me in the SSRS designer when I am trying to create a dataset. There should be 30+ stored procedures to choose from. Why is this happening?
![](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, 82%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Get Cube size error
Hello, I have a script that was working just fine to and the functionality of it was to obtain the size of the cubes from SSAS and compare it to the trash hold that is set. we have upgraded our system from windows server 2016 to 2019 and I start…
asked 2021-02-03T16:38:27.017+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
accepted 2021-02-05T13:34:12.657+00:00
Mina Kamel
101
Reputation points
2 answers
One of the answers was accepted by the question author.
SQL Server Availability Groups - Asynchronous Commit Without Data Loss
The basic documentation for availability groups where the secondary replica uses an asynchronous commit method states that there may be data loss which is further explained in the documentation. Is there a technique that can be leverage to guarantee no…
asked 2021-02-02T17:00:37.963+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, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
Jim Nguyen
61
Reputation points
commented 2021-02-05T13:03:50.077+00:00
Jim Nguyen
61
Reputation points
2 answers
One of the answers was accepted by the question author.
Adjust T-SQL query to include DateTime (TimeStamp)
Hi Guys, I need some help with adjusting an existing query to to include a TimeStamp, which is actually the "DateTime" column in one of the views (vEvent, System Center Operations Manager Data Warehouse). Long story short - I needed help…
1 answer
One of the answers was accepted by the question author.
Add column of Closing_Qty and Closing_Weight,sum column total in footer
Below is query ,which is giving result of date wise ,but i want to add two column of Closing_Qty and Closing_Weight ,sum total of each column display in footer. DECLARE @StartDate date = '03-06-2020'; DECLARE @enddate date = '05-06-2020'; …
asked 2021-02-03T07:05:21.97+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
accepted 2021-02-05T09:54:15.697+00:00
Analyst_SQL
3,551
Reputation points
1 answer
Execute SQL Tasks upon executing clear local variable value in SSDT 15 for VS-2015
I have SSDT package migrated from Win-7 desktop (SSDT-2012) to Win-10 Ent desktop (SSDT-2015 with VS-2015). When I debug the SSDT package in SSDT-2015, one Execute SQL task, upon successful execution clears local variable values. This Execute SQL…
asked 2021-01-28T12:12:03.943+00:00
Abhijeet J. Patil
1
Reputation point
commented 2021-02-05T09:37:08.857+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, 37%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Monalv-MSFT
5,896
Reputation points
1 answer
Error Power Query Source in SSIS
I have a error when using a Power Query in SSIS, the details of the error is as following. IF anyone has a solution for this, please help [Power Query Source [2]] Error: System.Runtime.InteropServices.COMException (0xC0047072): Exception from HRESULT:…
asked 2021-01-29T07:25:01.053+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(140.8, 8%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Tommy Trung Ngo Quang
1
Reputation point
commented 2021-02-05T09:34:21.893+00:00
Monalv-MSFT
5,896
Reputation points
4 answers
Getting notified when package fails
Hi, I have a solution that has a large number of packages. The solution is designed in a way that calls 5 packages dynamically. If once of the packages fails, the other 4 pipelines keep working. I would like to know how can even the…
asked 2021-01-29T13:59:39.123+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(102.4, 6%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Astrid o
1
Reputation point
commented 2021-02-05T09:33:08.247+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Package failure due to physical memory and paging file
Hi, When I run my package am getting an error. Error: The system reports 79 percent memory load. There are ..... (some number) bytes of physical memory with (some number) bytes free. There are (some number) bytes of virtual memory with (some number)…
asked 2021-01-30T12:01:18.977+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, 22%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
dinesh
41
Reputation points
commented 2021-02-05T09:32:19.37+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
Memory error
A buffer failed while allocating 205360000 bytes. The Data Flow task failed to create a buffer to call PrimeOutput for output "ADO_SRC PROJECT" (2) on component "Output" (10). This error usually occurs due to an out-of-memory…
asked 2021-02-02T16:27:11.503+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(80, 27%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
John Schroeder
1
Reputation point
commented 2021-02-05T09:29:51.157+00:00
Monalv-MSFT
5,896
Reputation points
1 answer
SSIS Execute SQL task not returning results
I have created a SSIS Package with a Execute SQL Task. I return a count from a query to a User:Variable Int32. The query is "SELECT COUNT(*) As RecCnt FROM dbo.Trace_Return_BRE WHERE (BatchId = ?)". The input Variable is a INT32. The input…
asked 2021-02-03T02:02:45.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(172.8, 7.000000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWB%3C/text%3E%3C/svg%3E)
William Burke
1
Reputation point
commented 2021-02-05T09:28:51.52+00:00
Monalv-MSFT
5,896
Reputation points
2 answers
Issue when loading special characters from sybase ASE to SQL server
I have a SSIS Package with Data flow task that has ODBC source and SQL server destination to load data from sybase ASE to SQL server. Its a direct data load without any transformation. We have a char datatype with a special character in the data where…
asked 2021-02-02T07:37:32.433+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, 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)
Poornima
21
Reputation points
commented 2021-02-05T09:26:09.887+00:00
Monalv-MSFT
5,896
Reputation points