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]...

Filter by
Sorted by
Tagged with
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 ...
ubersteve's user avatar
  • 123
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 ...
Anna's user avatar
  • 77
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 ...
monkey's user avatar
  • 265
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 ...
rob's user avatar
  • 21
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 ...
Andrew's user avatar
  • 121
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 ...
user avatar
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 ...
user21833's user avatar
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 ...
AndreaNobili's user avatar
  • 7,141
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,...
Jmarco29's user avatar
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 ...
HyperQBE's user avatar
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 ...
Qwerty3423's user avatar
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 ...
mkc's user avatar
  • 21
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 ...
VVander's user avatar
  • 21
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 ...
user10236952's user avatar
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 ...
kubwosz's user avatar
  • 21
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 ...
tfrancois's user avatar
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 ...
VCarstein's user avatar
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 ...
Matt's user avatar
  • 1,182
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 ...
Matthew Haugen's user avatar
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 ...
jktravis's user avatar
  • 131
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 ...
matandked's user avatar
  • 165
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 ...
AGryckiewicz's user avatar
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 ...
Abel's user avatar
  • 1,463
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 ...
Steven Wang's user avatar
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 ...
Marcello Miorelli's user avatar
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 (...
Peter's user avatar
  • 509
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 ...
Ehsan Nourani's user avatar
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 ...
B540Glenn's user avatar
  • 1,105
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 ...
DisgruntledGoat's user avatar
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 ...
Aung Myo Linn's user avatar
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 ...
WhiskerBiscuit's user avatar
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 ...
Ramya's user avatar
  • 35
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, ...
SeanC's user avatar
  • 3,704
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 ...
ingvarius's user avatar
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 -...
John's user avatar
  • 75
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 ...
Martin's user avatar
  • 121
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). ...
Jonathan's user avatar
  • 3,517
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 ...
Aaron Newton's user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
Dwight T's user avatar
  • 173
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 ...
Eric H.'s user avatar
  • 133
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 ...
codefox's user avatar
  • 21
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 ...
Marshall's user avatar
  • 233
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?
roman m's user avatar
  • 1,079
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 ...
haagel's user avatar
  • 121
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.
chobo2's user avatar
  • 1,949
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?
Igor's user avatar
  • 163
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 ...
Crazyd's user avatar
  • 179
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 ...
Paddy04's user avatar
  • 39

1 2 3
4
5
16