Explore SQL Server on Experts Exchange

Expert Solutions for Your Tech Problems

SQL ServerMicrosoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Se...

Read more
  • 171K Content
  • 16K Contributors

Expert Spotlight
Neha Nayal
Data Engineer

An IT Enthusiast

Troubleshooting Solution

SQL query to find MS Teams version

byLen Kally
5

I am new to SQL query language and learning this process. I am trying to get the MS Teams versions

…
Troubleshooting Solution

Server 2022/KB5035857 won't install

byRon Varnum
2

I have a Windows Server 2022 Standard server. It is running SQL 2019. Update KB5035857 refuses to

…
Research Solution

password policy for SQL server 2019/2022

bymarrowyung
26

hi,


in SQL server how can we control and enforce password policy in mandatory way?


e..g 

1) at least 8

…
Troubleshooting Solution

How to display values from Access DB in message box?

byLia Nungaray
3

I need to develop either a function or a module to check the contents of a table named Audit. The

…
Troubleshooting Solution

SQL Server Function does not return desired results only how many rows are affected.

byJamesNT
11

SQL Server 2022.


I have the following Scalar-valued Function:



As we can see, this function calls

…
Troubleshooting Solution

Connect to SQL application over VPN

byjkirman
5

Greetings,


I have an SMB client for whom I'm trying to perform a DR test.  The issue is coming up

…
Troubleshooting Solution

SQL Server 2019 with O365 database mail account -- email is not functioning.

bydbaSQL
3

SQL Server 2019.  Trying to setup Database Mail using O365.   TLS 1.2 is there, the O365 account

…
Troubleshooting Solution

Convert from a column in Excel to a consecutive list for transfer to SQL Server SSMS

byRUA Volunteer2?
3

The column of code comes from a column of numbers where the formula is applied to it.docxCode to

…
Troubleshooting Solution

Using MSXML2.ServerXMLHTTP with SQL Server status, statusText and responseHeader are all null

byPeter Dobbs
1

Dearest Obi Wan,


We've been using MSXML2.ServerXMLHTTP for a long time with SQL Server.

Recently it

…
Troubleshooting Solution

Replace FORMAT in SQL calculated field to make it deterministic

byCraig Beamson
7

I am trying to make a deterministic, persisted calculated column in SQL Server.

The tricky bit is

…
Research Solution

migrateSQL 2019/2022 on pre and oracle 12c/19c/20c  to Azure SQL

bymarrowyung
2

Hi,


Right now we have a plan to migration SQL 2019/2022 on pre to Azure SQL, please suggest the

…
Advice Solution

Stuck with SQL invalid columns

byPhillip Skeens
7

I am trying to create an audit table in MSSQL DB.  I want to add only the changes to the record from

…
Troubleshooting Solution

Correct Permission on specific SQL DB Table

bystrivoli
9

Users access SQL DB for SELECT and they are mapped as db_datareader, db_denydatawriter and public.

…
Troubleshooting Solution

ASP Classic - Display record once inside of LOOP

byWayne Barron
7

Hello, All.

I have run into an issue that is about to drive me up the wall.
I've made up a demo table

…
Troubleshooting Solution

Access with SQL server error over WIFI: "Connection is busy with results for another command"

byGontran Harvey
8
In an Access front-end with SQLserver tables links with ODBC, when the user in connected via wifi,
…
Troubleshooting Solution

New SQL error: UPDATE failed because the following SET options have incorrect settings: 'ANSI_NULLS, QUOTED_IDENTIFIER'

bywoodwyn
2

SQL stored procedures with SET ANSI_NULLS OFF or SET QUOTED_IDENTIFIER OFF started giving errors

…
Advice Solution

How to restore old database into server with currently same-named database?

byDarrin Moore
3

hi experts! 

we have a need to restore a sql database (SQL server v18.11.1) from several months ago.

…
Troubleshooting Solution

Trying to connect to SQL Server through VB

byhrolsons
11

I'm able to connect to my SQL Server using the below code:

    MyConnObj.Open _

        "Provider =

…
Troubleshooting Solution

SQLEXEC returns for some columns, width 0

byBenny Gabel
1

I am extracting via VFP from SQL server, using SQLEXEC
Some columns come empty, when displaying the

…
Research Solution

can SQL server 2022/2019 AlwaysON AG read scale out offload the CPU,network and disk loading for encryption

bymarrowyung
2

hi,


We planned to use SQL Server Column level encryption and we will use SQL 2019/2022 AlwaysON AG,

…

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more