17,979 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

SSRS 2016 allows the display of sensitive parameter in its URL such as Session state token

SSRS 2016 allows the display of sensitive parameter in its URL, such as Session state token. This can be used to manipulate the data being displayed allowing other resources information be visible to other users.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,806 questions
asked 2020-08-20T09:17:11.547+00:00
Ismael González Briongos 1 Reputation point
commented 2020-08-25T08:58:36.64+00:00
ZoeHui-MSFT 33,126 Reputation points
1 answer

Vulnerable and outdated Jquery and bootstrap version (Integrity)

SSRS 2016 uses vulnerable Jquery 3.3.1 and Bootstrap 3.3.5. A security assessment found that an attacker may use the vulnerable JavaScript framework version to perform malicious attacks. Assessment suggestion for remediation is patching or update to…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,806 questions
asked 2020-08-20T07:38:43.74+00:00
Ismael González Briongos 1 Reputation point
commented 2020-08-25T08:58:17.857+00:00
ZoeHui-MSFT 33,126 Reputation points
1 answer

Help creating a Report that Combines output of 2 tables and a Query

I'm not sure if this is even possible but wondering if anyone has any advice to help see if? Current doing this in Report Builder 3 I'm hoping to have a report out put something kinda like the below The goal is based on two other tables and…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,806 questions
asked 2020-08-18T05:02:27.477+00:00
Joshua Reynolds 1 Reputation point
commented 2020-08-25T08:56:46.123+00:00
ZoeHui-MSFT 33,126 Reputation points
1 answer One of the answers was accepted by the question author.

SQL job (email) alert to warn of disk getting full

I am trying to create an alert from SQL server to send me an email when the log or data files for a database are almost about to fill up the disk they reside on. Is anyone able to help with this?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-24T04:24:51.263+00:00
RayPaks 31 Reputation points
commented 2020-08-25T08:20:46.957+00:00
RayPaks 31 Reputation points
3 answers

Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'CONVERT'.

I have this table that I'm trying to convert "2004-06-08 00:00:00.0000000" Datetime to just Date mm/dd/yyyy. Each row has a unique date. This is the code that I used below. This "Msg 156, Level 15, State 1, Line 3 Incorrect syntax near…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-20T19:57:17.57+00:00
Chris Slinko 1 Reputation point
commented 2020-08-25T07:41:00.803+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
4 answers

Performance Issues SSAS tabular Matrix drill downs

When i drill down in a powerbi report or when i run the extracted Dax query from dax studio i get massive performance hits for certain queries (takes 10-12 seconds). I have tested these queries using a clear cache query and also monitored the Server the…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions
asked 2020-08-19T09:16:56.347+00:00
Datacrunk 1 Reputation point
commented 2020-08-25T07:01:08.87+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Backup Report for all the Servers - Connectivity issue

Hi, We are collecting Backup Report report from all the servers using SSIS job and storing into Sql 2008R2 Server Database table. We have Full Backup nightly job which is running on the all servers and we are capturing these backup infor from all the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-17T21:36:50.733+00:00
pdsqsql 391 Reputation points
commented 2020-08-24T20:13:26.943+00:00
pdsqsql 391 Reputation points
2 answers One of the answers was accepted by the question author.

sql permissions to run only update stats

hi all, we would like to give some business users with access to run only update stats. I am thinking of creating a role for these users and somehow assign them the rights to run "update stats" would you please share can I grant the users…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-24T19:36:09.74+00:00
NeophyteSQL 241 Reputation points
answered 2020-08-24T20:11:36.537+00:00
NeophyteSQL 241 Reputation points
3 answers

SCCM SUP SUSDB on sql express edition running out of disk space post every software update synch

We have setup a new SCCM secondary site which also hosts SUP SUSDB role configured on the SQL express edition which gets installed along with secondary. The problem is on monthly software update synch the SUSDB size crosses 10 GB limit & synch fails.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,170 questions
asked 2020-08-19T12:48:35.08+00:00
AKP 1 Reputation point
answered 2020-08-24T14:20:33.093+00:00
Adam J. Marshall 8,706 Reputation points MVP
2 answers One of the answers was accepted by the question author.

SSIS Sequence Containers

