Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql]

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]

-2
votes
0answers
13 views

Not able to extract values from database table [on hold]

I have established a connection between python script and sql server using sqlite3. I am not able to extract values from database table. Getting error that table does not exist.
1
vote
2answers
26 views

Uninstall a single server instance through the registry

I'm running SQL Server 2014 and have 50 separate instances running. This is the max limit of number of instances for this version and I obviously need to uninstall some instances and clean up. ...
0
votes
2answers
56 views

How do I get SQL Server Management Studio to find a .bak file to restore?

I am trying to turn a .bak file into a database. I can't find the "Restore Database" button when I left-click "databases" when connected. This is what I should see. However, this is what I see. I ...
0
votes
1answer
21 views

SQL SSMS on development - clear ldf files

Working on building a big SQL Server database, I noticed my C drive is running out of space when running heavy SQL queries. The following folder size is over 150GB, log.ldf files reach over 50GB. C:\...
-1
votes
0answers
32 views

How to generate a query from gsuite to sql server 2012?

As you will notice, I am just getting to know the GSuite products and I need to connect from one of their products (from gsuite) to a server SQL server 2012 to extract data ("Views") to gsuite. some ...
-1
votes
1answer
21 views

linux mysql convert .sql.tar.gz to csv

I have a .sql.tar.gz file tht ws generated by mysql export is there any command in linux to convert this sql.tar.gz file to csv? Thanks
-2
votes
0answers
15 views

Why does SQL 2016 installation also install a SQL 2008 Installation Center?

Why does SQL 2016 installation also install a SQL 2008 Installation Center and can I uninstall the 2008? Thank you
0
votes
0answers
23 views

Run SQL Server Standard 2017 Edition Together with SSRS 2017 Developer Edition

Has anybody ever tried running SQL Server 2017 Standard with SSRS Developer Edition and had it worked successfully? I'm setting up a client environment in Azure. This will be there production ...
0
votes
1answer
39 views

Where are Azure SQL Database Backups Stored

I've got 5-6 Azure SQL Databases running. They run in the Basic and Standard pricing tiers. From what I've read backups run by default which allow for the Point in Time restore options to work. ...
-1
votes
0answers
29 views

Upgrading Database on a 2016 SQL Always On Cluster

We have a SQL Always On cluster with a few databases and planning to upgrade a web content management system (Kentico) which in turn upgrade one of the databases. We also have a couple of web ...
0
votes
0answers
365 views

Access denied; you need (at least one of) the SUPER privilege(s) for this operation - Strange issue with MariaDB instance on shared server

I have local instances of MySQL 8.0.12 and MariaDB 10.1.31. Both have a database "ExampleDB" when I execute the script below there is no issue: CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` ...
-1
votes
1answer
183 views

How to create a SQL Server Database from DBML [closed]

I have corrupted an entire database and I have no access to it or backups. Is there a way to recreate the structure of it using a .dbml from visual studio project? Thank you in advance.
-1
votes
1answer
17 views

Granting privileges for a user doesn't appear to apply even after flushing

I'm working on creating a test system and need to grant a user remote database access. I'm doing this with the following: mysql> SHOW GRANTS for codingo; ERROR 1141 (42000): There is no such grant ...
0
votes
0answers
48 views

SQL Server 2017, 2012 Express Edition Insert Select Performance Issue with very less data

Command 1: (Get Count from View1) Select Count(*) From View1 Results: ----------- 183 (1 row affected) Execution time = 11 seconds Command 2: (store the count in a table called Temp) Drop Table ...
0
votes
4answers
382 views

Joins performed without indexes: 5568

I was trying to do mysql optimization. Yesterday the CPU usage was 100%. I am trying to optimize with mysqltuner but this time I gave a mysqltuner warning. I have a high-traffic db. 500-600 ...
0
votes
0answers
126 views

Untrusted Domain connection error - Windows Authentication SQL Server 2017

I hope you can help with a mysterious Windows Authentication error. We have a new member of staff who can connect to our PROD SQL Server environment via SSMS without issue using Windows ...
0
votes
1answer
41 views

Windows server fail over clustering between two seperated server [closed]

i have two windows server with speared location,hard and SQL server. how i configure failover between them (IIS and SQL Server)? is there any scenario for this ? is it better to use shared storage ? ...
0
votes
0answers
28 views

SQL Transactional Replication Overwriting Full-text Indexes

Very basic question: I am running SQL 2016 transactional replication to an Azure SQL db. It copies over everything but in doing so, it deletes the full-text indexes which then leads to more issues ...
2
votes
1answer
236 views

Mysql high cpu usage (over 600%)

The server has 8core CPU and 22 GB of ram. Every day receives many requests from users, and recently a replication mechanism has been activated, with an implementation of a db master and a slave. Now ...
1
vote
1answer
50 views

Google Cloud SSL server CA rotate

The Google Cloud Console is prompting us of impending expiry of the certificate on a Google Cloud SQL instance. We have multiple services which connect to this database instance: Compute Engine (via ...
0
votes
0answers
58 views

How to set up a multi subnet sql always on availability groups in google compute VM's?

I have two sql nodes vm in two different subnets. I wanted to know how to set up network or NIC for virtual IP's. Apart for SQL node IP; two cluster IP addresses will be used from each subnets. One ...
0
votes
0answers
34 views

Unable to connect to a new installation of sql server

I just installed SQL Server on my Windows Server 2012 R2 box. The installation went well but my apps can't connect to it. If I use the public DNS name for the server in the connection string, the ...
0
votes
1answer
17 views

How to keep Active Directory and SQL users from breaking after a database restore?

I'm trying to copy production CRM MSSQL data to another isolated server stack (server 2) via a backup-and-restore process. Server 2 already has most of the data after a restore I did from the ...
0
votes
1answer
50 views

Oracle 12c 32-bit client and direct GOT relocation R_386_GOT32 against `lxecerr’

