Questions tagged [sql-server]
Tag with [sql-server] the question related to each database server that implements SQL (Structured Query Language) and not related with the specific Microsoft one. For the latter use the specific tag [ms-sql], or if related with a specific version with the relative tag [sql-server-2012], [sql-server-2008]...
773
questions
0
votes
1
answer
287
views
"Operating System is not configured to use this application" when migrating a DB using the Access SQL server migration assistant
I have (re)installed Microsoft SQL Server migration assistant latest version today, and i have installed Ms SQL server Management studio 18 in order to migrate my accdb access database from Access to ...
- 13
-1
votes
1
answer
1k
views
What is the difference between "client-server" and „file-server“ database? [closed]
I am trying to answer a question put on the exam but cannot find answer that is precise enough. Please help to understand what are the major difference between "client-server" database such ...
- 153
1
vote
1
answer
922
views
How can I share an Excel sheet with embedded SQL queries with another user without asking them for log-in credentials?
I created an Excel (Microsoft 365) sheet for a (non-tech-savvy) coworker that pulls data from a SQL database. However, he is not able to refresh the queries (by hitting 'Refresh All') on his machine ...
- 11
2
votes
1
answer
110
views
Can I separate some tables in my SQL DB for backups?
I've got a large database with many tables. Numbers not important. MSSQL 2017 (14.0.2037.2) on Server 2016 that I have full control of.
A huge amount of my data is in two or three tables. Imagine you ...
- 23
0
votes
0
answers
2k
views
Unable to install MS SQL Server or SSMS due to missing DLL, how do I find and install this DLL?
I have the exact issue as the OP of this question but their fix did not work for me:
Related Stack Overflow Question
I need to install MS SQL Server and SQL Server Management Studio on my computer. No ...
- 103
0
votes
2
answers
3k
views
Is NT SERVICE a local or shared network domain account?
The sql agent job runs under the NT SERVICE/InstanceName account.
Is the NT SERVICE domain private to the current computer or is it shared across all computers in the network?
- 220
0
votes
1
answer
276
views
Is it possible to use sp_addrolemember on a SQL Server database without Management Studio? Only using sqlcmd
I’m trying to avoid installing Management Studio on multiple servers.
Is it possible to add Sp_addrolemember to a database only using sqlcmd?
I tried:
sqlcmd -S .\SQLEXPRESS -E
USE [DBName]
EXEC ...
- 67
0
votes
1
answer
79
views
Excel to access file data tranfer by SQL server
I have an issue While Transfer Data From Ms Excel to MS Access by SQL Server
here is my program
Public Sub DoTrans()
DoEvents
Sheets("Temp").Select
Set cn = CreateObject("ADODB....
- 115
0
votes
1
answer
34
views
Hello is there are keyboard shortcut for switching to the messages tab?
I have looking around by a lot but I did not find anythink. Any ideas?
Mail
0
votes
1
answer
469
views
From Powershell, Open Multiple SQL files in a single SSMS Instance
I have an automated Powershell process that ends with an Invoke-Item command to open multiple SQL files (currently 4 SQL files) for the testers, so they can run their scripts. Keep in mind, I am not ...
- 493
0
votes
1
answer
96
views
What are the real risks of making a Azure SQL DB accessible for all Azure Services?
This is more of a general question regarding network security which came up while I was brainstorming about SQL Databases on Azure.
When you configure a SQL Database you have the Option to make the ...
- 3
2
votes
1
answer
37k
views
How to remove SQL Server completely?
I have a faulty installation of SQL Server and want to remove it completely. The problem is there are too many entries in Apps & features in control panel (Uninstall programs).
I followed this ...
- 1,753
1
vote
1
answer
1k
views
C drive getting full in windows 10 for no reason
I had 37 GB free on my main OS drive (C:) in my 512 GB SSD hard-drive. I installed a 2nd 1 TB drive anticipating needing more disk space soon. Just in few days c:\ drive got full for no apparent ...
- 1,753
1
vote
0
answers
16
views
Some Virus is creating "Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SqlManagement" folder again and again [duplicate]
c:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SqlManagement folder is creating again and again in our Windows server 2008 R2. SqlManagement folder contains some files with ...
- 11
0
votes
1
answer
361
views
How can I make SQL Server 2017 retry to start if startup fails?
We have a SQL Server that is used internally for testing. We shut down the server every night to save on Azure costs. Sometimes it fails to startup due to the paths it uses not being available like ...
- 488