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
11 views

SQL Failover Cluster Clients not updating DNS

I have a multi-subnet SQL Server 2012 failover cluster running on 2 Windows 2012 R2 nodes. The cluster is located on 192.168.1.10 when on NODE A and 192.168.5.10 when running on NODE B. When I look at ...
0
votes
1answer
2k views

SQL Server doesn't allow to execute subquery as dynamic SQL

I tried to make a dynamic SQL which gets all tasks for some users The procedure [GetAllSubExecutorsByUserId] returns IDs of all subalterns of curent user I write these IDs into a temporary table, and ...
0
votes
0answers
11 views

SQL Event Notifications to Remote Server

I have event notifications for SQL and I currently have them writing to a another DB on the same database server. Is there a way to have it write to a remote DB on another DB server? My goal is to ...
0
votes
1answer
11 views

Insert multiple sql files

I've 297 sql files, I want import them to mysql but it must be in different databases. I tried: find . -name '*.sql' | awk '{ print "source",$0 }' | mysql -u <db_user> -p --batch -D ...
0
votes
0answers
9 views

Strange Postgres PreparedStatement behaviour (JDBC)

i have a strange problem with the following parameterized PreparedStatement in Java: PreparedStatement ps=DBUtil.newPreparedStatement( "SELECT * FROM msg as m WHERE " + ...
0
votes
2answers
19 views

SQL randomly disconnects in the middle of querying data

I have a strange problem - when I am querying SQL table with more than 9000 rows, SQL randomly disconnects with some unrelated error. 1.) What I mean with randomly disconnects: On average it happens ...
1
vote
2answers
29 views

Business Intelligence for VS 2012 on WS2008 R2 Enterprise

I have Windows Server 2008 R2 Enterprise, x64 with Visual Studio 2012 Pro. I want install Business Intelligence, but can't do it: What I do wrong? Solution: use it
0
votes
1answer
4k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
0answers
7 views

SQL Sending Maintenance Plan Notification WITH the actual error message

For some time, we searched for a solution to provide details from a failed SQL Maintenance plan to the IT Support team, who were responsible for the services being scheduled; trying to escape the ...
0
votes
1answer
1k views

directory not owned by the 'mysql' or '_mysql' user

I have recently installed MSQL for a Rails App. After some tinkering, I have an error starting mysql now that reads as follows: Warning: The /usr/local/mysql/data directory is not owned by the ...
0
votes
1answer
16 views

Allowing remote connections to SQL Express

On Windows 2008 Server R2, I installed SQL Server Express 2014 successfully and enabled TCP/IP on the default port (1433) and also added an inbound firewall rule to add port 1433. The database option ...
0
votes
1answer
2k 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. ...
0
votes
0answers
77 views

SQL Server 2016 RC2 and RC3 Install ERROR (Pictures and logs provided)

Can't install, updated Windows Server 2012 R2 fully with all Optional and Important Updates. I enabled a proxy to gain outside access which works (since Windows updates work). There is no anti-virus ...
0
votes
1answer
17 views

How to change interface language of sql server 2008?

As you can see in the image below, the SQL Server Interface language is in Spanish and I want to change to English. I tried my best to find a way to change it without uninstalling this Spanish ...
-1
votes
2answers
62 views

MS SQL Server 2 identical databases on different servers replication or mirroring to each other possible? [closed]

Hi: I have one free version of SQL Server 2012 express database running on Amazon AWS with 1 CPU and only 1 GB Ram . As you can see the CPU and RAM power are barely enough for my PHP scripts running ...
0
votes
1answer
19 views

Azure SQL Database Failover But Use Same DNS Name

I am researching ways to make a highly available web application in Azure using the PaaS App Service and DBaaS SQL Database offerings. Standard databases include Standard Geo-Replication to ...
0
votes
2answers
66 views

MySQL stopped running on Ubuntu: Can't change to run as user 'mysql'. How to save data?

Today out of the blue stopped running MySQL on a Ubuntu server. When I try to log in there, I get this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket ...
2
votes
2answers
9k views

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: ...
0
votes
1answer
25 views

MSSQL query not working, even if there is data

Trying to run a more complex SQL query on an MS SQL server, but I get no data output. Logically should be fine, but I cant see why it doesnt work: SELECT D.NAME DATABASE_NAME,T.NAME TABLE_NAME,I.NAME ...
0
votes
1answer
22 views

SQL Server Mirror issue on Mirror side

Team, I am having an issue on one of my Mirroring environment. It is SQL2008R2. DB mirror was somehow broken between principle and Mirror side. Someone(Not sure who is he/she due to offshore support) ...
0
votes
1answer
10 views

Use LDAP on top of simple mysql hash+salt user table

We have a huge table full of user accounts for our website that are stored in a very simple and standard mysql manner: the user-id is associated with a salted hash that represents the password and ...
6
votes
7answers
20k views

How to rollback a deleted table data?

I have deleted one table accidentally how can I rollback that. Please suggest that.
1
vote
1answer
36 views

Intermittent Server Performance Degradation Troubleshooting

I have been troubleshooting an intermittent server performance issue for too long and I am running out of ideas. I am looking for any suggestions as to how I might be able to identify the cause of ...
0
votes
2answers
156 views

Disabling TLS v1.0 with SQL & RDP

How do I disable TLS 1.0 without breaking MS SQL & RDP on Windows Server 2008 R2? If I simply disable it, RDP stops working along with MS SQL. Tried googling but I can't find a solution. Is this ...
6
votes
3answers
11k views

How to monitor activity on a single table using SQL Server profiler

I have a table which uses and identity seed for its unique identity column. We have noticed some massive jumps in the identity value which we are not able to explain. The table has 20,000 odd rows, ...
-2
votes
3answers
75 views

