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
1answer
15 views

Is there a way to kill a range of session ids (connections) in ms sql server?

i was wondering if there is a way to kill a range of SQL Connections on an Microsoft SQL DB. If i want to kill a single session id i can use kill [session-id]; go;. If i want to kill all sessions i ...
0
votes
0answers
11 views

Cisco CallManager AXL SQL Toolkit - Retrieve directory number and user ID

I have the below SQL query to retrieve the list of userid and their telephonenumber using Cisco CallManager AXL SQL Toolkit: sql query="select d.name as deviceName, e.userid, e.telephonenumber from ...
2
votes
2answers
2k views

Determine Who Dropped a Database?

I have a SQL Server 2005 database that has been deleted, and I need to discover who deleted it. Is there a way of obtaining this user name?
0
votes
0answers
7 views

How to modify the below script to take tables and its sizes for a particular databse to send via mail to a recipient? [migrated]

SELECT top 10 t.NAME AS TableName, (SUM(a.total_pages) * 8)/1024.0/1024.0 AS TotalSpaceGB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN ...
0
votes
1answer
36 views

Restore SQL Database From BAK File using a SQL Query

I have my database backing up to the hard disk in the format of BAK file. I am trying to restore that backup, but I unable to do so. Here is my query: ALTER DATABASE DBASE SET SINGLE_USER WITH ...
0
votes
0answers
15 views

Importing Data Dump Using pgAdmin

I looked around and found the following code on how to import a data dump using pgadmin: CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$ tables RECORD; gmdeclare statement ...
-1
votes
0answers
16 views

Develop a SQL query for updating the DLL mapping via SQL scripting method [closed]

I would like to edit the DLL mapping for the databse after refresh,For editing the DLL mapping i am in need of SQL script to do it manually. Please help
-1
votes
0answers
11 views

SQL ssis delete imported rows from source table [migrated]

I have setup a simple SSIS package that copies data from a source table to a destination table which works. I would like to get the package to also delete the data in the source table that has been ...
0
votes
1answer
871 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 ...
0
votes
1answer
25 views

Azure Database Permissions

Is it possible to create a Server Login with a Master database user that is able to create a Server Login with a Master database user ? I have not been able to do this, I always need to use the Admin ...
4
votes
1answer
4k views

How can I verify that a SQLite db3 file is valid/consistent

I have some sqlite version3 db3 files I copied off a live running production system (I know bad sysadmin bad sysadmin) for various reasons. Is there some sqlite command I can run that will verify that ...
0
votes
0answers
8 views

SQL 2012 IPSec or SSL

I have a requirement to secure connections to SQL server. (at transit that is) - TDE will be used for encryption at rest. SQL provides two options which are either certificate based SSL or Windows ...
0
votes
2answers
756 views

Alias a linked Server in SQL server management studio?

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server? I have a server, added by IP address, to which I do not have the login ...
-1
votes
1answer
28 views

Unable to backup SQL database due to insufficient permissions

We are attempting to do an internal SQL backup of our databases, however it appears when the databases were configured the SA user account had been disabled. For whatever reason the BUILTIN\Users only ...
2
votes
0answers
19 views

backup compression ratio in SQL 2012 worse than in SQL 2008

We have SQL 2008 Enterprise with TDE enabled and upgraded to SQL 2012 with TDE still enabled. Everything works fine except that I am getting worse backup compression than in SQL 2008. I do ...
0
votes
0answers
3 views

How do I determine which tier of Azure Web Service my RESTful API requires? [duplicate]

My application's back end is a RESTful API which generally doesn't perform any logic, just basic CRUD on top of an SQL DB (I think I will use Azure SQL Database Service). Assuming you are given ...
-1
votes
0answers
7 views

difference between server times [migrated]

I am trying to create an integrity check to tell me when my two servers are more than 5 seconds apart in time. I have two servers HP1 is the server I am running this from HP2 is the remote server ...
-1
votes
0answers
11 views

How can I calculate the hardware I need for a WAMP server? [duplicate]

Hello I need to find a way to calculate what kind of hardware I need to run a WAMP server that will host a SMF forum and a wordpress blog. and expecting about 75 hits/day. What do i need to calculate ...
0
votes
1answer
325 views

Installing SQL Server on a Domain Controller [closed]

I want to install SQL Server on a Domain Controller ( windows server 2003 R2) but i have an error because SQL Server services can not run under a local service account or a network service account.
2
votes
5answers
1k views

Why does this SQL run so much faster in a Oracle server with the same hardware/data than another Oracle server?

My application has a SQL that takes ~ 30 min to run in the Oracle server in production. It takes about the same in a test Oracle server. For some reason, in another Oracle server, it runs much ...
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
1answer
910 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. ...
0
votes
0answers
72 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
71 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
34k 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 ...
-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
37 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 ...
2
votes
1answer
975 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
185 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 ...
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
161 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
26 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
0answers
17 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 ...
2
votes
1answer
392 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
7k 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
19 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
42 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
73 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
31 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
789 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
45 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
364 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 ...
21
votes
6answers
37k 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
209 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
51 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
63 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
5k 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
779 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
222 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 ...