When trying to install Oracle 12c 32-bit Client (12.1 or 12.2) on Oracle Linux 7.3 or 7.5, it throws error during linking static libraries: INFO: Start output from spawned process: INFO: -------------...
0
votes
1answer
42 views

How to run SQL server 2012 instead of 2014 when both are installed and 2014 is currently running?

I need to backup a DB using SQL server 2012 to match another server it is going to. However on my local machine I'm currently running 2014. I can see that SQL server 2012 is installed along with ...
0
votes
0answers
32 views

SQL SERVER 2014 copy a multi file group database to a single file group db for transferring to azure

I have been trying to transfer a 1TB sql server db to azure sql db for performance assessment. I tried using Data Migration Assistant many times but it hangs and exits every time during data transfer. ...
0
votes
1answer
63 views

connecting google cloud sql to spotfire

I'm trying to connect google cloud SQL to Tibco Spotfire. In Spotfire I opened the "information designer" -> "setup data source" and chose MySQL5. In the connection URL I have jdbc:mysql://google/...
0
votes
1answer
64 views

SQL Server Sort Order to Binary Search on SQL Server 2008 SP1

I am installing an OLT Software that requires Windows SQL Server 2008. I am getting this error below; The database sort order must be "binary sort". Please run the Transact-SQL command ...
0
votes
0answers
214 views

Sql availability group listener not failing over

We have built two sql clusters with always on availability groups, based on the windows failover cluster service. This is done as per Microsoft documented process, however we are getting some ...
0
votes
0answers
65 views

SQL Server 2016 replication monitor from the slave ( subscriber ) without admin access to the publisher