Transition legacy software from Windows XP on Windows 10

I have a 'general' question regarding transitioning legacy software from Windows XP to Windows 10. I will provide all relevant info and the reason for doing so. Firstly, the legacy software was coded ...
3
votes
2answers
2k views

SQL server 2005 attach without transaction log - urgent !

We had a crash in the sql server and the database remained in inconsistent mode. We lost the transaction log file and the last generated backup is too old. I googled this issue but mostly relevant ...
0
votes
0answers
29 views

Setting up Active Directory, Adding Machines with Different OSes & adding a server with an instance of SQL

I have 2 servers to manage at work, a Dell Poweredge with has a software called "Abecas" which uses SQL Server, The Poweredge is running Win Server 2008, there is no AD in place as of yet. I have ...
3
votes
2answers
2k views

How to count unique values?

I am trying get the number of unique ip_addresses (in this case '3'). The table looks like this: Structure: CREATE TABLE bandits ( key text NOT NULL, ip_address inet, offence text, count ...
0
votes
0answers
16 views

How do you speed up an SQL query on a huge database? [duplicate]

I'm currently dealing with a table that has 30 million rows of 8 columns. I'm only selecting the columns that I need. SELECT column_a, column_b FROM table_name This is happening from a python script ...
4
votes
3answers
7k views

How does SQL Server handle simulataneous read/write requests?

Background: We have an application which uses an SQL Server 2008 database heavily. We are trying to optimize this application. It was single threaded, and we noticed through logging/ profiling of the ...
0
votes
1answer
11 views

auto grow SQL 2008 in relationship to file groups

I am moving some indexes\tables to a secondary file group. What are the ideal settings on the DB in question in regards to the 'Auto Grow' options after the tables moves ?
0
votes
1answer
21 views

MS SQL replication run only with system account

I'm trying to configure a new replication with SQL Server 2012 I configured the distribution While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user ...
2
votes
1answer
554 views

Viewing history for Maintenance Plan causing out of memory exception

I am trying to view history for a maintenance plan but keep getting an out of memory exception. It seems that the problem is that SSMS can't access memory beyond the ~3gb range. I've tried to find an ...
1
vote
1answer
3k views

How do I import large sql file to local LAMP (xampp) environment [closed]

I have used Linux to import a large mysql dump file (into a new database), but am new to how the process works in a local LAMP environment using xampp, as xampp does not support SSH. I've dowloaded ...
0
votes
3answers
6k views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
0
votes
0answers
25 views

MS SQL - HA & load balancing best solution for servers at different geo-location

Customers has App server (MS Server 2012) and Storage server (MS SQL 2012), with several hundred clients accessing server app via VPN. Now they want to have a high-availability and also load ...
1
vote
1answer
39 views

SQL Server Full BackUP functionality

In SQL Server 2008 R2 (or Any other Version); Transaction-1 had started at 11:50:00 and it takes 1hr.5min to complete(i.e., completed at 12:55:00) and Transaction-2 had started at 17:45:00 and it ...
0
votes
0answers
10 views

SQL request in Bacula database

I would like to get all the files that are at least in one job which is now saved on one determined tape in the Bacula database. This could replace a tape listing. I have tried several request to ...
36
votes
6answers
72k views

GRANT SELECT to all tables in postgresql

Is there a one-liner that grants the SELECT permissions to a new user postgresql? Something that would implement the following pseudo-code: GRANT SELECT ON TABLE * TO my_new_user;
0
votes
1answer
12 views

SharePoint 2010 not accessible

My complete SharePoint 2010 site is not accessible. However, the admin site is. The database is still OK. Error: Cannot open database "WSS_Site_Content" requested by the login. The login failed. Login ...
-1
votes
1answer
42 views

Web page generating error on SQL stored procedure [closed]

I am a total newbie to SQL. I am a networking specialist so like most smaller IT positions I kind of got this problem dropped into my lap. I have been able to pinpoint some issue through event logs ...
1
vote
2answers
46 views

SQL Edition, serverproperty

I am trying to find all the sql installations in our network. I found more than 100 machine names which has sql installation. I tried to connect to those machines via client tool, but was not able ...
0
votes
0answers
13 views

Separated Java EE and PHP APIs running in the same machine and sharing the same SQL database general workaround

Having in mind the Java EE and the PHP APIs are completely separated (this is not about using java processes from PHP or PHP processes from java) and they will only share the database, is there any ...
0
votes
0answers
33 views

Connection issues after separating database from the web services

We had performance issues where server would run out of resource and decided to move database onto another server. It seems to work but crashes every few minutes with the following errors: Warning: ...
0
votes
1answer
223 views

Is this an SQL injection attack? If so, what's it trying to do?

I'm seeing a number of entries in my access log where 'A=0 is added to a query parameter, eg: http://www.server.org/foo/?bar=1'A=0&type=xml The parameter that 'A=0 is attached to varies, but ...
4
votes
1answer
100 views

SQL Azure insert query ten times slower on V12 than V11?

I noticed performance degradation about two weeks ago impacting one of our applications with an SQL Azure backend. It's running on V12 on tier S1 90% of the time, sometimes scaling to S2, S3 or P1. ...
13
votes
6answers
23k views

How can I diff two Oracle 10g Schemas?

I have the feeling that there are some difference between two large complicated Oracle schemas which should be identical, so decided to dump and diff them to investigate. I found an article ...
0
votes
2answers
77 views

Unable to start SQL server agent automatically

I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix ...
8
votes
4answers
18k views

mdf file cannot be overwritten when restoring a database in SQL Server

I got a databse A. It has some data in it. I created a backup for A as A.bak file. Then I create a new empty database B. And then I try to restore B from A.bak. But the SQL Serve tell me the following ...