Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [ms-sql]

Use this tag for questions related to the MS SQL Server, the management relational database by Microsoft. 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. Do not confuse it with [mysql], the Oracle's one. Tag questions specific to a version with [sql-server-2012], [sql-server-2008]...

0
votes
0answers
7 views

Zabbix MSSQL Monitoring [closed]

We have just started to think about changing away from our monitoring software that we currently using and paying for to other open source alternatives. One of the things we are most interested in in ...
0
votes
0answers
10 views

SQL Query Filter Item without affect next record [closed]

The following queries is using partition by in order to get the previous balance. SELECT SUM(TT.StockQty) over (PARTITION BY TT.ItemCode order by TT.syscreated asc) as 'Balance', TT.syscreated as '...
0
votes
0answers
3 views

sql ssms on development - clear log.ldf files [migrated]

while working on building of a big DB i notice my C drive run out of space when running heavy SQL queries on SQL Server. by checking this folder size is over 150GB , when log.lpd files reach over ...
2
votes
1answer
24 views

Additional User Account, Windows Authentication in SQL Server Management Studio

I am transitioning my work laptop to a coworker (who we'll call Mary Smith) who is taking my place on my team as I move on to other things. One of the tools we use is Microsoft SQL Server Management ...
0
votes
0answers
18 views

Is it possible to install sqlsrv on amazon linux with php 5.6?

The official Microsoft tutorial links to the repo with sqlsrv versions that are for php 7.0 and up. I've read about the "mssql" with freetds as an alternative, but, from what I understand, its a ...
0
votes
0answers
17 views

Linking tables in MS SQL databases

This is more a question to get some suggestions of software. I hope it is OK to ask it here. Say I have a MS SQL-database from a source system that I want to migrate to another MS SQL-server. When ...
0
votes
0answers
17 views

Database restore - SQL Server on Linux - Vagrant Virtualbox - Linux host

SQL Server on Linux seems to have trouble reading from the default shared /vagrant folder. Some folder info (ls -l): Root folder: drwxr-xr-x 1 vagrant vagrant 4096 Sep 24 09:32 vagrant Backup ...
1
vote
0answers
14 views

Intermittent issues connecting to a SQL CE Database

I'm trying to work on a local development copy of a website in Visual Studio 2017. This website uses a SQL CE database in an .MDF file, and I run the site locally through VS using IIS Express. When I ...
1
vote
1answer
34 views

PHP 7.0 round function and MsSQL módule

I've a Debian server that acts as web server. Recently I've needed to install the MsSQL module to use a Microsft SQL Server as source, but after install it I've noticed that php round function has ...
0
votes
0answers
150 views

Can't connect SQL Server when EXE is run from network share

After last update of Windows 10, one program is not connecting to SQL Server when its executable is started from network share (e.g. \\192.168.1.2\share\the_tool.exe). When it is copied to local HDD,...
1
vote
0answers
45 views

Security concerns with users created for R scripts in SQL Server

As discussed in this question and this MSDN forum post, installing R with a Microsoft SQL Server 2017 installation (possibly other versions) creates 20 users in the SQLRUserGroup. As explained in the ...
2
votes
0answers
14 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 ...
3
votes
1answer
268 views

PowerShell SqlServer module only imports functions and aliases, but no cmdlets

I am trying to use the SqlServer PowerShell module, available on the PowerShell Gallery. After installing, either to -Scope CurrentUser or in an admin session, doing Import-Module SqlServer only ...
0
votes
0answers
31 views

Azure and SQL database connections

i looked around for the answer to this question and nothing really seemed to give me a clear answer. Since i need this information for professional use, i'd also rather be safe than sorry. :) Here ...
0
votes
0answers
566 views

[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.1.so.0.1

I am trying to run windows command line program that uses ODBC to connect to a remote MSSQL server. It works fine in Windows 10. Now I want to run the same program in Linux using Wine. I have ...
1
vote
0answers
388 views

How to allow simultaneous reads and writes on the same table in SQL Server [closed]

I have a website that runs on MS SQL Server 2014 Enterprise with two clustered virtual machines and AlwaysOn. The website frequently reads and writes on one table. However, all reads and writes ...
1
vote
1answer
70 views

How to reduce the database size of MS SQL server

I have a website that runs on MS SQL Server 2014 Enterprise with two clustered virtual machines and AlwaysOn. A database backup is created each night and the size is now 20GB. On my laptop, I also ...
1
vote
0answers
22 views

SQL in LOCAL SERVER GROUP via CMD

I already created a MSSQL LOCAL SERVER GROUP . question is , is there a way we can connect in LOCAL SERVER GROUP via CMD.
1
vote
0answers
48 views

Can I save 'Outlining in my MS SQL Query

When writing a query, I will often use Cross Apply, or multiple sub queries. To make the query easy to read I realized you can outline parts of the query, and then hide them. Using: Edit -> ...
1
vote
1answer
950 views

mssql error: The evaluation period has expired

I am trying to install MSSQL on Centos. I followed the article here. I typed the following command to configure mssql to set a password etc. sudo /opt/mssql/bin/mssql-conf setup I got the following ...
0
votes
0answers
2k views

Dbeaver export result set to multiple CSV files

I'm using the latest version of DBeaver on Mac, querying against a remote MSSQL database and I've got a query that results in 24 million rows. I need to get this data into CSV format, but rather than ...
1
vote
1answer
1k views

Connect to MS SQL Server on Arch Linux

I installed on my arch machine mssql-server and mssql-tools via yaourt. I started the server from /opt/mssql/bin/sqlservr and tried to connect with my credentials, but with no luck. I found this ...
0
votes
0answers
242 views

Sql SSMS slow on certain domain accounts

After days of googling I could not locate the issue. We are on a domain logging into a database on another server using Windows authentication. Some of the computers work super fast some are slow and ...
1
vote
2answers
648 views

Unable to Install MSSQL Server on CentOS 7

I was following along with: Install SQL Server on Red Hat Enterprise Linux and I ran into the following error at the configuration portion: Setting system administrator (SA) account password... ...
0
votes
0answers
52 views

Last Week Job Schedule

I'm looking for a way to scheduled MSSQL jobs to run only on the last week of the month? I see the current options are daily,weekly or month, When selecting monthly, you can select the day number, ...
0
votes
0answers
412 views

How to fill combobox with data from the column of an SQL server database table

I've been trying to set as the source of data of a combobox( in this case combobox2 ) the data in the column of an SQL Database table called "BulkInput" with little success. When I run the code, the ...
2
votes
1answer
85 views

In Microsoft SQL Server, how can I disable “X rows affected” at the end of my output?

I'm querying a database in Microsoft SQL Server and writing the output to a csv file. When importing the outputdata into another program i get an error because the last line of my output file ...
0
votes
2answers
333 views

Edit multiple rows in MSSQL “.rpt” file

I have a report from MSSQL, that has been exported to an .rpt format. I have installed the necessary addons to open and edit the file in excel, however one such report has come out strangely. For ...
-1
votes
1answer
2k views

How to troubleshoot Microsoft VBScript runtime error '800a0046' Permission denied?

The line the error formulates from is: Set newfolder = filesys.CreateFolder(Server.MapPath(newfolderpath)). Here is the code below: If Request.Form("add")= "true" then Dim prop, user, pwd, dir ...
0
votes
2answers
176 views

Network unreachable - MSSQL

I am trying to connect remotely to a sql server 2008. I am able to make the connection with the local ip address (I am doing so from terminal in a linux os connected to the local network, using ...
1
vote
1answer
60 views

MS SQL Server query which split to other table columns

I have two tables: table1: Manager | USER --------+------ John | Tom John | David John | Marry James | Henry table2: Now is empty, but must be like this: Manager | User1 | User2 | ...
3
votes
1answer
1k views

Convert DateTime with Decimal Time Longer Than 3 digits?

I'm trying to import some data from CSV into MS SQL 2008 Server. I'm using PowerShell's Invoke-SQL, and an SQL script that utilizes BULK INSERT. CSV fields get imported as VarChars and I'm trying to ...
0
votes
0answers
23 views

How could I see Transactions logs from my database

I am new to MS SQL administration. I have a SQL Server 2012 Enterprise Edition. Would like to see SQL Server Transaction logs for any contentions, db locks. Please guide me on this. A Anand
6
votes
1answer
3k views

Compiling PHP 7 with mssql support

So I'm trying to switch to PHP 7. Unfortunately I'm in need to connect to an MSSQL Server so I'll need the dblib driver for pdo. With PHP5 you could ust the php5-sybase Package. So I tried to do it ...
0
votes
1answer
886 views

Squid reverse proxy, DMZ, how to forward any non-http request

I'm actually facing an issue with some network-protocol related problem. I have my own domain, a owned DMZ, and externals users. In my DMZ, I have a reverse proxy who handle HTTP connection very well....
0
votes
0answers
104 views

Does CPANEL offer a schedule backups for Files and Databases content?

I would like to know if it is possible to use cPanel to set up automatic scheduled backup for all my content and configuration of my cPanel account, basically I need to backup files and DataBases (I ...
0
votes
1answer
1k views

Create database backup with sqlcmd from remote host

I want to execute a database backup through SQLCMD from a remote host. My command I use looks like this: sqlcmd -H IP.OF.Machine -S .\SQLDOTNET -U User -P Password -Q "Backup Database [database_name]...
0
votes
0answers
140 views

Sql Exception 0x80131904 cannot log in

My program connects to a MSSql database. If it connects via LAN it works fine, if it connects from outside I get the error message 0x80131904 Error when logging in the user 'ProgProj'. (translation ...
1
vote
1answer
1k views

Converting MSSQL Dump to MySQL Dump on Ubuntu

I only have Ubuntu to work with, so Windows programs are not going to work for me. But basically I have both the .bak file and the .sql file from a MSSQL server and I need to import this data into a ...
3
votes
0answers
1k views

Getting error (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY) when migrating from MS Access 2013 to SQL Server 2014

OK.... I've checked and rechecked Google, StackFault, Experts-Exchange, etc... for a resolution on this error and they all say to register the DAO360.DLL and add its path to the environment settings. ...
2
votes
1answer
214 views

How to pick rows in MS SQL based on column values?

I want to pick SourceId & Currency based on Count value. Problem is within a set I've to ignore all data where Count = 0 if there is any value greater than 0 but if all the counts are 0 within a ...
1
vote
0answers
352 views

PHP - MSSQL configurations cause slow performance [closed]

I have a problem in my project using PHP and MSSQL. I have the following configurations: 64 GB Ram 16 CPU Intel Xeon SQL Server 16 GB Ram 4 CPU Intel Xeon Web Server And I have the following code: ...
1
vote
3answers
764 views

SQL Server service dependency not working

I have an service that tries to connect to a MSSQL DB on startup, but when I start the computer it throws an error becouse it's not able to connect to the DB. This happens becouse the specific DB was ...
0
votes
0answers
2k views

PORT FORWADING TPLINK-TL-WR740N

i was up to using my local MSSQL database with my live application so that i can fetch the data from my personal pc from the web application. i am creating my web application in sailsjs. and i am ...
-1
votes
1answer
122 views

sub versioning with a TSQL Mac osX client

How can i setup ANY t-sql mac client connecting to a ms sql server and connect it to our svn server? i am looking to mimic MS Management studio + red gate. where once you have added the SVN link you ...
0
votes
1answer
53 views

If MSSQL machine is maxed out on resources, can it drop off the network and become un-pingable?

The issue is that our SQL machine will just disappear from the network with request timed out when I attempt to ping it. I have to deal with an "IT Guy" who is telling me that it is because Microsoft ...
0
votes
2answers
42 views

Join 2 mssql queries

I need to join to MSSQL queries, but I am not getting anywhere with this. Both queries return a single value: SELECT COUNT(*) FROM sysjobhistory WHERE run_status <> 1 AND step_id = 0; ...
0
votes
1answer
6k views

Remove column header from sql query output in powershell

I want to remove column header from sql server query output. I did the search but not found any solution. I have a script. $Database = "temp" $Server = "localhost" $AttachmentPath = "output.csv" # ...
0
votes
1answer
2k views

Can i input duplicate values in foreign key column

A small but important question can input null and duplicate values in foreign key column connected with some another table with same column identity and values as far of my knowledge it is not ...
2
votes
1answer
1k views

Excel inconsistent date conversion

I'm running Excel 2007. I've done a dump of data from a MSSQL database into a CSV file, then saved it as part of a larger Excel book. One of the fields is a date, which downloads as: 39262....