Server Fault Stack Exchange
Server Fault 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. [mysql], [postgres], [mssql], or [oracle].

An abbreviation of "Structured Query Language," SQL is a database language used to manage data in relational database management systems.

Due to many vendor implementations of SQL (such as T-SQL for SQL Server & Sybase, PL/SQL for Oracle and PostgreSQL and MySQL) it is a fractured language and syntax that works with one vendor may not work with another.

1284 questions
0
votes
0 answers

Simulate Outage on primary SQL Server in Azure Failover Group

I have a SQL Server with SQL Database in Azure that is replicated to a secondary SQL Server with a Failover Group. We have some functionality in code to redirect failed read requests to the secondary in cases where the primary is inaccessible but…
Rob Mosher
  • 101
0
votes
0 answers

unixODBC SQLFetch infinite loop after INSERT statement

I'm trying to work with unixODBC and a SAP Hana database, and created a simple C program to INSERT/SELECT into the database. My problem is, if I use for example SQLExecDirect(stmt, "SELECT * FROM NEWTABLE;", SQL_NTS); while ((ret = SQLFetch(stmt))…
SrKurtz
  • 1
0
votes
0 answers

GCloud SQL timed out on a Docker container

I have a flask app in a Paperspace Deployment Docker container. It is connected to a Google Cloud SQL (MySQL). Here are the variables in the YALM parameters: env: - name: CLOUD_SQL_CONNECTION_NAME value: xx.xx.xx.xx - name:…
NicolasSens
  • 1
  • 1
0
votes
1 answer

Unable to connect to a remote SQL Server instance 2005 over a VPN

I'm running SQL Server 2005 on two different servers running Win XP. The two servers are in different physical locations and are connected via a dedecated point to point data link in a virtual private network(VPN). Im only able to connect to the…
Jack Njiri
  • 145
  • 5
0
votes
0 answers

How best to allow SQL Agent Jobs to be edited and run by a team of developers, without handing out Sysadmin rights?

I'm trying to find or devise a way to allow a team of developers to be able to amend SQL Agent Job steps and schedules, but that doesn't involve Sysadmin rights for the devs. As I can't assign ownership of Agent jobs to a Group I need some sort of…
Potatan
  • 13
  • 8
0
votes
3 answers

How to grant persmission for this sql?

How to grant permission for this? Thank you for your help! ERROR is : ERROR 1142 (42000) at line 2: CREATE command denied to user '@'localhost' for table 'student' CREATE TABLE STUDENT( ID INT PRIMARY KEY, SCORE INT ); INSERT INTO…
bigstreet
  • 1
  • 1
0
votes
2 answers

How can I use a value returned from one dataset to build a query for a different dataset, in SSRS?

I'm using SQL Server Report Builder 3.0 to create a report. I have two tables and I want to look up a value in one table and then use that to select a value from the second table. Example as follows: Table : Staff | staff_id | Surname | | -------- |…
Potatan
  • 13
  • 8
0
votes
0 answers

error 17054 severity 16 state 1 sql server 2014 enterprise edition

Our new database is just inaccessible. I have tried to find it in the error log and find this error during that time. So when we went to the Configuration manager. we were seeing Browser service, SQL Agent, and SQL Server services were stopped, and…
James
  • 1
  • 2
0
votes
3 answers

Mariadb legacy support

I have old version of php site, which uses unescaped 'row_number' column number in its sql queries. It seems in the new version of mariadb there has been new function called "row_number()" added and thus the queries fail. To refactor the whole…
tach
  • 131
  • 3
0
votes
1 answer

Why my simple searching query is too slow?

I don't know why searching in my "cities" table is so slow. My query looking for a table "cities" located about 25km from the city. I use this simple query and the database takes almost 20 seconds to return results. SELECT city_destination,distance…
Sahasrar
  • 3
  • 1
  • 3
0
votes
0 answers

Can't install/uninstall SQL Server

When I try to install SQL Server Express I got this error Unable to install SQL Server (setup.exe) Then I'm trying to uninstall everything related to the SQL server to avoid previous installation files, but I can't delete 1 folder (see image…
AGK
  • 101
  • 1
0
votes
1 answer

Adding a security certificate to a remote sql server

I'm in the process of trying to add a security certificate to a sql server running on a remote machine. I managed to generate the cert, but I'm a bit lost on the next step. All the instructions I have found assume local access to the machine running…
pbuchheit
  • 151
  • 2
  • 11
0
votes
1 answer

Can I move my encryption key (used for SQL always encrypted) from a key vault in one Azure tenant to another?

We have migrated a database (backup to .bacpac and restore to the new tenant) but the database was encrypted using always encrypted and the key is stored in the original tenant's key vault. I can look at the data in SQL management studio by…
R2Bleep2
  • 29
  • 1
  • 6
0
votes
1 answer

I have a sql server with a pictures table with 25 million entries and it has become too slow to query. currently have a xeon E5-2667v3 with 32g of ram

I have a sql server with a pictures table with 25 million entries and it has become too slow to query i currently have a Xeon E5-2667v3 with 32g of ram, I am looking to get a hp ProLiant Gen 9 and I am not sure how to go with specs, is SQL single or…
HadiB
  • 9
  • 1
0
votes
1 answer

Can I use 1 Shared Storage for Multiple Windows 2003 Clusters?

My Environment: Dell PowerVault 220S connected via SCSI to 2 Dell Poweredge 2950s. I have installed ESX 4i on each of the 2950s, and do NOT have VCenter. I will be using Windows Server 2003 Datacenter on each server for 3 installs, a SQLDEV,…
Werewolf
  • 3
  • 2
1 2 3
…
85 86