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].

Filter by
Sorted by
Tagged with
0 votes
1 answer
82 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 ...
RamboFR05TY's user avatar
0 votes
0 answers
23 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 ...
Steve's user avatar
  • 1
-1 votes
1 answer
508 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: ...
dave's user avatar
  • 1
1 vote
0 answers
111 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 ...
Jason's user avatar
  • 58
0 votes
0 answers
62 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....
BobTheCat's user avatar
0 votes
1 answer
2k 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....
user239612's user avatar
-3 votes
1 answer
360 views

MySQL replication not working

I have been trying everything I could find and my servers are not replicating! Can someone look at my config files and offer some guidance? My,ini master on Windows: # Other default tuning values # ...
DMonty's user avatar
  • 1
0 votes
2 answers
2k views

SCCM report to count collection members is returning junk

I have written a report to give me the total member count on multiple collections at once. It executes, but when it does, only the first collection in the list returns its actual membership. The ...
Eric's user avatar
  • 3
2 votes
1 answer
4k views

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 ...
UserSN's user avatar
  • 159
1 vote
0 answers
456 views

Terraform SQL create users from variable

I was told this might be a better spot for my question: I have users defined in tfvars: test_database_users = ["td" , "tdus", "tdbusrs"] Resource is defined as: resource "template_dir" "...
LearningToCode's user avatar
0 votes
1 answer
719 views

How to run maintenance plan task on success of two other tasks

I need to run the maintenance plan task on success of two other tasks and only after those tasks have completed. At the moment task2 starts straight away after one of the other two completes and it's ...
attention's user avatar
1 vote
1 answer
2k views

SQL Server - Connect via SSMS works fine, but ODBC fails

I have a SQL 2016 Express instance, and I can connect to this fine using sqlsrv_connect() from within PHP. However, when I try to create a ODBC connection it fails. I get the error message "SQL Server ...
Phil's user avatar
  • 203
1 vote
1 answer
84 views

Home Postgress Server Configuration

I have postgresql server installed on my main computer (my desktop). I am working on a hobby project via node.js and sometimes would like to work from my laptop when i can not be at my desktop. How ...
pinz88's user avatar
  • 13
0 votes
1 answer
1k views

exporting with from MSSQL with BCP over Samba shared folder

I have a daily routine that runs over a SQL db and exports some data with BCP. I need to move these files to a Linux machine, so I shared the folder using Samba. The local export works fine, yet when ...
Mike's user avatar
  • 113
1 vote
1 answer
234 views

How to access a SQL Anywhere Server without a database to create one?

is it possible to connect to a SQL Anywhere Server without an existing database to create one. In SQL Anywhere Studio i always have to define an existing database. Regards Martin
Martin.Martinsson's user avatar
0 votes
1 answer
84 views

SQL 2008 Cluster Resource could not bring online

I had problem in SQL 2008 R2 cluster resources. When I check the event "An error occurred while processing the log for database 'model'. If possible, restore from backup. If a backup is not available,...
Abdul Majeed's user avatar
1 vote
1 answer
2k views

Setup SQL Transaction Log backup for every 30 mins [closed]

I know how to setup a one time sql transaction log backup from SSMS, but I could not find a very detailed steps for setup this transaction log backup for every 30 mins. How can I do this in SSMS? I ...
Root Loop's user avatar
  • 912
0 votes
1 answer
153 views

How to debug a SQL script containing INSERT statements with failing subqueries?

I have three tables in my database: tbl_object, tbl_tag adn tbl_object_tag_xref. tbl_object and tbl_tag only have the two columns id and name. tbl_object_tag_xref matches objects to tags and vice ...
Michael Palm's user avatar
0 votes
1 answer
88 views

Bulk Load with SQL Login - Credential no longer works

I built a Java plugin which runs a SQL script. This does a bulk load to read from xml files on a server, using a SQL login. To get it to work a SQL credential to a domain account was linked to that ...
Joshua J Geoghegan's user avatar
0 votes
1 answer
361 views

sccm 1702 sql server service running account

I am having an issue with the installation of SCCM 1702. When it runs it's pre-requisite check I get an error indicating the login account of the sql server is incorrect. It is specifically ...
Josh Kelahan's user avatar
1 vote
1 answer
1k views

