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

SSRS Report fails with conversion error but runs fine in ssms?

I have an issue with a report that was written before my time (I warn you it's got a lot of code and the error makes no sense). Basically its a stored procedure that creates a table variable and then ...
0
votes
2answers
69 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
1answer
565 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
41 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. ...
3
votes
1answer
204 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
1answer
41 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
83 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
52 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 ...
0
votes
1answer
224 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
45 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 ...
1
vote
1answer
76 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
1answer
25 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 ...
4
votes
0answers
152 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
1answer
656 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
105 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 ...
3
votes
2answers
2k 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
384 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
54 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
442 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
3answers
6k 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
3k 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
1answer
98 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
1answer
69 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
997 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
390 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 ...
2
votes
2answers
12k 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
48 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 ...
1
vote
0answers
112 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
65 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
633 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
640 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 ...
3
votes
1answer
350 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?
1
vote
0answers
2k 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
846 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
155 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
99 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
64 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
791 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
2k 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
4k 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
243 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
137 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
339 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
33 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
319 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" ...
0
votes
2answers
494 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 ...
2
votes
0answers
407 views

Understanding & Resolving Web Server Exploits

We recently had someone contact our company pointing out that we had numerous security threats that could be used to exploit our systems. They were nice enough to provide a list of these to which we ...
3
votes
1answer
33 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
1answer
31 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 ...
-2
votes
1answer
111 views

Multiple attacks - what can I do

I experience multiple attacks on my server recently (for past several days). Types of these attacks are e.g.: Several SQL Injection methods (select/union/where/null, etc.) Brute force attacks (e.g. ...