Database language for managing data in relational database management systems (RDBMS). Note that each database implements SQL with slight variations. Please remember to tag with your specific database as well, e.g. [tag:mysql], [tag:postgres], [tag:mssql], [tag:oracle]

learn more… | top users | synonyms

3
votes
1answer
119 views

Windows 7 WMI ODBC driver installation?

I am interested leveraging the ease of report production provided by Microsoft SQL Report Builder, but I would like WMI as an available datasource. Since SQL Report Builder relies only on SQL, I ...
0
votes
0answers
42 views

SQL Server Table Partitioning and my data lifetime management

My application stores data on Enterprise edition sql server, and I plan to take advantage of table partitioning to manage data retention. Each partition will hold a predefined period of time (say one ...
0
votes
1answer
120 views

PORT 1433 in use by LSASS.EXE, therefore cannot start SQL Server Service

Sysinternals's TCPView shows that port 1433 is used by this OpSys process, both local and remote addresses contain my FQDN, which is a Win Server 2008-R2 fully patched, has someone faced such a ...
0
votes
1answer
52 views

DBVis SQL Query - Using Date Variables

Firstly it's been a very long time since I did any SQL and even then it wasn't at a high level. I have created a SQL query which works but I want it so the date range changes automatically, for ...
2
votes
0answers
265 views

SQL server intermittent connectivity issue every 4 or 5 days

I have a .net web application that calls sql server 2008 running on a different server. From last couple of weeks, after every 4 or 5 days, web applications connectivity to sql server becomes an ...
1
vote
1answer
231 views

Log In failed for user error 18456

I have two servers. Both of the servers have two different database that will be joined together using SQL Server Agent. However, during this activity SQL Server is throwing a Log In Failed Error. ...
1
vote
1answer
94 views

HeidiSQL, attach/register database in MSSQL server

How to attach (or register) an existing MSSQL database to a server Using HeidiSQL
4
votes
2answers
832 views

SQL Clustering or Hyper V Clustering

We will soon be implementing our Dynamics AX installation. Our aim is to have high availability and we are working closely with our implementers. We raised the question to them about SQL and Hyper-V ...
0
votes
1answer
71 views

SQL 2008 R2 replication with Oracle DB Server Issue

I am configuring replication between SQL 2008 R2 & Oracle DB server. Getting below error "ORA-01830: date format picture ends before converting entire input string (Source: MSSQL_REPL_ORACLE, ...
-4
votes
2answers
91 views

Is RAM size related to SQL performance? [closed]

I have some simple code that generates 3 millions insert queries. I have two VPSes, one with 512MB RAM and one with 2GB RAM. On the 512MB RAM VPS, I can insert about 50,000 rows in 5 minutes. On the ...
0
votes
0answers
34 views

SQL server HA when running with PCI Flash device

I want to purchase a PCI based Flash storage device for our ESXi server hosting our SQL Server machine. We use SQL Server 2008 standard edition. storage is on Netapp via NFS. It is a VM (ESXi 5.1) ...
0
votes
0answers
79 views

What's the effective way to compact sqlite3 db?

After a few delete and insert, our sqlite3 (3.7.x) was inflated from 300K to over 4MB. In firefox sqlite3 manager, we open the db and compact it. There is no size change. Then we move the db file to a ...
1
vote
2answers
105 views

How to force sqlite3 table to take next available id for auto increment in firefox sqlite3 manager?

We delete some records in a sqlite3 table (re-id record manually) and compact the db. However when adding a new record in firefox sqlite3 manager, the auto incremented id is not the next available id ...
0
votes
1answer
91 views

Resell SQL Server 2008 Volume Licenses [duplicate]

This may sound like a strange question, but it's incredibly relevant to my company. If it's legit to purchase previously used VL keys for SQL Server 2008 and have them legally transferred over to us ...
0
votes
0answers
72 views

Securing and loadbalancing front-end back-end with sql inspection proxy

I am working on designing a secure way for our network to allow front-end application servers in our DMZ to communicate securely with our databases, and I can see quite clearly that normal firewalling ...
-4
votes
1answer
33 views

Does Nginx support ssh connections? [closed]

I want to build a site with nginx as HTTP server and MariaDB as SQL server. I'm searching in Google if nginx support (or its included) the ssh support to execute ssh_connect thru PHP files, but I ...
0
votes
1answer
224 views

CentOS 5.8 - The most difficult MySQL installation ever?

To install I did: yum --enablerepo=remi,remi-test install mysql mysql-server Result of the last 3 lines: Installed: mysql-server.x86_64 0:5.0.95-5.el5_9 Complete! Then I did the following: ...
0
votes
1answer
105 views

How to execute multiple SQL statements in virtualmin / mysql

Using the "Execute SQL" feature of the mysql addin for virtualmin, what is the syntax for executing multiple statements? For example if I want to do: delete from Table1; delete from Table2; I get ...
-3
votes
2answers
118 views

How do i set the default instance of Microsoft SQL Server? [closed]

I have Sql Server 2000 and Sql server 2005 installed on the Server. How do i set the default instance to 2005? On Running this script Select @@Version i get: Microsoft SQL Server 2000 - 8.00.194 ...
-1
votes
1answer
79 views

Very Slow SQL Performance on VM rinning 2003 through 2012 r2 host [closed]

I have an OLD HP proliant ML350 used as HYBERv Host (win server 2012 - 16 GB RAM , 3x146 GB SAS , one processor). i have a VM (win-server 2003 32bit + sql server 2000) , every thing is working fine ...
0
votes
0answers
44 views

OpenLDAP SQL backend failing

I'm running OpenLDAP with a SQL (Oracle) backend. This works fine with OpenLDAP 2.3 but after upgrading to 2.4.38 it fails with an error that is not helpful at all: 52d3ec0c ...
0
votes
0answers
217 views

Disabling locked page allocations in SQL Server 2012

Locked page allocations are enabled in my instance of SQL server 2012 even though I have no accounts with the "lock pages in memory" user right. This article by Microsoft - ...
0
votes
1answer
66 views

Cannot create MS MDT Database on SQL 2012 Express

I am trying to create a new SQL Server 2012 Express database via MDT 2013. When I did that I got the error above. I have completely rebuilt the server yet this error persists. Now when right-click on ...
0
votes
2answers
1k views

Offline database can't be restored: Exclusive access could not be obtained

I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly ...
1
vote
1answer
27 views

SQL Server 2008 - Difference between server and database permissions

And I think I'm almost there conceptually. I think I just need a few example/confirmations to bring it home. 1) My understanding is that server permissions ...
2
votes
1answer
103 views

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a ...
0
votes
0answers
43 views

SQL Server : Improve SIMPLE SELECT to retun 2 LAC Rows faster?

We have a stored procedure in which we are creating a temp table which has more than 200,000 rows with 30 columns (2 of DATETIME, 4 of INT, 5 of [numeric](20, 3) and rest of VARCHAR(500) data types. ...
1
vote
1answer
197 views

SQL error log can't create/write to file

I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :) I'm running WordPress on a developer ...
1
vote
1answer
36 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
1
vote
1answer
64 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
0
votes
1answer
127 views

IIS logparser - Count distinct from cs-uri-query?

I need to count how many DIFFERENT MAC´s that have accessed my IIS webserver and have a state value of 1. The "MAC" adress and the "state" value are in the actual query (cs-uri-query) So the log can ...
0
votes
1answer
666 views

Sending Email from SQL Server Agent scheduled job

I've scheduled a job in SQL Server Agent that sends the result of a query in an email. If I execute the stored procedure from SSMS, it works fine. But the SQL Server Agent is not able to send emails. ...
1
vote
1answer
388 views

DBLIB PDO driver keeps failing when trying to connect/query Microsoft Azure SQL database

So I'm using Linux (ubuntu) and I'm trying to connect to a Microsoft Azure SQL database. Server information: The server address is a1a1a1a1a1.database.windows.net (a1a1a1a1a1 is a placeholder for ...
0
votes
2answers
56 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
1
vote
1answer
37 views

Protecting SQL from Profiling

We have some sensitive IPR in some Stored Procedures. We encrypt the stored procedures. However, at the point they are created, they are plain text. Is there anyway we can prevent SQL Server Profiler ...
1
vote
1answer
25 views

create a view to show the backup status in every 10 mins

I have a question, my table have following data: userID, startTime, EndTime ————————————— 101, 04/11/2013 11:00:00, 04/11/2013 11:55:00 102, 04/11/2013 11:00:00, 04/11/2013 11:24:00 103, 04/11/2013 ...
0
votes
3answers
252 views

Server periodically freezing - Help Stabilizing [closed]

We run an asp.net/sql server data collection website with a hand full of clients dumping data in and running reports. We moved to a new server (specs below) and have had issues with it freezing and ...
0
votes
1answer
68 views

MySQL reclaim index space after large delete?

After performing a large delete in MySQL, I understand you need to run a NULL ALTER to reclaim disk space, is this also true for reclaiming index space? We have tables using > 10G of index space and ...
-1
votes
1answer
32 views

need help scripting website reboot

I have a small website that crashes once or twice a week. I have spoken to both the websites original designers, who has now retired and its host and both blame the other. The website can be ...
3
votes
1answer
69 views

How to create SQL account that can only perform certain actions?

I'm used to working on contracts where someone else is responsible for the SQL database. However, I'm now working a contract where I must set up a new SQL Server, so I set up MS SQL Server 2012 ...
0
votes
1answer
2k views

Telnet 1433 on SQL Server Failing

I work with a number of SQL servers. Some are clusters and some are standalone. Some of the standalone servers run multiple instances and some do not. What I've found is that any SQL server I have ...
0
votes
0answers
829 views

SQL PowerShell Snapin Problems

I am hoping this is an easy fix and oversight on my part. I need to be able to run the SQL cmdlets from remote machines. I have installed Microsoft® Windows PowerShell Extensions for SQL Server® 2008 ...
0
votes
1answer
173 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
1
vote
1answer
288 views

Why I can't execute SQL query on Amazon Redshift from VPC private instance?

I have an instance in a private subnet in an Amazon VPC. This instance uses a NAT to access the Internet. I use the Redshift JDBC driver to connect to a cluster hosted in the same region as my VPC ...
3
votes
1answer
347 views

Windows Server 2012 Forest and Domain functional levels compatibility

I'm using a Windows 2003 domain, and a currently planning for a Windows Server 2012 upgrade, so I'm looking at all software which could be hurted by a Domain (and Forest) functional level raise to ...
-1
votes
1answer
46 views

Guide to choose which is the best for VM - microsoft or vmware [closed]

i am confused between VM Ware and Microsoft Hyper V whic one is the best in terms of all. is there any comparison chart then please let me know. as to run os in vmware need to install esxi; it is ...
1
vote
1answer
42 views

Terminal Server trying to connect to 1433/tcp on client

We are facing a strange issue here. Everytime a user connects via RDP client to one of our terminal server, the server itself tries to establish a connection via 1433/tcp to the client (and even ...
2
votes
1answer
1k views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
103 views

Why is SQL Server IO so much slower than the disk capacity?

I'm running SQL Server 2012, and doing a simple SELECT * query, I can see that my disk IO in performance monitor is < 10MB/s. If I do a backup of the database, however, I see values > 200 MB/s. ...
0
votes
1answer
19 views

SQl Server not connecting

I am using visual studio 2012 and SQL Server 2008 R2... My Connection String is Data Source=MCPL-PRINT-PC\SCMSQLSERVER;Network Library=DBMSSOCN;Initial Catalog=SCM_DB;Integrated Security=True Now i ...