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
2
votes
1
answer
4k
views
How to force SQL server to use maximum network bandwidth
I have a program written in Delphi that uses SQL Server 2008 as database engine. I am on a p2p link provided by two nano station m5. When I run a specific query inside of the program, the network ...
CommunityBot
- 1
2
votes
2
answers
4k
views
Import-CSV with powershell using a variable path
I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work.
$path = "C:\Users\Admin\Desktop\TestFolder\file.txt"
Import-CSV -...
CommunityBot
- 1
0
votes
0
answers
55
views
SQL Server ceases to function due to insufficient memory
I have used a locally installed instance of SQL Server for my software development work on various laptops over the past 16 years.
About 3 weeks ago, I started using a new laptop and almost ...
- 103
0
votes
1
answer
40
views
Can't log into SSMS using a DNS name from the hosts file
In both my server (that hosts SQLS server) and my Pc, I have this entry in the hosts file:
I am using Windows Authentication to log into the SSMS.
Using servername MYSQLSERVER in the SSMS on my Pc, I ...
- 465k
2
votes
1
answer
3k
views
MSB4018: The "SqlBuildTask" task failed unexpectedly ==> System.OutOfMemoryException
Sometimes, rebuilding my solution I get following error. Solution is huge, 270+ projects and I have no idea how to get rid of this error. It happens sometimes, most of the times solution builds ...
CommunityBot
- 1
0
votes
0
answers
80
views
How to install SQL Server Developer edition on Windows 2022 Azure Pipelines?
Installing SQL Server Express on Windows 2022 Azure Pipelines is easy.
Here is my code:
function Test-IsAdmin {
$currentUser = [Security.Principal.WindowsIdentity]::GetCurrent()
$principal = ...
- 481
2
votes
2
answers
12k
views
Cannot uninstall SQL Server 2005, no matter what I do
Windows 2003 Server R2 64 bit
I do Control Panel, remove programs, and get:
Setup failed.. the dialog box disappears so fast that I am unable to write down all the messages, but the items get the ...
CommunityBot
- 1
1
vote
3
answers
5k
views
Connect to SQL Server through SSH tunnel?
I'll preface this by saying that I'm not familiar with SSH and doing this sort of stuff, so I'm really looking for a whole explanation of how to go about this. I have an idea that I might be able to ...
CommunityBot
- 1
0
votes
1
answer
4k
views
SSMS 18.2 cannot create database diagram
As the title say, my SQL Server Management Studio cannot create database diagram as it keep show me an error is Index was outside the bounds of the array. How can I solve it?
This is my SSMS version
...
CommunityBot
- 1
1
vote
2
answers
5k
views
SQL Server Management Studio 2014 won't start: Exception has been thrown by the target of an invocation
I'm on Windows 7 Professional SP1.
I just installed SQL Server Management Studio 2014 using the 64-bit download from Microsoft: SQLManagementStudio_x64_ENU.exe, and when I click on the shortcut in ...
CommunityBot
- 1
0
votes
2
answers
39
views
Why does SSMS generate many tilde files when saving a SQL file?
I'm using SQL Server Management Studio (SSMS) 20.1 to edit a file containing SQL commands. The file itself, sqlCommands.sql, is being provided via a WebDAV server that we've written. If we make an ...
- 187
1
vote
2
answers
6k
views
Why I can't see the users that I have created
I have created 4 users on Active Directory Users and Computer:
But I can't see the users on my computer management under "local users and groups" nor on my sql server!
So, why I does not have "local ...
CommunityBot
- 1
-1
votes
1
answer
354
views
SQL Server 2022 express download error
I was trying to download SQL Server 2022 Express in windows 11 and received an Exit code(Decimal): -2061893606.
Then I checked log and saw SystemConfigurationCheck report.
Everything is okay except ...
- 43.1k
2
votes
2
answers
5k
views
SQL Server Results to File Creates extra lines at end
When I route the output of my queries to a file, there are one or two blank lines at the bottom. When I run the query though SSMS (2008 or 2012), I get two extra blank lines. When I run the query ...
CommunityBot
- 1
3
votes
1
answer
4k
views
SQL Server 2012 Connecting to MS Access 2003
SQL Server 2012 - Access 32-bit 2003 - I can import the database, I don't understand why I can't link to it. SQL 2012 may have changed the connection string or something.
I just installed SQL Server ...
CommunityBot
- 1