SQL Server slow in guest machine over time (virtualization with KVM on a Centos 7 Host)

We have a new server a HP DL360, 64GB RAM, 2x8 core CPU, SAS HDD Raid1 array and one SSD Raid1 array. The SSD Array is configured with 2 Samsung 850 Pro devices (not HP certified). We installed a ...
Enovator's user avatar
0 votes
1 answer
1k views

AWS : Lag issues between RDS SQL Server over two regions

Data policies of our customers means we have to host our database in the UK / EU. We currently have an US West EC2 instance (Windows) running as a web server. But since adding the new London RDS (SQL ...
chris's user avatar
  • 113
0 votes
0 answers
167 views

Error moving Sql Server Azure between subscriptions

I’m trying to move a SQL Azure Server that has 2 databases from one subscription to another. The databases’ sizes are 10G and 1G. I’m using the azure portal to do it and I’m getting the following ...
Copeleto's user avatar
  • 113
2 votes
0 answers
53 views

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 ...
Someguyidk's user avatar
0 votes
2 answers
38 views

How I can get db's current restore mdoe status by query?

So, my db can be in three differrent statuses. RECOVERY NORECOVERY STANDBY And I want to know current db's status by query. Can you help me ? The single what I've found is SELECT is_in_standby ...
isxaker's user avatar
  • 101
2 votes
1 answer
8k views

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,...
Michael Barber's user avatar
-2 votes
1 answer
67 views

Is it possible to create a SQL script to copy a database from some remote server to local server, running script in local server? [closed]

I need copy database from some server to my local machine database. HOST REMOTE SQL SERVER (READ ONLY PERMISSIONS) ----- TO --- > MY LOCAL SERVER Thanks Advance
Nicolas Gliksberg's user avatar
2 votes
0 answers
2k views

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 /mgrayson/splice%27%29%20AND%20%28SELECT%204520%20FROM%28SELECT%20COUNT%28%2A%...
Server Fault's user avatar
  • 3,774
0 votes
1 answer
130 views

Does SQL licence expire for a single instance? [duplicate]

I have two instances of SQL server namely Adventure and instance 2. Now I cannot start SQL server from services for Adventure but the instance2 is fine. Once i go through the log file it showed SQL ...
Bodhi's user avatar
  • 143
0 votes
1 answer
359 views

Can postgres delete constraint affect performance when doing SELECT, not delete?

For example, if I set ON DELETE CASCADE, can it somehow affect performance outside delete command? Or will it only affect performance when deleting? And more importantly - if I set to do nothing on ...
Ronen Ness's user avatar
3 votes
1 answer
881 views

Prestashop + Google Cloud SQL

I am currently trying to setup a Prestashop 1.7 instance using Google Cloud Compute Engine and Google Cloud SQL (MySQL 5.7). I managed to get to the installation page of Prestashop, but when I try to ...
Thien42's user avatar
  • 31
3 votes
2 answers
9k views

Unable to Windows Update and WSUS broken

for a while now, despite working faultlessly for over 3 years, both WSUS and Windows Update have stopped working on our single domain contoller running Windows Server 2008 (not R2). The error we get ...
fRAiLtY-'s user avatar
0 votes
1 answer
531 views

Interpreting a Deadlock Log / XDL file

I've generated the following XML + XDL: <deadlock> <victim-list> <victimProcess id="processc1eaf13468" /> </victim-list> <process-list> <process id="...
SB2055's user avatar
  • 33
2 votes
2 answers
5k views

Is using MySQL Workbench over the Internet safe?

Let's say I have a server with an SQL Database somewhere on the other side of the planet. Is it safe to establish a connection over the Internet? e.g. with MySQL Workbench. I'm asking because I heard ...
technical_difficulty's user avatar
0 votes
2 answers
426 views

2 SQL Databases with crucial data

I have two databases with 45gb each with very crucial data. Now the sql is telling me that both are corrupted. My database is in emergency mode. What I can do to put it back online? And when I try ...
PalBodnar's user avatar
3 votes
2 answers
3k views

How to convert a MyISAM .sql dump into InnoDB?

Can I convert dumped .sql MyISAM database into InnoDB engine before importing it to my MySQL server? Unfortunately, importing the current .sql file takes ages to complete.
Jakub Pastuszuk's user avatar
0 votes
1 answer
80 views

Mongodb and SQL Server

Our db group is looking at placing our mongodb server instances on the same servers that host sql server. Our SQL foot print is fairly large with a good dozen dbs larger than 200gb in total space ...
Lance Lyons's user avatar
1 vote
1 answer
2k views

Foreign Key Constraint Error 1005 erno 121

I'm racking my brain trying to get this table created. Other tables create just fine in mariadb 10 with similar constraints. I've run it through debuggers with no success. ERROR 1005 (HY000) at line ...
user417568's user avatar
1 vote
0 answers
432 views

PHP Fatal error: Uncaught exception

AFter building and hosting one of my zend application website, few days after, when tring to load the website, it resolves: ' No such file or directory ' on the homepage. then i had to check up the ...
Tevis L's user avatar
  • 11
0 votes
0 answers
13 views

Trying to understand Microsoft SQL and Windows Server licensing [duplicate]

I'm trying to understand how many licenses I'm supposed to purchase and check if I have the correct amount of purchased licenses. I have Windows Servers & SQL Servers in virtual environment. From ...
Shlomi's user avatar
  • 331
0 votes
1 answer
263 views

Looking for SQL Server 2014 SP1 Build 12.0.4213.0

I'm trying to install a new SQL Server 2014 instance, on a new machine, with this version: SQL Server 2014 SP1 Build 12.0.4213.0 I have it installed on one of my machines, but I have no clue how to ...
Shlomi's user avatar
  • 331
0 votes
1 answer
213 views

MySQL account has password, but only logs in without it

I am running Windows Server 2012 R2 trying to host a Drupal site. Because it is Drupal, I am trying to connect to a MySQL server rather than a MSSQL server. I created a new schema as well as a new ...
Blake Morgan's user avatar
1 vote
2 answers
136 views

Move MSSQL Server to another Server

So I'm about to move a MSSQL Server to another better hardware server. I need to make sure I'm moving everything. I made a small list of what I think I need to move: Databases (ofcourse :)) MSSQL ...
Shlomi's user avatar
  • 331
