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
24 views

MySQL unable to repair, dump, upgrade table (simply crashes)

I need to backup one of my databases from MySQL (Running MariaDB). The issue is that aside from all of my other databases that backup perfectly fine, this database has issues backing up and crashes ...
3
votes
1answer
55 views

Find Full or Differential backup from .bak (with powershell or by any other means)

I'm trying to determine whether an MS SQL backup file (.bak) is Full or Differential. Is there an easy way to do this? A way of doing this in powershell?
22
votes
2answers
33k views

Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?

I'm trying to grant all privileges on all tables of a given database to a new postgres user (not the owner). It seems that GRANT ALL PRIVILEGES ON DATABASE my_db TO new_user; does not do that. After ...
0
votes
1answer
822 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 ...
-1
votes
1answer
1k views

SQL Server 2008 setup error Attempted to perform an unauthorized operation

I am trying to install SQL Server 2008 Standard Edition on windows 7 and during installation it give error: Attempted to perform an unauthorized operation
0
votes
0answers
30 views

SQL Listener on Azure can't connect

I'm having an issue trying to create an SQL listener on a VM hosted in Azure. I have followed the instructions from MS on this link and everything seemed to go through fine. The listener created ...
0
votes
0answers
4 views

hide system databases sql server management studio [migrated]

I have installed sql server express 2008 and also sql server management studio. I've successfully configured remote connectivity and created a database user and password. my problem is that in the ...
2
votes
1answer
955 views

SQL Server: How to report error from a job's step of PowerShell type

I have a SQL job whose step of 'PowerShell' type does 'exit 1' if encounters an error i.e. $ErrorActionPreference='stop'; trap{"$_"; exit 1} Problem is, SQL Server doesn't pay attention to that exit ...
-2
votes
1answer
184 views

SQL server slows down

We have a java application running on Tomcat and we are using SQL 2008 and 2005 as database. Our databases sometimes slows down really significantly and we don't see any blocking, deadlock, etc. I ...
-1
votes
0answers
14 views

using update query with subquery in Oracle sql [migrated]

I have an update query where I am trying to update a field but for more than one record, I am trying a join but it doesn't work. Below I get multiple values that come back from the select statement ...
0
votes
2answers
1k views

MySQL database really slow with a really big table [closed]

I have a MySQL table with 150 million rows. Below is its data structure. Below is some of its data. Now, using PHP My Admin I ran the below command. SELECT `iwords` FROM `wordstable` WHERE ...
1
vote
2answers
58 views

SQL Management Studio Can't Connect to Database---Microsoft fixes failed

I just installed MS SQL Server 2014 a couple days ago and it was working fine until today. I attempted to connect using the Object Viewer and I got the error message Cannot Connect to MyserverName. ...
0
votes
1answer
25 views

prevent replace sql database files with old one

i have a database that i use in my application. the operation i want to prevent is if i stop sql server and take the database files to another location then start the sql server and make some ...
0
votes
1answer
2k 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 ...
0
votes
0answers
12 views

No messages received on Queue after Failover in SQL Always On

We have an Application, which uses Service Broker to receive notifications from the SQL Server. The application works fine when we don’t have SQL Always On enabled, and when we are interacting with a ...
0
votes
1answer
847 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. ...
2
votes
1answer
348 views

SQL server intermittent connectivity issue every 4 or 5 days

I have a .net web application that calls sql server 2008 running on a different server. From last couple of weeks, after every 4 or 5 days, web applications connectivity to sql server becomes an ...
5
votes
3answers
6k views

mdf file cannot be overwritten when restoring a database in SQL Server

I got a databse A. It has some data in it. I created a backup for A as A.bak file. Then I create a new empty database B. And then I try to restore B from A.bak. But the SQL Serve tell me the following ...
0
votes
0answers
16 views

SQL Server Witness Server Alternative Approach

I have the setup below: 3 Database Servers 1 DR Database Server 1 Domain Controller 1 DR Domain Controller Currently I have the DR domain controller acting as the mirroring witness for the 3 ...
0
votes
0answers
25 views

