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

learn more… | top users | synonyms

2
votes
1answer
21 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
28 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
133 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
64 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
30 views

MS SQL query which split to other table columns

I have two table: table1: |Manager | USER | +--------+------+ |John | Tom | |John | David| |John | Marry| |James | Henry| table2: Now is empty, but must be like: |Manager|User1|User2|...
2
votes
1answer
113 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
18 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
0
votes
0answers
35 views

SQL Server 2016 installation issue

I've downloaded the SQL Server 2016 CTP 4 this evening and am trying to install it. I get this error message: "The application cannot find one of its required files, possibly because it was unable to ...
6
votes
1answer
2k 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
0answers
63 views

MSSQLLocalDB first connection has long delay

Using LocalDB before VS 2015 has always been fine, no delay whatsoever, however after upgrading to 2015 it now takes an awfully long time to connect to a database running from a .mdf file. My process ...
0
votes
0answers
84 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
42 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
290 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
17 views

How to tell what updates and patches are installed on the server

I have MS SQL server 2012, just found out that the slow response in 2012 version is due to a bug and there is an update available, so how to tell what updates are installed on the server to know if I ...
0
votes
0answers
32 views

Should I go for Hadoop?

I hope discussing scenarios and solutions isn't out of context, if it is then please suggest. Details: Windows server 2012 R2 with IIS and MS SQL standard edition, using C# in the front end with Ajax ...
0
votes
0answers
251 views

How to port forward through two routers in a network

I am trying to connect my SQL server through public network. So, I am having lots of problem in understanding it. One router is AirOS's(Outside my house) another is Iball's Baton(Inside my house). ...
0
votes
0answers
95 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 ...
0
votes
1answer
491 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 ...
2
votes
0answers
675 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
170 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
169 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
254 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
1k 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
103 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
0answers
41 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
1answer
24 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
3k 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
1k 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
708 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....
0
votes
2answers
4k views

What characters are allowed in in column (nvarchar 50) of MSSQL Server 2008?

I have a column in MSSQL which is nvarchar(50) in which I enter passwords for users. I know that for example some special characters like $ % are allowed, but where do I see which list characters are ...
2
votes
0answers
498 views

Cannot load riched20.dll into memory

In WindowsXP 64bit while installing MSSQL 2008 installation terminates showing error message "Cannot load riched20.dll into memory..." How to fix it?
2
votes
0answers
104 views

SQL Server is not started in windows 8

I created the local service. My server name is like sqlitesync.com. In my database folder created the configuration (web.config) and WCF web service (AuroraSyncService.svc). When I test this service ...
1
vote
2answers
3k views

MS SQL Server 2012 Express Setup crashes with .NET error

I'm trying to install MS SQL Server 2012 Express on a virtual machine at a client. It's fresh install of Windows Server 2008 R2 Enterprise SP1. I added the "File Services" and "Application Server" ...
0
votes
1answer
146 views

SSMS starts without login prompt and stays inactive

recently my SSMS started working really weird, wasting my time. I am working on a laptop connected to additional monitor. SSMS starts without login prompt, and stays inactive as long as I dont shut ...
0
votes
1answer
551 views

SQL server replication, subscription to remote server : issue while choosing the publisher

I am trying to create a subscription to a remote server having SQL 2008 R2 the client PC is connected through VPN to the server and can discover it successfully. I can even connect to the database ...
0
votes
1answer
56 views

What Microsoft product is used to draw a Relational Database for MS SQL?

What Microsoft product is used to draw a Relational Database for MS SQL? For MySQL I have used MySQL Workbench what is similar for MS SQL?
0
votes
1answer
420 views

Error importing database in Windows Azure

Just to test the MSSQL backup/restore capabilities of Windows Azure, I selected a test database and chose the "Export" option. It prompted me to select a storage location and I chose an appropriate ...
0
votes
2answers
570 views

What versions of Windows does MS-SQL come pre-installed on?

We have an emergency mgmt. application that runs on a flash drive so that in an emergency a PC can be commandeered to run the app. We are considering using MS-SQL instead of MS-Access, so I am ...
1
vote
1answer
322 views

Administrator can run a application but produces error while a administrator previllaged user can run without error

I have an application which can run as admin prevailed user without error but while administrator runs it it produces error. The input string was not in correct format-application error. I tried to ...
2
votes
1answer
685 views

WinSCP command line for SSIS package

I am using the command line : option batch on option confirm off open ftp:// username :password hostname:port cd directory name ---- directory on FTP option transfer binary put file name on FTP C:\...
0
votes
1answer
1k views

Access MS SQL server from CentOS (OpenOffice calc)

I installed FreeTDS in CentOS 6 and I can connect from php to remote MS SQL server. However I cannot set up odbc connection so that it shows in list of ODBC connections in OpenOffice apps. If my ...
0
votes
1answer
112 views

A proxy-kind program that listens on local port and transfers everything to LAN server

I'm administering a few WinXP machines from which one is a MSSQL server/workstation. WinXP is a must because of the program the office uses. I was thinking of moving the MSSQL server to another ...
1
vote
1answer
550 views

User Friendly CSV to MSSQL import with column match

Hi before I reinvent the wheel I'm trying find something to allow a user to take .csv files and graphically match the columns in the database table to the columns in the csv file. I know this can be ...
1
vote
1answer
937 views

Migrating Access Database to MSSQL backend

We have a database at cadets that uses Access for all functionality and data. It's starting to get slow and not always update. I know that Access 2003 and higher (not sure on older ones) lets you ...
0
votes
1answer
194 views

ADODB Connection - Webserver doesn't resolve the hostname of the mssql server

I have a mssql connection resource file as belows: <% Set Conn01 = Server.CreateObject ("ADODB.Connection") Conn01.Open "PROVIDER=SQLOLEDB; Data Source=forum;UID=forumuser;PWD=forumpass;APP=;...
2
votes
2answers
6k views

Event log warning Registry setting specifying configuration file does not exist

Microsoft SSIS Service: Registry setting specifying configuration file does not exist. Attempting to load default config file. For more information, see Help and Support Center at http://go....
1
vote
1answer
2k views

How do I make a dump of a MS SQL database using SQuirreL SQL?

Unfortunately I cannot use Microsoft's database tool to access my MS SQL server, so I need to use another tool like SQuirreL SQL. How can I make a backup (i.e. dump) of the database?
0
votes
1answer
4k views

Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?

We're evaluating using SharePoint 2010 as our project management tool. Specifically, the system needs to satisfy the following: Discussion groups Project management (simple issue tracking, no ...
2
votes
1answer
416 views

What program can be used to insert/modify/delete rows of MS SQL Compact?

MS SQL Server Management Studio 2010 seems not support compact databases (add/remove records). Is there any utility? Free one would be nice.
1
vote
1answer
358 views

SQLCMD -L option with a smaller timeout

I am trying to use the sqlcmd -L c command to find out the instance name of the SQL server running on the local machine. It succeeds, but I have to wait for a full minute, for the tool to realize that ...