0 votes
3 answers
3k views

MariaDB Refusing remote connections

I've gone through a lot of tutorials and questions and I still can't get it to work. I've used the following great example: MariaDB refuses remote connections But still no luck connecting... But ...
Bananenbaas's user avatar
1 vote
1 answer
185 views

SharePoint SQL DB is nearly 50 GB. Cannot shrink due to lost/expired SA password

Back in June of last year I posted about how our old SharePoint '07 database has grown exorbitantly large. The problem is that C:\ and E:\ are on a single VMDK and the C:\ parition is nearly out of ...
KidACrimson's user avatar
0 votes
1 answer
696 views

Login failed for user '401hk'. Reason: Could not find a login matching the name provided. [CLIENT: 220.180.111.229]

We have a Microsoft Azure virtual instance and over there we have installed the SQL Server 2014 Express edition. While investigating a issue we found below logs in windows event viewer in application ...
Swapnil Sonawane's user avatar
0 votes
1 answer
213 views

Move SQL Indexes in bulk

Let me start off by saying I am not a SQL guru, I know just enough to get into trouble with it :) We just migrated a client over from SQL 2008 R2 to SQL 2016 on new hardware and we want to move the ...
msindle's user avatar
  • 605
0 votes
0 answers
88 views

How to connect Google VM Instance to Google SQL Instance and use it both to run Wordpress

Dears, Its been 2-3 weeks since I've started learning how to host my websites on Google VM instance, I've installed Vesta Cpanel and it will install PHP, apache, MySQL, PHPMyAdmin .. etc all the ...
user avatar
1 vote
0 answers
619 views

For SQL server with one User CAL, can one user be logged in concurrently from multiple devices?

So basically our client had no idea what they were doing when licensing SQL Server, and ended up only purchasing one User CAL. What I'm wondering is, can that same User CAL be used across multiple ...
Nerdrave87's user avatar
1 vote
1 answer
19k views

How to check buffer pool size in sql server?

Is there any way to find total allocated buffer pool size in sql server.In mysql we can find it by using the variable innodb_buffer_pool_size.Is there any equivalent for that in sql server?
SujithTee's user avatar

1 2 3
4
5
26