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

0
votes
1answer
94 views

SQL Server 2012 Express - silent installation.

I am failing to silently install SQL Server 2012 Express (Advanced). I followed the guidance and this is my command: Setup.exe /q /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER ...
0
votes
1answer
64 views

Daily postgresql cron error log file

I am getting these emails daily: /etc/cron.daily/logrotate: error: error accessing /var/log/postgresql: No such file or directory error: postgresql-common:1 glob failed for /var/log/postgresql/.log ...
0
votes
1answer
109 views

How to view the SQL Server transaction log on AWS RDS?

Is it possible to see the T-SQL Query log in AWS RDS? is there a UI for that in the console, or i need to use the CLI or SQL Management Studio?
0
votes
2answers
29 views

How to view datetime when a SQL Server DB was created?

I need to see when a Database was created in SQL Server, and who created it if possible. Is there a command to get that data?
1
vote
1answer
72 views

Find out who installed SQL server - they forgot to add other logons

We have a site where one of our team of techies installed SQL Server 2012. They forgot to add our administrators group as sysadmins so only they can access SQL - everyone else gets "Access Denied" ...
-1
votes
1answer
119 views

SQL Server Express and SharePoint

We have a client that would like to use SQL Server Express with SharePoint instead of forking out a minimum or $7000 for SQL Standard. I know SQL Standard is the best option here, but the price tag is ...
0
votes
0answers
51 views

SQL Listener on Azure can't connect

I'm having an issue trying to create an SQL listener on a VM hosted in Azure. I have followed the instructions from MS on this link and everything seemed to go through fine. The listener created ...
0
votes
1answer
13 views

SQL Installation Error In Memory, Can i just add a database to an existing SQL Instance

We have an SBS running 4x SQL 2008R2 instances. i need another for the antispam product but the install fails with an error about possible corrupt memory. I've done some digging and re-installing all ...
1
vote
0answers
126 views

Understanding & Resolving Web Server Exploits

We recently had someone contact our company pointing out that we had numerous security threats that could be used to exploit our systems. They were nice enough to provide a list of these to which we ...
3
votes
1answer
29 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
0
votes
0answers
16 views

Migrating from SQL 2008 to SQL 2012 but cannot connect to the database

We are now migrating from a SQL 2008 to a SQL 2012 server. I am testing the databases one at a time as these are live databases. I have backed the database up and then restored this onto the new ...
-2
votes
1answer
77 views

Multiple attacks - what can I do

