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]...
769
questions
2
votes
1
answer
207
views
Advice on webserver / database server setup
I have a home server (HP ProLiant N36L link with 8Gb of RAM), running Windows Server 2012 that I want to use as a home web server.
Is it worth settings up VM's in Hyper-V for virtual DB servers and ...
2
votes
1
answer
24k
views
How do I automate the exporting of a result set from an SQL Server database?
I have a View in an SQL Server 2008 database which I need to be exported into a CSV file automatically at the beginning of each month. As I understand, two procedures are needed:
The SQL script to ...
2
votes
1
answer
2k
views
sqlservr.exe's virtual size is big – should I worry?
Is this normal? Does the large virtual size matter on sqlservr.exe for
the performance of other apps? It seems to happen any time I use Firefox and iTunes. ( Also running is League of Legends)
Can ...
2
votes
3
answers
7k
views
SQL Server Ports
The Microsoft website states
The firewall must be configured to permit port 1433 incoming (or the port numbers that SQL Server listens to on TCP/IP), and ports 1024 to 65535 outgoing.
Does this ...
2
votes
1
answer
123
views
Do data sources travel with a particular mail merge document?
Do data sources that you set up (particularly to SQL Server) travel with a mail merge document?
In other words, if I set up data sources in a mail merge document on my machine and then save and send ...
2
votes
3
answers
2k
views
Why does MS SQL Server Management Studio almost freeze up my computer while it restores?
Why does MS SQL Server Management Studio almost freeze up my computer while it restores? It makes it so when I click on the clock it takes seconds for the calendar to open. I don't see why this ...
2
votes
0
answers
20
views
Is it possible to restore a single project plan from a full database backup
Using MS Project 2013, one of our PCO deleted tasks from a project plan, while work had been entered via timesheets on those same tasks, some of which weren't approved, yet.
The project is now in a ...
2
votes
1
answer
20k
views
How to connect to a Microsoft SQL Server from Linux shell?
I have the following problem: I am working on an Ubuntu Linux server (I have access only to the shell, no desktop environment) and I have to interact with a Microsoft SQL server to create some tables ...
2
votes
1
answer
437
views
SQL Server 2012 Setup Failure
I am installing SQL Server 2012 in my computer but this error message always shows up. I tried installing it in a Virtual Machine, and it worked! Other threads says that the issue is permission access,...
2
votes
0
answers
932
views
Unable to connect to SQL server after update
I updated my server today with all pending update and after reboot I was unable to connect to SQL server. Prior to reboot I've also enabled the firewall but now it's disabled again and server is after ...
2
votes
0
answers
385
views
Why i am not able to connect to SQL Server via VSCode?
OS: Ubuntu 19.04
I have installed SQL Server using tutorial by Microsoft, and after running command systemctl stop mssql-server i can see it's running.
But when i'm trying to connect to this ...
2
votes
0
answers
853
views
Visual Studio + SQL integration services projects
I am trying to install SQL Server Integration Services with Visual Studio 2019 however when I opend the exe file with SISP I am not able to select Visual Studio instance because I have the following ...
2
votes
0
answers
522
views
Sql Server Management Studio 18.1
I recently installed SSMS 18.1 and I am having an issue when trying to drag and drop table names from the object explorer to the query window. For example, I am writing a query and dont want type out ...
2
votes
0
answers
1k
views
Insert data to database using Excel VBA is not working
I have a macro that will upload data from multiple workbooks to the database. Table will differs based on what type of value/data being inserted. I have there tables. I can insert value in the first ...
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 ...
2
votes
0
answers
30
views
Anyone have success configured MySQL linked servers on SQL Server 2017 for Linux?
I am trying to figure out if SQL Server 2017 for Linux supports linked servers for MySQL? I know its possible on Windows OS if ODBC/OLEDB drivers are configured on the same server as SQL, but ...
2
votes
1
answer
56
views
MS SQL Server Licenses
I was having a discussion at work about the licensing model of Microsoft, in particular for SQL Server and we couldn't agree on the interpretation of "Active SA Quantity".
So the question is, if for ...
2
votes
0
answers
96
views
SQL Server 2017 cannot connect to remote databases
I tried to uninstall some old versions of SQL Server I had installed just to free up hard drive space, and along the way I corrupted my SQL Server 2017 such that SSMS could no longer connect to any ...
2
votes
1
answer
3k
views
Windows Scheduled Task executes SQL scripts as Anonymous Logon, despite being associated with a domain account
I've built an EXE that I need to run every hour, for the rest of forever. To do this, I'd like to use Windows Task Scheduler.
It would be more appropriate to run this on Windows Server, but ...
2
votes
1
answer
3k
views
How do I connect from IIS to remote SQL via Windows Auth w/o a service account?
I have a pretty typical .NET app that uses Entity Framework, MS SQL, and IIS. The app was developed with the expectation that the SQL server would run local to IIS and with SQL authentication for the ...
2
votes
2
answers
3k
views
DQL/SQL to Excel - obtain results of multiple SELECT statements in spreadsheet
I wrote T-SQL query that contains few separate SELECT statements.
Each SELECT statement returns different number of columns and represents different properties/features, so that I don't want to join ...
2
votes
1
answer
3k
views
How do I safely uninstall the many components of past SQL Server versions?
I recently installed SQL Server 2017 Express on my Windows 10 operating system (PC). I also though have installations of 2016, 2012 and apparently 2008 as well from older installs. I'd like to ...
2
votes
0
answers
3k
views
Restore databases in SQL Server without creating orphaned users
I have seen this in just about every version of SQL Server and blog posts about it seem to treat it as something that occurs sporadically, but since I always seem to encounter this problem, up and ...
2
votes
0
answers
436
views
Run out of virtual memory after added to triple physical RAM and change SQL Server memory option?
Recently, we added some physical RAM to our server which running SQL Server 2008 R2 instance, the total memory was changed from 64GB to 192GB.
And we tuned the memory option of SQL Server by changing ...
2
votes
0
answers
4k
views
LDAP connection - how to query active directory and get this information?
I am following this article below:
Querying Active Directory Data from SQL Server
and for me to get it right I need the following information below.
Querying Active Directory Once the linked server ...
2
votes
0
answers
558
views
SQL Server Express no longer starts up automatically
I had SQL Server 2008 Express (SP1) on Windows 7 Pro and it was working fine.
After upgrading to Windows 10, SQL Server 2008 Express was still working normally.
However, after the last Windows update (...
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 ...
2
votes
2
answers
4k
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 ...
2
votes
0
answers
1k
views
How to install SQL Server ODBC driver on OSX?
I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error:
The ODBC driver that was selected for the source connection ...
2
votes
1
answer
1k
views
How to load files according to Created Date in Windows command prompt
In SQL Server using xp_cmdshell, I was able to load files according to Modified date using a command for e.g.,
z: & forfiles /m *.jpg /s /d 07/16/2015 /c “cmd /c echo @fdate @ftime @path”
But I ...
2
votes
0
answers
129
views
Using Cloudberry SQL Server backup and Amazon Glacier efficiently
I'm using Cloudberry Serverbackup to backup my SQL databases once a month to Amazon Glacier.
I know that just getting an inventory from Glacier can take a long time.
Is there a way that when the ...
2
votes
2
answers
5k
views
Error is using Microsoft Query data in excel in 3rd Person's PC
I have a problem when using Microsoft Query in Excel Data Link.
I have used SQL Server Connections before in Excel. When we use SQL Server, after doing the connection and retrieving the data, the ...
2
votes
1
answer
2k
views
excel sql server error: Invalid object name
I access a stored procedure on a Microsoft SQL Server 2005 database within excel using
Select *
from [dbo].[fn_ph_by15minbyQueue] ('2013-09-01','2013-09-30','LocationCode')
in the data connection, ...
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 ...
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 -...
2
votes
2
answers
3k
views
Restore a database with LDF file only
First of all, i know how stupid it is not to have a any backup. I can't help it, but i have to (try) to solve it.
I have a transaction log (LDF) file from a SQL Server 2000 database that contains all ...
2
votes
0
answers
681
views
View numeric columns in hex - SQL Server Management Studio
In SQL Server Management Studio, when I run a query which outputs a numeric column (int or similar types), they are displayed in decimal (example: 193). I want them to display in hex (example: 0xC1). ...
2
votes
1
answer
2k
views
Loading Files from My User Directory in SQL Server Management Studio 2012 Under Windows 8
I'm in the process of migrating to Windows 8, part of which was to get SQL Server/SQL Server Management Studio 2012 running. I tried to load some sample data from a .bak file for a 2012 compatible ...
2
votes
1
answer
279
views
NetWork Intrusion Attack: MSSQL.worm.helkern attempting to attack local port 1434 from IP address 94.188.21.147?
I was on the internet the other just finishing up a project for work and I saw my internet security saying network attack intrusion and I read about some of it but I can't fully understand the full ...
2
votes
1
answer
344
views
How can I run this batch file?
This is the batch file:
OSQL -S 127.0.0.1 -U sa -P password
RESTORE DATABASE DATA FROM DISK = C:\backup\data.dat
GO
EXIT
But after I run the OSQL -S 127.0.0.1 -U sa -P password, the command prompt ...
2
votes
0
answers
823
views
Access losing db connections
I have a weird problem going on at work.
People have been using MS Access to connect to SQL Server db and lately people are getting sporadic problems with connecting to the servers. It's not always ...
2
votes
1
answer
744
views
How can I add a keyboard shortcut for Find-In-Files in SQL Server Management Studio?
I'd like to make it Ctrl-Shift-F to match Visual Studio.
I realize to do that I need to remove that binding from the Query->Save to File item.
But, I can't even add ANY shortcut. When I pull up the ...
2
votes
3
answers
2k
views
Windows 10 - MSTSC UI has very bad performance
About a month ago I reinstalled my PC at work and put Windows 10 on it after I received my new SSD. While the system itself runs very smooth, the MSTSC UI (the connection dialog) is pretty much ...
2
votes
1
answer
132
views
Accessing a local SQL server 2014 from within a VM running vista using VS2005 fails
My laptop is running Win 7 (x64) and is part of a domain. I've installed SQL Server 2014 Dev and VS2012 on it as I want to use the laptop for development.
Since some of my development has to be done ...
1
vote
2
answers
5k
views
How do I get a standalone SQL Server Management Studio (SSMS)?
I don't want to install the entire SQL Server (2005 or 2008) on my Virtual PC (saving space), yet I need the SSMS to connect to external databases.
What are my options?
1
vote
2
answers
14k
views
Files left after uninstallation of MS SQL Server
I just uninstalled MS SQL Server 2008 from my machine (using the "Uninstall or change a program" feature in Windows Control Panel). Now I notice that there's still a lot of files left. Around 1 GB ...
1
vote
2
answers
1k
views
How to install Sql 2012 on Windows 8?
I am having trouble installing sql server 2012 on windows 8.
1
vote
1
answer
2k
views
Is it possible to replicate SQL Server Express 2008 => SQL Server Express 2012?
Is it be possible to configure the one way replication between SQL Server Express Edition 2008 => SQL Server Express Edition 2012?
1
vote
1
answer
2k
views
Record Matching Software to Compare two tables and match on % Based [closed]
So I have some table with Name, Address, and Zip with no record data attached; and I have a table which has all the same, but has more information and I need a way to merge the tables when they don't ...
1
vote
4
answers
2k
views
Sharing Excel sheet over network?
Is it possible to have a server PC running a Microsoft Excel sheet to which several Thin Clients, with Barcode Scanners, will be connected via TCP/IP? The scanners should dump their data in the Excel ...