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

Stop PostgreSQL from logging statements on error [migrated]

My postgresql 9.3 logs are sprinkled with entries like these (redacted to protect the guilty): STATEMENT: INSERT INTO table (key, value) VALUES ($1, $2) ERROR: duplicate key value violates unique ...
0
votes
2answers
28 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
0
votes
0answers
17 views

Clone database or copy data from RDS MSSQL DB to local database

Is there anyway I can clone an amazon RDS MSSQL DB to my ec2 instance local DB? And this has to be done through powershell also. Basically I need backup of RDS MSSQL DB in sql or bak extension, but ...
1
vote
0answers
19 views

X3250 Server: stuck at firmware screen

The server is initialize, then it is stuck at the IBM System X Server Firmware screen (before F1, F12 appears, etc). You can see in the attached image. ...
1
vote
1answer
33 views

SQL Server 2008 Restored Database allows differential backup when no full exists

I restored a backup file (it's used as a template for new databases) as a new database. Normally as part of this process, I take a full backup after the restore, but this time I was called away on ...
0
votes
0answers
9 views

Does SQL Azure Data Sync conflicts get logged?

I have successfully synced my SQL Azure DB with my on-premise DB. The log shows the following: Sync completed successfully in 1884.76 seconds. Upload: 405323 changes applied Download: 0 ...
-2
votes
1answer
30 views

sql server: best practice for log backup in full recovery mode [closed]

I have a development sql 2014 environment. I need to put all db in full recovery mode in order to test availability groups, so I need to manage logs to avoid excessive growth. I don't need to keep log ...
0
votes
0answers
15 views

MSSQL 2005 - Server Service unable to start while installing

I am trying to install MSSQL 2005 Express on an VM running Windows Server 2012. I get to the point where it installs everything but fails to start the service. I have tried checking the Log-On ...
-1
votes
0answers
21 views

1xRAID 10 or 2xRAID 1 ~ SSD

I'm currently upgrading my current game server for a better redundancy. Current setup: 1x 256GB SDD (OS / Logs) and 2x 256GB (RAID 1) for (data / tempdb) as you see there is no redundancy for the the ...
0
votes
1answer
20 views

SQL Server - Cant connect to instance with either windows auth or SA account

I have just installed SQL Server 2012 and I cannot connect to the new instance using any method. The instance is MSSQLServer I have attempted \MSSQLSERVER, .\MSSQLSERVER, localhost\MSSQLSERVER and ...
0
votes
1answer
17 views

Can SQL Server 2008 R2 be used to allocate resources by specific program?

Recently, I have come into a scenario where I have been brought in to help manage a hosted system where we host our own product for our customer. Each customer is given a unique user to a specific ...
0
votes
0answers
38 views

SQL Server Job Database name [migrated]

First time post, long time lurker. I am trying to find and write a query for what database is affected by a SQL Server job. I have checked the following: Get a list of SQL Server Agent Jobs and ...
1
vote
1answer
50 views

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of ...
0
votes
0answers
5 views

SQL alwaysON and WSFC

I have a WSFC configured on 2 (hardware)nodes with SQL AlwaysOn group. The problem is, if the node Where I have created the cluster goes down the cluster is not available for second node and here ...
0
votes
0answers
9 views

How to execute cursor in PostgreSQL? [migrated]

This is my program for cursor, but I am not getting how to execute the cursor on a database. emp=# CREATE or replace function cursor_demo() returns integer as $$ declare emp_rec employee%rowtype; ...
3
votes
0answers
31 views

Update SQL Service Pack Named Instance

I have an existing SQL 2008 R2 on SP3. Have another instance in use that is SQL 2008 R2 SP1 I need to update the named instance with sp1 to sp3 but i'm not getting any options. It tells me my version ...
0
votes
0answers
23 views

SQL 2014 Collation Policy job failing

I have setup a new SQL 2014 server and created a policy to make sure all DBs have the same collation. I created a DB names test and gave ##MS_PolicyTsqlExecutionLogin## permission to it and all ...
0
votes
1answer
45 views

How to attach a database created by sql 2008 to sql 2012 when full text catalog missing? [closed]

I have an already created mdf file which was created by sql server 2008.But when I attach this mdf file to sql server 2012 it asks me to add necessary full text catalogs. I have no idea what to ...
0
votes
1answer
26 views

Concurrent MySQL processes

I have a file, let's call it a.php, which executes a long cycle of iterations, each one of them makes some queries to the database. To complete the cycle, it takes quite some time (some hours). My ...
1
vote
2answers
68 views

how to separate IIS event logs by application in event viewer

Just to start with, I would like to advise I am VERY new to IIS so apologies for any obvious questions in advance. I have done some research around this topic and my findings have been inconclusive. ...
2
votes
1answer
52 views

How can postfix hash: databases be replaced by static: or inline:?

What is the syntax to replace a postfix hash-Database, for example domain.tld PREPEND my-header: foobar with a static map? docs define it as Example: "inline:{ key=value, { key = text with ...
2
votes
1answer
38 views

What are the downsides of running all SQL Servers under same domain account?

I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers ...
0
votes
1answer
52 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
35 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 ...
-1
votes
1answer
328 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
1answer
98 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 ...
0
votes
0answers
17 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 ...
-1
votes
1answer
37 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
34 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
1answer
66 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 ...
0
votes
0answers
160 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 ...
1
vote
2answers
1k 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
30 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
31 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
0answers
33 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
1answer
97 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
2answers
157 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
39 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 ...
3
votes
1answer
138 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?
0
votes
0answers
58 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
674 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 ...
0
votes
1answer
373 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 ...
2
votes
1answer
73 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 ...
0
votes
1answer
65 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 ...
0
votes
0answers
25 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 ...
0
votes
1answer
647 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 ...
-2
votes
1answer
43 views

TCP ports duplication [closed]

I need to communicate server1 to server2. Server1 should have to fetch some records from Server2 when we execute program.exe will make server1 to fetch server2 When I gave netstat -an | find ...
1
vote
1answer
96 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
424 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
2k 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 ...