The tag has no wiki summary.

learn more… | top users | synonyms

2
votes
1answer
35 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
29 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
81 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
7 views

Adding a certificate to be used by MS SQL SERVER

I have MS SQL SERVER 2012 installed on my Windows 8.1. Now I wanted to enable SSL encryption in it. What I did was: 1. Run - > MMC 2. Add snap-in 3. Added certificate (personal) for local computer ...
0
votes
0answers
435 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 ...
0
votes
0answers
18 views

Access freezes before I can change data source

I have an .adp file that connects to MSSQL Data Source A, on Intranet #1. I copy the .adp to Intranet #2, including moving the .mdb to MSSQL Data Source B. I try to open the .adp to change the Data ...
-1
votes
1answer
57 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
32 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
0answers
13 views

redirect MS SQL through Ubuntu

I'm trying to redirect a Microsoft SQL connection from local LAN to VPN via Ubuntu The Ubuntu has connection to both networks I want to be able to connect SQL from my PC to the Ubuntu and it redirects ...
0
votes
0answers
20 views

How to view MSSQL logfiles to investigate errors made by remote connection?

I am having MSSQL 2012 running on some computer, and I am connecting to a certain database from a different computer remotely to perform a bunch of SQL commands. However, these commands have problems, ...
0
votes
1answer
22 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
2k 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
383 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
260 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: ...
0
votes
2answers
1k 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
262 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
85 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
2k 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
96 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
286 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
53 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
282 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
395 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
248 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
512 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 ...
0
votes
1answer
940 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
109 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
458 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
691 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
157 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 ...
2
votes
1answer
5k 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 ...
0
votes
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
3k 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
364 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
259 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 ...
0
votes
1answer
583 views

Looking For Live Exchange Backup Solution Utilitizing the Cloud (S3, Azure, whatever) [closed]

I have been tasked with finding some software or a service which can backup user mailboxes from a live Exchange server and SQL databases from MSSQL servers much like a Barracuda device might perform. ...
1
vote
1answer
912 views

Can't add PHP extension “mssql.so”

I want to add mssql.so extension to my PHP. I've already put it in the extension_dir and the line "extension=mssql.so" is in my php.ini. I restarted apache but I can't find the extension in ...
0
votes
2answers
22k views

What ports does MS SQL Server use for ODBC connections?

I require our firewall to allow ODBC connection from clients to the MS SQL Server. Which ports should be opened for this?
0
votes
1answer
193 views

Problem while installing Microsoft SQL Server 2008 as a user with Administrator rights

I am using Microsoft Windows XP service pack 3 User Accounts: VC3(Type: Administrator) and Administrator Question I am trying to install the Microsoft SQL Server 2008 in VC3 After half of the ...
2
votes
1answer
2k views

How to determine server name for ms sql

How do I determine the server name for ms sql server. How do I make one, if there is no default server name. I need this so that I could use it as a database Update: I tried using the computer name + ...
0
votes
4answers
966 views

How can I model a pre-existing SQL database structure?

I have a MS SQL database that has been running strong for 10+ years. I'd like to diagram the database structure, without spending hours laying it all out in Visio or something similar... I've ...
9
votes
9answers
20k views

Why does it take so long for SQL Management Studio to connect?

Considering that Microsoft SQL Server is not, technically, a slow database management system, I keep wondering why it often/usually takes such a long time for SQL Management Studio to connect. This ...