Sql 2008 r2 wildcard certificate

I have installed wildcard certificate in Certificates(Local Computer)\Personal in sql server. We are using Windows 2008R2 server and 2008 R2 SQL. Certificate is issued by StartCom. With certificate ...
0
votes
1answer
41 views

How to increase performance on ASP.NET/IIS/SQL website

We have a small internal ASP.NET website running on IIS8 and SQL2014 express. The server is an onsite dedicated server 2012 R2 VM that has both IIS and SQL server on it. The server CPU usage rarely ...
0
votes
0answers
29 views

Can't connect our ERP Database to MSSQL Server 2005

We have a Windows Server 2003 R2 using SQL Server 2005 Within the server are Two Lan Workgroup (IP Add 192.168.1.33 and 192.168.2.33) Neither IP has a problem connecting to the Server, their ping is ...
1
vote
5answers
7k views

Remote connection sql server not working but if firewall disabled it does?

I have setup sql server express 2008 on a windows 2008 server. And i have done all the standard stuff in sql to allow remote connections. The strange thing is if i disable the windows 2008 server ...
1
vote
1answer
777 views

SQL Server: “This filegroup cannot be used as a backup destination” error when attempting restore

When running a command like the following: "RESTORE FILELISTONLY FROM DISK='\\\\server\\folder\\DummyDB.bak'" I'm getting this error: Backup destination "\\server" supports a FILESTREAM filegroup. ...
0
votes
0answers
33 views

First steps in distributed cache and application

Background: We provide a client with a single server to which we provide a data dashboard site (ASP.NET/IIS7) feeding multiple MSSQL databases (OS: Windows Server 2012 / SQL: MSSQL 2008R2). One of the ...
1
vote
0answers
202 views

The target principal name is incorrect. Cannot generate SSPI context

One of our applications (Running on Server 2008 R2) uses a domain service account to connect to our SQL 2005 database (also running on Server 2008 R2). On occasion, when the application attempts to ...
19
votes
6answers
35k views

GRANT SELECT to all tables in postgresql

Is there a one-liner that grants the SELECT permissions to a new user postgresql? Something that would implement the following pseudo-code: GRANT SELECT ON TABLE * TO my_new_user;
0
votes
1answer
124 views

Elasticsearch River JDBC - Avoiding 'SELECT *'

I'd like to syncronize some MySQL tables to an ElasticSearch index, you know, for search. But almost every examples I can find show a big bad fat "SELECT * FROM", it's OK for an example, but I'm in ...
0
votes
1answer
44 views

MySQL user:pass in roundcube php config

Is it considered bad practice to have a MySQL query with user:pass as plaintext? I'm doing this right now (in nginx/roundcube to modify my dovecot passwords) but it seems strange because if I had ...
2
votes
1answer
55 views

Placement of OS and SQL files

we are in process of setting up our SQL server which is clustered across 2 HP DL380p servers using a HP P2000 for the shared storage with 2 raid 10 (8 disks) arrays and raid 1 mirror (2 disks). We ...
6
votes
7answers
4k views

DHCP server with database backend

I have been looking around for something to replace my (ancient) ISC-DHCPd server. A DHCP server with a database backend sounds like a great idea to me, as I could then have a nice, friendly web ...
1
vote
5answers
760 views

What is the best option to set up a quick and easy-to-manage database for my small office?

First, please be aware I am definitely a beginner when it comes to server maintenance or network administration. That being said, if I am asking this question in the wrong forum, please feel free to ...
1
vote
1answer
219 views

How to generate test data from an sql query and a result set?

I am using an oracle database and want to generate test data from a live database, but I do not want to copy the whole database content. Given a database DB(S, D) consisting of the database schema S ...
0
votes
0answers
17 views

denydatawriter role on Azure SQL

I'm trying to create a read-only user on an Azure sql instance. I've got the login and the user, and I execute the sp_addrolemember procedure which should set the db_denydatawriter role for the login ...
4
votes
1answer
5k views

