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
0answers
10 views

mySQL query error in IPB

Im using Invision Power Board (IPB) and have some trouble accessing admin panel. From time to time I get this error and I need to login again to actually log in: Date: Fri, 29 Jul 2016 10:19:50 +...
1
vote
0answers
15 views

Show or log long queries with values instead placeholders

I have any very long sql query in postgresql. I tried show what postgress do with: select * from pg_stat_activity unfortunately I see something like: select some_fields from anytable1 anytable2 ...
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
8 views

Query to create a matrix of values from one Column [closed]

I'm new to SQL and I have a very tough task on hand. I have a data set of about 50000 records that looks like this. Header Value 1 Value 2 Value 3 Value 4 Value 5 Value 6 Value 7 Value 8 Value 9 ...
1
vote
1answer
32 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
0answers
4 views

sql - Select boolean strictly true [migrated]

I want to select a row Ad as boolean which is strictly true. I am using the following SQL statement. SELECT 'user' AS username, 'pass' AS password, true AS Ad FROM users LIMIT 1; However the above ...
1
vote
0answers
19 views

Is it possible to see who disabled a SQL backup job?

I'm looking to see if it's possible to audit who disabled a SQL backup job in Microsoft SQL 2008's SSMS on Windows Server 2008 R2. We have a couple admins and I'm attempting to pin point who disabled ...
0
votes
2answers
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 load....
0
votes
0answers
8 views

SQL parsing XML [migrated]

I'm receiving XML files as part of an EDI setup and I'm having an issues getting information from the child elements. Here is the XML file: <?xml version="1.0" encoding="UTF-8"?> <cpi_event&...
-1
votes
0answers
13 views

SQL Witness size

I've been unable to find any reference from Microsoft's TechNet nor MSDN site outlining the size requirements for a SQL witness instance. I recall from a Windows Server witness setup, it's barely a ...
0
votes
0answers
13 views

WMI10 Report server error followed by SQL Server Reporting Services error

Anyone have any idea how to overcome those issue? Inside my Event View, I found those error lists which I need to resolve in order to successfully run my SQL reporting service. reportserver (WMI10) ...
0
votes
1answer
12 views

unable to run report server

Can you shed some light on this issue with SQL report server(2012)? I can't run SQL report Server from SQL Report Server Configuration. The error message is "the server didn't respond in a timely ...
-3
votes
1answer
28 views
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
9 views

No SQL result output from sql executed from bash

When executing an SQL from a shell like this, the sql result output isn't printed. How do I do it ? mysql -uroot -p < /root/queries.sql Edit: When the content of the sql is a SELECT, I do see ...
14
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 (http://...
1
vote
1answer
1k views

How to rebuild 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 ...
0
votes
0answers
27 views

SCCM - Find when an application deployed to a specific computer

Is it possible to find when SCCM ran a deployment against a specific client PC, from the server? (CAS, primary or even secondary will do so long as I can script through to the data starting with only ...
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
1answer
1k views

Azure Database Permissions

Is it possible to create a Server Login with a Master database user that is able to create a Server Login with a Master database user ? I have not been able to do this, I always need to use the Admin ...
0
votes
1answer
18 views

Quering history of network interface in zabbix server return empty set?

I've installed Zabbix on Ubuntu. Although I can see a "graph" and related "latest data" for all network interfaces in Zabbix front-end, there is no data for them when I directly query MySQL database!...
1
vote
2answers
554 views

Dynamic column enumeration for preventing SQL injection

I have an application which is completely for internal use but I'm trying to make sure I have my bases covered on SQL injection. Unless someone else has some information to point me otherwise there ...
0
votes
0answers
6 views

SQL Server 2014 High CPU

When finding out which DB is most CPU Consuming I get the database with ID 32767 (internal resources database) on top of CPU, 88% to be precise. How can I check why is this happening? Thank you
0
votes
1answer
12 views

cant connect to sql server express on server from client

I just install sql server express on server with ip 10.222.117.17. I've been deactivated the firewall so i can ping server from client or my pc. but when i try to connect with navicat or management ...
0
votes
0answers
10 views

Convert into multiple data ranges

I have employee data link below This is one example in the file a have multiple lines. Initial input can have more than 2 lines for each employee but convert logic will be the same. Thank you ...
3
votes
6answers
4k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 (42000)...
1
vote
3answers
19k views

MS SQL Server 2008 R2 Product Key

We are needing to perform a repair installation of our MS SQL Server 2008 R2 installation and cannot locate our original product key. Is there some way in which we can recover our product key from ...
0
votes
3answers
116 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 '/var/run/mysqld/...
0
votes
2answers
21 views

Uncompress an SQL file give a binary file

I created and compressed (with bzip2) a SQL dump from a production server on Linux. I want to create a shell script to automatically import it in the database of my development environment (on Mac OS)...
0
votes
0answers
13 views

Where are stored phpMyAdmin SQL import files?

When a data file (SQL, CSV, XML…) is imported with phpMyAdmin, is it in volatile or non-volatile memory? If it stored on hard disk, is it temporary? When the file is deleted and what is the default ...
1
vote
0answers
25 views

How can I list the privileges associated to a custom created role in SQL Azure database?

I have created a custom role in a SQL Azure DB, granting a couple of privileges. How can I, at a later time, list the privileges associated to this custom role? We need this for an audit on the DB ...
1
vote
1answer
16 views

Is it possible to use SQL in Exchange transport rules

I'm looking into using Microsoft Exchange transport rules for adding some dynamic content to email signatures. I already know that I could pull dynamic data from Active Directory, but I haven't found ...
0
votes
0answers
37 views

missing components on SQL server 2016 installation

I'm trying to install SQL Server 2016 (Developer or Evaluation edition) to get familiar with it as I have not used it for several years. Downloaded SQL Server Developer from Visual Studio Dev ...
0
votes
0answers
17 views

AWS Windows SQL EC2/EBS application consistent snapshot

Has anyone found a way to take a EBS snapshot for a Windows Server that maintains Application Consistency? In my case it's with SQL and I'd like to maintain SQL app consistency. Either via quiescing ...
0
votes
1answer
80 views

i am getting the following error MSSQL$SQLEXPRESS Application log on my server

TDSSNIClient initialization failed with error 0x80092004, status code 0x1. Reason: Initialization failed with an infrastructure error. Check for previous errors. Cannot find object or property. ...
0
votes
0answers
12 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
18 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
18 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
29 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
30 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
0answers
15 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
32 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
0answers
256 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
46 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
91 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
34 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 ...
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
32 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
11 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 ...