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
3
votes
2 answers

How to delete a record when two tables have foreign key referenced to each other?

Delete any record of them will report an error like this: ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails How to overcome this problem?
vps
  • 1,227
  • 3
  • 13
  • 14
3
votes
2 answers

Mirroring database in sql server 2008

When pricipal database is having less changes than mirror database i.e mirror_failover_lsn is greater than mirror_end_of_log_lsn of principal server, the mirroring session got suspended nad couldn't get resumed. Why so? . Now how can I restore my…
user23996
  • 191
  • 1
  • 2
  • 4
3
votes
3 answers

SQL Server problem with restoring big databases

I often need to to backup and restore database(SQL Server 2000/2005). Now if database is of size > 1 GB restoration process is real time consuming. Is there any way using which i can truncate the logs or reduce the database size? Thanks all,
Anil Namde
  • 145
  • 3
3
votes
1 answer

How do a get a connection string that uses windows authenication to work without windows authenication?

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDBName;Data Source=MyServerName this is the connection string, it can not be changed, it is in a dll from the dark ages. we are having to use it on a server…
KellCOMnet
  • 245
  • 2
  • 11
3
votes
0 answers

Azure SQL bacpac import job stuck - timeout on it?

Got some issues with a stuck azure sql bacpac import preventing me from importing the bacpac again to the database with the same name. The file is being pulled in from an Azure storage account. I was importing a bacpac file (575mb) of a database…
John Fox
  • 310
  • 4
  • 15
2
votes
3 answers

SQL CE thread unsafe - alternatives?

I have discovered that SQL CE is not thread safe: SQL CE objects are not thread-safe and are not thread affinitive either. If an instance of SqlCeConnection or SqlCeTransaction is shared across threads without ensuring thread safety, then that may…
Tomas
2
votes
2 answers

Automaticaly restoring SQL replication after power outage

I have two Sql databases, "MASTER" and "SLAVE", and I use Sql replication to get them synchronized. I'm using MariaDB 10 on both databases. The MASTER database is installed on a linux PLC using Docker. The SLAVE is on a NAS server, using Docker…
user3575838
  • 23
  • 3
2
votes
3 answers

IIS7 ASP - Provider cannot be found. It may not be properly installed

Getting a strange error for an old site I am trying to move to a new server - The new server is Win2008 64bit with IIS7. This site is working perfectly on an IIS6 Win2003 server, but I have just moved it over and run the site but I get the following…
YodasMyDad
  • 329
  • 6
  • 14
2
votes
1 answer

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 the server is really slow (on ssh top, mysqld…
anto
  • 21
  • 1
  • 2
2
votes
1 answer

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 traffic, but when I disable TLS 1.0, the app breaks. It…
user1030135
  • 31
  • 4
2
votes
1 answer

SQL SVR 2016 - Relocating system databases to different drive (Invalid directory error Msg 5121)

I have a fresh install of SQL Server 2016 which i'm trying to relocate the system databases onto a different drive on the machine Drive:D I've ran the following commands but keep getting the same error. The only issue I can think of is the file…
UserSN
  • 159
  • 3
  • 17
2
votes
5 answers

Copy data from Access to SQL

I have a an access DB that is to be eventually be replaced by a SQL DB with a web front end. The web application is currently in development. I have copied the Access DB to SQL using the Migration Assistant, unfortunately we can't just link the…
Sam Cogan
  • 38,736
  • 6
  • 78
  • 114
2
votes
0 answers

SQL Mirgations - Domain Trusts or not to Trust?

I am about to migrate something like 18 SQL servers into AWS from an on prem\colo. We will be building a new Domain in AWS and would like to leave the old domains behind. Do I need to setup a domain trust in order for my SQL servers to have no…
Someguyidk
  • 21
  • 1
2
votes
1 answer

SSL Security error with SQL Server 2016 sp1

I'm running SQL Server 2016 sp1 on a Windows Server 2012 r2 box. Supposedly, unlike earlier versions of SQL Server, SQL Server 2016 is compatible with TLS 1.2 right out of the box.... Right? Anyway, everything in my application works fine until I…
Michael Barber
  • 165
  • 2
  • 3
  • 10
2
votes
0 answers

Blocking urlencoded SQL injection with nginx

I inherited an Nginx setup in front of an Apache server. Today I found some SQL code hitting the apache access logs: GET…
Server Fault
  • 3,714
  • 12
  • 54
  • 89
1 2 3
…
85 86