I experience multiple attacks on my server recently (for past several days). Types of these attacks are e.g.: Several SQL Injection methods (select/union/where/null, etc.) Brute force attacks (e.g. ...
0
votes
0answers
93 views

Overactive SQL Injection Attack Firewall Rules

We have a web app that our client's employees use to submit signatures from customers using HTML5 canvas to create PNG images. The signature pad is converted to base64 encoded HTTP POST data. Our ...
0
votes
0answers
199 views

SQL Server Agent shutting down minute after starting

I'm a noob :) to SQL , so please don't judge me to harsh When I start SQL Server Agent it's shutting down minute after starting . I tried to set Alerts to send email. After I configured Database Mail ...
0
votes
0answers
93 views

Why is MSSQL 2008 saying @filter_clause is invalid and that articles do not exist when creating a new publication from a script?

I have a snapshot publication on a test server with a pull subscription set up on another test server (both SQL Server 2008 R2). This publication takes a snapshot of a few columns in a few tables for ...
0
votes
1answer
189 views

update time and create time of tables is showing null in mysql

The columns update_time and create_time is having the value NULL in the information_schema Tables of MYSQL. How can the value be NULL?. Can anyone please explain?
0
votes
1answer
2k views

Constant error: “Grid edit, checkbox, Edit, Copy and Delete features are not available.”

For the last few weeks I have been getting the same message when logging on to phpMyAdmin, which prevent me from making any updates to or deleting specific lines. I get the following notice: ...
-2
votes
1answer
50 views

0.5 TB SQL Server Database, is it possible to store in a standalone server? [closed]

We are facing the task of storing of 0.5 TB of data in a SQL Server 2008 Server. Is it possible to do it in a standalone server? Later we also want to query for generating statistics of the data (a ...
0
votes
2answers
6k views

how to get mysql.sock file, mistakenly deleted from “/mysql/tmp/”

I was stuck with a PDO Exception PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in lock_may_be_available() (line 167 of ...
0
votes
1answer
165 views

Rebuilding MS Agent Jobs from MSDB table

This morning our DB server died. They restored backups to another server but these didn't include the many MS Agent jobs. Anyway I have managed to get a backup of the old MSDB table where all the ...
-1
votes
1answer
381 views

Moving SQL Server 2008 R2 Logs Causing Access Denied Error

I have just tried moving the log location for the SQL server 2008 R2 logs as I have a fairly small System disk due to the massive size of the Winsxs folder, and now I am getting the following error in ...
0
votes
1answer
63 views

AuthDBDUserPWQuery with multiply tables

I have a MySQL authentication for SVN server. Configuration file looks like this: <Location /svn/project> ... AuthDBDUserPWQuery "SELECT Password FROM SVNUsers WHERE Nickname = %s" ...
0
votes
1answer
14 views

Crossserver SQL Procedures Failing Mid Process

Really need help understanding whats happening. We have two LANs at work with a shared subnet between them acting as a bridge (migration from A > B underway) we recently migrated the server subnet ...
0
votes
1answer
61 views

Sql server 2008 r2 services won't start

We lost power couple of times and I suspect that the UPS didn't keep the server on. I checked the log and it shows that there were couple unexpected shutdowns. I was try to login to sql server ...
2
votes
0answers
958 views

Intermittent Error SQL Server Error 67 and 17

We are running Windows SQL Server 2012 Standard on Windows Server 2012. There is a SQL Database with an Access Front End which we migrated from older versions of Access and SQL. The Access front end ...
-1
votes
2answers
206 views

Amazon RDS - UTC daylight savings

I haven't been able to get AWS support on the line and need an answer asap - do the SQL instances on Amazon Web Services RDS use daylight savings? I know the timezone is UTC but not sure if it uses ...
0
votes
0answers
61 views

SQL Server 2014 Standard 2014 no access and bad preformance

My company looks after a server which is running SQL Server 2014 Standard Edition. The main application database on the server is replicated out to about 20 subscribers. The server has only been in ...
1
vote
1answer
204 views

Password case sensitivity when upgrading from SQL Server 2000 to 2005

Anyone please help! Today is 3rd day that I'm banging my hand to solve this problem. So the situation is, I've inherited a project which worked on SQL Server 2000, later client decided to upgrade the ...
0
votes
0answers
76 views

Network Issues Connection to SQL database on MS server

Prior to asking this question, I followed this thread: Cannot telnet to SQL Server on port 1433 I am attempting to connect to a database on a server distinct from the computer upon which I am ...
0
votes
1answer
75 views

Is an HP Proliant 350e Gen8 server appropriate for Primevera and Sage applications? [duplicate]

I want to buy a server to accommodate both the Primevera and Sage applications? Would a HP Proliant 350e Gen8 do? Are there any concerns about this platform?
0
votes
0answers
235 views

SQL VSS Writer missing from VSSADMIN

We just installed the latest updates for patch Tuesday onto our AD FS 2.0 farm members. Everything went fine except for one of them, after the updates were installed and I rebooted the server, the ...
0
votes
0answers
82 views

MySQL character-set-server won't take effect

I'm trying to have my MySQL server use UTF8 as the default collation and character set. I am able to set everything except for the character_set_server which always takes 'latin1' as value. I have ...
1
vote
0answers
139 views

How can I unlock a large amount of files on isilon storage if a process had them open?

Some background information : I have a couple SQL servers that have half their databases on isilon storage (I know, no bueno. I'm in the process of moving them). During the night one of those SQL ...
1
vote
1answer
37 views

Innodb tables not showing

If I run query show table in mysql console, the innodb tables will be listed. But when I tried a query like select * from tablename, it says table does not exist. How can I fix this issue and make ...
0
votes
0answers
53 views

SQL Server Management Studio Import Wizard

I am trying to import a small excel spreadsheet into SQL using the SQL Server Management Studio Import Wizard, which is running on the Windows server (2008 R2) itself. When clicking "Import Data" from ...
0
votes
1answer
253 views

CUCM Nested SQL query to link devicepool and licensing

Cisco's licensing manager has a shortcoming in that it provides licensing data per enterprise instead of per cluster. I am attempting to utilize SQL queries to produce this data. Currently, i have two ...
0
votes
1answer
39 views

SQL Server Backup to Azure Tool

I downloaded and tried the Microsoft SQL Server Backup to Azure tool for SQL Server 2008. My goal was to get access to the backup compression functionality built into it. I have it configured to ...
0
votes
1answer
96 views

Upgrade from SQL 2008 to SQL 2012: do we need to change connection string?

We are seeing some terrible performance degradation having just upgraded our MVC4 application from SQL 2008 to SQL 2012. Queries run directly in management studio on the database server run somewhat ...
0
votes
1answer
119 views

Delete files except ones created on sundays with in last 4 weeks

I have a script that copies some files around and deletes older files from destination. right now it just deletes everything older than 10 days. to increase backup retention we need to keep files that ...
0
votes
0answers
74 views

MySQL, Table marked as crashed after vServer reboot

i am using a vServer in a data storage center. Sometimes the host machine is rebooted by data center admins which causes the vServer to be rebooted too. After every reboot the database crashes, the ...
0
votes
0answers
33 views

After upgrading to TFS 2012 is it safe to uninstall “Microsoft Team Foundation Server 2010 Sharepoint Configure”

After upgrading TFS from 2010 to 2012, I find that in Add/Remove Programs, there is till this software listed: Microsoft Team Foundation Server 2010 SharePoint Configure Also, I still see the ...
-2
votes
1answer
79 views

do all type of sql server license have SA account? [duplicate]

We are trying to upgrade our sql server from 2005 to 2012. we got some offers for different type of license from some resellers. the only thing I'm not sure now is, there's one type core license with ...
0
votes
1answer
88 views

Single website across multiple servers [closed]

Please forgive me if I'm using incorrect terminology. I tried searching for my question, but I'm not quite sure how to word it in terms simple enough for a search. I found this post and this post ...
0
votes
2answers
2k views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
0
votes
1answer
337 views

Database Copy Fails, but nothing fishy in the logs

I am attempting to copy a database from a remote server (sql server 2008) to my local machine (running sql server express 2014). Everything looks great, right up until the job fails at "Execute SQL ...
0
votes
0answers
59 views

SQL Server Reporting Services 2012 Chinese Language

When running reports in SQL Server 2012 Reporting Services (SSRS), Chinese (Asian) characters show up as question marks (?). Any idea on how to have the characters display properly in reports? ...
0
votes
1answer
68 views

SQL, website and desktop application on a Windows Azure server?

I recently started considering Azure over my current VPS host PhotonVPS for Virtual Machines. I assume that Virtual Machines are the same as VPS servers (please correct me if I am wrong about that). ...
0
votes
0answers
111 views

Any other option than HTTPS + Basic auth for reverse proxied IIS site that uses double hop authentication to SQL server

We've been struggling for a while to get, what I had assumed would be a relatively common scenario to work and would appreciate any pointers. We have 2 x Windows 2012 Servers running IIS Server SQL ...
3
votes
1answer
156 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
54 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 ...