18,372 questions with SQL Server-related tags

Sort by: Updated
3 answers One of the answers was accepted by the question author.

EXEC sp_updatestats.

Hi everyone! Why is the date not updated after executing the command 'EXEC sp_updatestats;' on the database? All help is welcome!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-09-02T02:34:42.777+00:00
Doria 1,246 Reputation points
answered 2020-09-02T12:36:23.43+00:00
Doria 1,246 Reputation points
1 answer

How to get data from a Web Service that has HTTPS, SOAP and WSDL with an SSIS Project

I need to get data from a Web Service that has HTTPS, SOAP and WSDL configuration. Tried following this tutorial https://www.mssqltips.com/sqlservertip/3272/example-using-web-services-with-sql-server-integration-services/ , but stopped on the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,490 questions
asked 2020-08-28T14:58:55.027+00:00
Gustavo Branco Goncalves 1 Reputation point
commented 2020-09-02T09:51:05.557+00:00
Monalv-MSFT 5,896 Reputation points
1 answer One of the answers was accepted by the question author.

Can't schedule an exam (link goes into a loop) 70-764

Hey , As soon as I want to schedule an exam (https://learn.microsoft.com/de-de/learn/certifications/exams/70-764), the following page got into a loop (reloaded every time, nothing happens.) I only see a white window. I am logged in with my MS account!…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-09-02T08:25:33.98+00:00
EY 21 Reputation points
accepted 2020-09-02T09:42:13.133+00:00
EY 21 Reputation points
2 answers

What's wrong with my AlwaysOn?

Hi, I'm setting up an Always On following the whole procedure I found in other laboratories and I notice that mine happens differently. The database goes online only after I run it (Join to Availability Group ...) What can be wrong? I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-09-01T05:32:30.477+00:00
Salves 501 Reputation points
commented 2020-09-02T09:37:12.783+00:00
Shashank Singh 6,246 Reputation points
3 answers

Page flag and Page flag description for sys.dm_db_page_info

anyone know the details about the following column ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-08-24T09:55:15.97+00:00
sakuraime 2,321 Reputation points
answered 2020-09-02T08:58:37.93+00:00
CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Advice to select the best employee business key

Hi, I'd like to get your opinion/advices to select the best employee business key in our system. I work on a multi-country, multi-company data warehouse project. You may find different HR systems all around the world, so I have to choose the appropriate…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-08-31T15:22:08.553+00:00
Franck GUSTIN 21 Reputation points
commented 2020-09-02T08:28:58.67+00:00
Franck GUSTIN 21 Reputation points
1 answer One of the answers was accepted by the question author.

After session kill, T-log's size are increasing.

I have huge DB and Table. T-log used percent was high because of delete table.. so I killed the session. But killed session is remained 'killed/rollback' status. I checked below query for check log use cause.. SELECT tst.[session_id], …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-08-27T06:50:28.14+00:00
okjin lee 21 Reputation points
commented 2020-09-02T07:55:15.367+00:00
okjin lee 21 Reputation points
1 answer

SSRS - Report Model - convert XML to SQL?

Hi. I have a series of SSRS reports written against a report model. In report builder the dataset shows the XML which has been generated. Question is, can i convert the XML to SQL? Reason for asking is that I want to delete my report model and just…

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,849 questions
asked 2020-08-27T08:12:12.637+00:00
Edward Turner 1 Reputation point
commented 2020-09-02T07:53:27.843+00:00
ZoeHui-MSFT 34,581 Reputation points
2 answers One of the answers was accepted by the question author.

Can i do http request via the custom function which created by clr?

Can i do http request via the custom function which created by clr?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,580 questions
asked 2020-09-01T14:59:17.37+00:00
mitaraiqueen 21 Reputation points
accepted 2020-09-02T07:08:42.297+00:00
mitaraiqueen 21 Reputation points
3 answers

Maintaining tablix width when hiding some columns in rdlc report

In our project, we got some rdl files that contains dynamic column, User can decide which to show or which to hide by a Multi-Selection Report Parameter. then it comes some problems: 1.if there is a report contains 10 columns, when the user selected 5…

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,849 questions
asked 2020-08-28T10:27:36.42+00:00
akshay kumar 1 Reputation point
answered 2020-09-02T06:16:26.42+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

AlwaysOne see all the bases on the primary server? Why?

Hi, when i access a listerner i see all the bases of the primary server. I notice that I see the base that was synchronized and also all the others that were not synchronized. Is that so by design? Did I imagine that it would only show 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.
13,095 questions
asked 2020-08-31T01:53:26.717+00:00
Salves 501 Reputation points
commented 2020-09-02T06:10:18.767+00:00
CathyJi-MSFT 21,111 Reputation points Microsoft Vendor
2 answers

SQL 2017 Scheduled Maintenance Plan job

I created a reoccurring scheduled SQL maintenance job with my login account (myNetwork\myUsername) but the it fails each time. The Windows Application log states that the following: SQL Server Scheduled Job 'MaintenancePlan_FULL_Backup.Subplan' -…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-08-29T15:45:09.28+00:00
kescott 21 Reputation points
commented 2020-09-02T05:47:39.237+00:00
Cris Zhan-MSFT 6,611 Reputation points
5 answers

SQL Server: Restoring database from a remote location directly vs. copy .bak file and then restore

SQL Server: Restoring database from a remote location directly vs. copy .bak file and then restore Will anybody know why restoring directly from a LAN location is far faster than the total time require for copying the .bak file first and then…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-08-27T23:41:29.643+00:00
travisGatesMcGee@hotmail.com 21 Reputation points
commented 2020-09-02T05:43:18.897+00:00
Cris Zhan-MSFT 6,611 Reputation points
3 answers One of the answers was accepted by the question author.

Unable to install sql server 2017 developer editiion x64 windows 10 Pro

Need Help with Following Error : 21623-summary-etpld023-20200831-202936.txtMicrosoft SQL Server 2017 Setup ------------------------------ The following error has occurred: There is a problem with this Windows Installer package. A DLL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-08-31T15:07:48.39+00:00
Ravi G Singh 21 Reputation points
commented 2020-09-02T04:50:21.14+00:00
Ravi G Singh 21 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Serverログオン不可が頻発(Error: 17189, Severity: 16, State: 1.)

【環境】 Microsoft Windows Server 2012 R2 Standard DBサーバーに対しSQL Serverの最大サーバメモリは、4096(MB)を設定しております。 ---systeminfo--- 物理メモリの合計: 8,191 MB 利用できる物理メモリ: 1,168 MB 仮想メモリ: 最大サイズ: 13,162 MB 仮想メモリ: 利用可能: 3,419 MB 仮想メモリ: 使用中: 9,743 MB 【質問内容】 …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-09-01T01:21:10.083+00:00
悠 高島 81 Reputation points
answered 2020-09-02T00:49:52.437+00:00
悠 高島 81 Reputation points
4 answers One of the answers was accepted by the question author.

How can i deny access to any sql management from lan and public network?

Hello, Can i deny access to any sql management from lan and public network? I mean the user SA to be able to be used to read and write in the bases but not to connect with the sql management or similar app. Thank you, Giorgos

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,095 questions
asked 2020-08-30T16:20:32.52+00:00
Stefanos Spyridakis 21 Reputation points
commented 2020-09-01T21:17:21.167+00:00
Erland Sommarskog 103.7K Reputation points MVP
2 answers

SSRS Email settings

Hi, SQL Server 2012 Standard I dont see the column for entering authentication details for smtp server under email settings of SQL Reporting server configuration window. I edited the configuration file and added the userName and Password tags in…

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,849 questions
asked 2020-08-18T18:02:46.327+00:00
Ashru 41 Reputation points
commented 2020-09-01T15:11:41.197+00:00
Ashru 41 Reputation points
2 answers One of the answers was accepted by the question author.

Query to find list of all primary keys and check if they are clustered and if they are on uniqueidentifier column

Dear Experts, I have this requirement to query all the tables in my database to check if the tables have clustered indexes on the primary key and if the key column is an uniqueidentifier. I prepared this script below select o.name as TableName ,…

Azure SQL 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.
13,095 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,580 questions
asked 2020-09-01T11:16:02.677+00:00
mo boy 396 Reputation points
commented 2020-09-01T13:01:50.353+00:00
Dan Guzman 9,221 Reputation points
1 answer

Multidimensional Project Data Source Wizard Fail SSAS

Hello, I'm trying to create a data cube in Visual Studio (SSDT) and I'm unable to launch Data Source Wizard. When I select New Data Source, I see the wizard, but when I click Next, the wizard dissapears. Has anyone faced such issue? Could this be…

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,256 questions
asked 2020-08-24T06:15:44.097+00:00
Green Tree 1 Reputation point
commented 2020-09-01T09:17:26.403+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Suppress Zeros and Empty Rows and Columns by using MDX

Hi, following is my MDX. Still getting zero rows and columns. how to remove zero rows and columns. Select Non Empty CrossJoin( CrossJoin( {{[Account].& [1]}, {[Account].& [2]}, {[Account].& [3]}}, {{[Measures].[YTD]}, …

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,256 questions
asked 2020-08-24T12:16:55.68+00:00
Narendra Reddy 1 Reputation point
commented 2020-09-01T09:13:34.507+00:00
Lukas Yu -MSFT 5,816 Reputation points