Converting Filemaker to SQL or another database system

Currently at work we have a Filemaker database running on Filemaker Server 7 on a Windows Small Business Server 2003. I would like to change from using Filemaker to a different database, one with a ...
0
votes
1answer
210 views

Powershell execution policy within SQL Server

Can anyone help? Firstly I apologise if this is the wrong forum and for the amount of text you have to read. I'm not allowed to post images yet and a picture is worth a thousand words..... When ...
0
votes
1answer
107 views

SQL Server 2012 Memory usage

Since i upgraded to SQL Server 2012 I've noticed that it almost doesn't consume any memory at all. Before when i used SQL Server 2008 R2 it used at least 2-4 GB of RAM and now it only used like 150 MB ...
0
votes
1answer
29 views

Execute Trigger as Login

Is it possible to impersonate a login when running a trigger? I able able to run execute as 'username' but not execute as login='username' I can usee execute as as such with EXECUTE AS login='smr' ...
0
votes
1answer
123 views

MySQL CREATE command denied to user

I have a script system that refuse to be installed because of error that breaks installation. I tryied to import the data by import the data via .sql file at phpmyadmin and it still cant import. ...
0
votes
2answers
423 views

Cannot connect to the server on Microsoft SQL Server Management Studio 2008

I am extremely new to Microsoft SQL Server. I know a good level of MySQL but now I'm wanting to extend my knowledge to SQL and I want to practice writing out queries on the SQL Server Management ...
0
votes
1answer
48 views

SQL Server 2012 Express - silent installation.

I am failing to silently install SQL Server 2012 Express (Advanced). I followed the guidance and this is my command: Setup.exe /q /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER ...
0
votes
1answer
45 views

Daily postgresql cron error log file

I am getting these emails daily: /etc/cron.daily/logrotate: error: error accessing /var/log/postgresql: No such file or directory error: postgresql-common:1 glob failed for /var/log/postgresql/.log ...
0
votes
1answer
52 views

How to view the SQL Server transaction log on AWS RDS?

Is it possible to see the T-SQL Query log in AWS RDS? is there a UI for that in the console, or i need to use the CLI or SQL Management Studio?
0
votes
2answers
23 views

How to view datetime when a SQL Server DB was created?

I need to see when a Database was created in SQL Server, and who created it if possible. Is there a command to get that data?
1
vote
1answer
47 views

Find out who installed SQL server - they forgot to add other logons

We have a site where one of our team of techies installed SQL Server 2012. They forgot to add our administrators group as sysadmins so only they can access SQL - everyone else gets "Access Denied" ...
-1
votes
1answer
60 views

SQL Server Express and SharePoint

We have a client that would like to use SQL Server Express with SharePoint instead of forking out a minimum or $7000 for SQL Standard. I know SQL Standard is the best option here, but the price tag is ...
0
votes
1answer
8 views

SQL Installation Error In Memory, Can i just add a database to an existing SQL Instance

We have an SBS running 4x SQL 2008R2 instances. i need another for the antispam product but the install fails with an error about possible corrupt memory. I've done some digging and re-installing all ...
3
votes
1answer
26 views

SQL Server 2005 global slowdown

Two days ago our production server suffered a massive slowdown where the primary symptom was that an extraordinarily high number of requests were suffering SQLTimeouts. I will quickly describe our ...
0
votes
0answers
15 views

Migrating from SQL 2008 to SQL 2012 but cannot connect to the database

We are now migrating from a SQL 2008 to a SQL 2012 server. I am testing the databases one at a time as these are live databases. I have backed the database up and then restored this onto the new ...
1
vote
1answer
752 views

When installing SQL Server, “Unhandled Exception: System.Security.SecurityException: Request failed.”

Brand new Windows Server 2008 R2 install handed over to us from Windows admin group. I try to run the SQL Server 2008 R2 install and get this error: Unhandled Exception: ...