Question: Is it possible to check the replication status of SQL Server 2016 from the slave ( subscriber ) without admin access to the publisher? We have an SQL Server 2016 which is a slave ( ...
0
votes
0answers
47 views

Error 1222 when trying to refresh my database

Hoping some more server-savvy fellows can help me I've been using SSMS for some time with the product our team develop here just to run simple queries etc. Basically my problem is that I went to do ...
0
votes
1answer
224 views

mariadb in chroot gives Access denied for user 'root'@'localhost' even though password is set

I have a script that runs mariadb in a chroot, its a qemu-arm-static rasoberrypi chroot but I don't that that should change much. The script installs and then sets the password for mariadb root user, ...
0
votes
0answers
51 views

wordpress Got packet bigger than 'max_allowed_packet' bytes when dumping table `wp_options`

For over 6 months now, by automatic daily database backups are failing every time. My wordpress database is around 100MB but the backups are only 700KB. Every single backup fails after backing up ...
0
votes
1answer
80 views

List Everything that uses a linked server in sql

I am currently facing an issue communicating with a SQL server which has been moved and the database which I was looking info has been removed. I have been using an alias manager to divert all traffic ...
1
vote
1answer
272 views

Can SQL Server 2005 Use TLS 1.2 for Web Apps?

Hoping for some help as this is a bit new to me. We have a legacy app running ASP with a separate SQL Server 2005 running on Server 2003 instance. I'd like to required TLS 1.2 for all web app ...
0
votes
0answers
111 views

Reach Azure SQL single database from Azure VPN

I'm setting an Azure VPN with the next configuration, I've added both, the subnet and the gateway, to the azure sql single database firewall, but when I try to connect to the database from a client (...
1
vote
1answer
533 views

Can't connect to SQL through Virtual Machine when running Selenium Tests

To preface the back story one day i just booted my VM and i couldn't run the test. We had it set up to run prior and everything was fine. The setup we have currently is that i am running my local ...
0
votes
1answer
30 views

Slow SQL Queries over local net

Slow Queries for SQL over 1Gb link between servers using just SSMS Server Configs: Main SQL Node: 32GB Ram 16 cores Sage Evolution Server: 16 cores 16GB ram The config of the servers is that they ...
0
votes
0answers
21 views

What MS licences would allow us to host client systems? [duplicate]

As I understand it, Microsoft licencing is tied to an organisation. My company is a gold partner and has volume licensing. We're toying with the idea of hosting some of our clients systems, but don't ...
-1
votes
1answer
47 views

Best database (SQL\NoSQL) for storing file hashes and corresponding description [closed]

I am working on a system that store file hashes and a corresponding description basically, the structure is very simple just 1 table, HASH (key) and File Description. For example: ...
1
vote
0answers
53 views

SQL Merge Replication Triggers Missing

In MS SQL Server 2008R2 SP3 Standard, I'm seeing an issue where reinitializing a merge publication with a new snapshot deletes all of the merge triggers from all of the tables, and then when snapshot ...
0
votes
0answers
209 views

SQL server error with IIS user login fail (keeps showing computer name)

I'm having a rough time setting up IIS to run locally (and yes I do need it to run locally not IIS Express). I have everything running just fine. I have two things I need specific rights for. I ...
0
votes
0answers
54 views

Best use of SQL Server Enterprise cores in AlwaysOn Availability Group deployment

I’m looking to do a deployment of SQL Server Enterprise edition using AlwaysOn availability groups, and I’d be very grateful for any recommendations on the best way to do this with 4 cores of ...
0
votes
0answers
296 views

Not able to connect to Availability group Listener

I have an availability group configured for 2 servers SQL Server 1 and SQL server 2. From client, I am able to connect to SQL Server 1 and SQL Server 2 separately. But when I try to connect to the ...
0
votes
0answers
40 views

SQL Server 2012 not reinstalling

I have uninstalled everything from control panel with sql server 2012 It can never get past the first window of installation which has product key, license terms, product updates, install Setup files....
0
votes
0answers
53 views

Activate/Register SQL Server on Ubuntu Linux

We installed SQL Server 2017 Standard on Ubuntu Linux. It really worked quite well. However, we did not find out where to put in the License Key. There is no doc mentioning anything about it. We are ...
0
votes
0answers
45 views

Sync issues to Azure from SQL server

I wanted to file a support request through the Azure portal, but appearently our support plan is no longer available. Since we wanna move forward as quickly as possible, i figured let's give it a try ...
0
votes
0answers
61 views

Azure SQL Query Performance Insight not working

Been having this issues for weeks (months maybe). In the Azure dashboard and then into our Azure SQL DB we open "Query Performance Insight" to monitor performance but it never works. The monitor ...
0
votes
1answer
479 views

execstop mysql error on stop and restart

prerequisite: os: kali-linux 2018.1 uname -r: 4.14.0-kali3-amd64 mysql version: mysql Ver 15.1 Distrib 10.1.29-MariaDB problem: yesterday i had setup an apache server with this help, https://www....
0
votes
0answers
112 views

SQL failover cluster node fails over even when able to reach the cloud witness

I have a two-node multi-site SQL Server failover cluster using Azure as a Cloud Witness and one of the nodes keeps failing over automatically if it loses communication with the other node despite ...