I have a SQL Server Integration Services package that has multiple sequence containers. If one sequence container fails, does the package stop? Is there a setting so that subsequent sequence containers will run even if one sequence container fails. …

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 2020-08-21T15:50:11.927+00:00
Michael Henderson 111 Reputation points
accepted 2020-08-24T14:01:18.757+00:00
Michael Henderson 111 Reputation points
3 answers

Why I am not able to restore TDE database?

Hello, I am running into an issue regarding restoring a TDE database and I just keep getting the "thumbprint not found error". I don't know what's causing it. Here are some details. I'm hoping someone can help me. I have many…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,554 questions
asked 2020-08-23T13:02:23.62+00:00
sidney l 1 Reputation point
commented 2020-08-24T13:20:28.797+00:00
sydney 1 Reputation point
2 answers

Error: adding node server while configuring Always On FCI

While adding node in configuring Always On FCI, I am getting Error: The credentials you provided for the sql server agent service are invalid.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-18T13:48:08.25+00:00
AMRITANSHU AMRITANSHU 1 Reputation point
commented 2020-08-24T09:51:22.587+00:00
Cris Zhan-MSFT 6,606 Reputation points
5 answers

MASSIVE Identity column value jump in SQL Server 2014

So in the middle of basic coding and testing we saw a huge non-patterned jump in Identity values for multiple tables. We are unaware of any server blips or attempted bulk operations, but DBAs are looking into logs. The gaps are not the typical 1,000 or…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-18T15:54:17.713+00:00
Mike Brown 1 Reputation point
commented 2020-08-24T09:49:33.467+00:00
Cris Zhan-MSFT 6,606 Reputation points
3 answers

Unable to download SQL Server 2019 Developer edition

Hello! I've just installed Windows 10 64bit edition. Now I'm trying to install SQL Server 2019 Developer edition. I downloaded SQL2019-SSEI-Dev.exe from official site and launched it. I chose Basic installation, agreed with the agreements, chose the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-18T14:26:56.15+00:00
Igor Baliuk 6 Reputation points
commented 2020-08-24T09:09:13.737+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

SQL Server Whitelisting For Mcafee Solidcore

Does anyone know of any list of Microsoft SQL Server ( version 2014 and 2016 ) executables and its associated files and DLLs that needs to be whitelisted from Mcafee Solidcore for it to work properly. This is for a Microsoft SQL server that will be…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-19T08:22:16.17+00:00
Mark Rizalito Aliggayu 1 Reputation point
commented 2020-08-24T09:06:37.27+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

sql server2019 cannot log in using Computer name in diffrent machine

There are two machines in LAN,Both have installed sqlserver service. All The sqlserver instance name is default. Now, They can login in each other using IP,But can not login in using Computer name. why?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-19T14:08:05.733+00:00
HuiSky 1 Reputation point
commented 2020-08-24T09:04:59.207+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

Database with master key

A Citrix database created with some Citrix Wem tool have a symmetric key where it was once created. Trying to move database no another server and is prevented to add to Availability group because of the master key. Been searching for this and as database…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-20T14:25:31.697+00:00
Jocke @home 1 Reputation point
commented 2020-08-24T09:02:59.51+00:00
CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
2 answers

How to log Connection string in SSIS

Hi, I have a package which runs from a SQL Server and connects to dozens of other instances on the network before running various scripts. I am getting a lot of SSIS Error Code DTS_E_CANNOTAQUIRECONNECTIONFROMCONNECTIONMANAGER Is there any way to…

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 2020-08-18T09:15:19.207+00:00
zoe Ohara 286 Reputation points
commented 2020-08-24T08:51:23.703+00:00
Monalv-MSFT 5,896 Reputation points
4 answers

How to import password protected Excel file into sqlserver using ssis

Hi All, I want to import password protected excel file into SQL Server using SSIS. Please help me

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 2020-08-19T07:36:18.593+00:00
vaishu 1 Reputation point
commented 2020-08-24T08:44:21.667+00:00
Monalv-MSFT 5,896 Reputation points
2 answers

SQL Server - How to keep DB access up while creating a bacpac file

First, we are a startup with a relatively big (14 GB) database and a small budget. We need a current, weekly would be ok, copy of the database for local use. The bacpac method works well, except that during the export process DB access slows to a crawl,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,754 questions
asked 2020-08-18T01:16:29.31+00:00
Kal Kallevig 1 Reputation point
commented 2020-08-24T08:03:54.76+00:00
m 4,271 Reputation points