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

OpenLDAP SQL backend failing

I'm running OpenLDAP with a SQL (Oracle) backend. This works fine with OpenLDAP 2.3 but after upgrading to 2.4.38 it fails with an error that is not helpful at all: 52d3ec0c ...
0
votes
0answers
143 views

Disabling locked page allocations in SQL Server 2012

Locked page allocations are enabled in my instance of SQL server 2012 even though I have no accounts with the "lock pages in memory" user right. This article by Microsoft - ...
0
votes
1answer
49 views

Cannot create MS MDT Database on SQL 2012 Express

I am trying to create a new SQL Server 2012 Express database via MDT 2013. When I did that I got the error above. I have completely rebuilt the server yet this error persists. Now when right-click on ...
0
votes
2answers
778 views

Offline database can't be restored: Exclusive access could not be obtained

I'm practicing a SharePoint 2010 to 2013 migration and having trouble restoring a database. After backing up a database on a SP2010/SQL 2008 server, I'm trying to restore it to a database I've freshly ...
1
vote
1answer
24 views

SQL Server 2008 - Difference between server and database permissions

And I think I'm almost there conceptually. I think I just need a few example/confirmations to bring it home. 1) My understanding is that server permissions ...
2
votes
1answer
83 views

SQL Named Pipes across Site to Site VPN

Running into SQL issues and I can find the exact problem already posted here on SF. I have a SQL server running on a 192.168.16.x subnet on one side of a site to site VPN. I have a workstation on a ...
0
votes
0answers
33 views

SQL Server : Improve SIMPLE SELECT to retun 2 LAC Rows faster?

We have a stored procedure in which we are creating a temp table which has more than 200,000 rows with 30 columns (2 of DATETIME, 4 of INT, 5 of [numeric](20, 3) and rest of VARCHAR(500) data types. ...
1
vote
1answer
128 views

SQL error log can't create/write to file

I'm quite new to server administration but a keen learner, so if I miss anything or you need any extra info let me know and I'll do my best to provide it ASAP :) I'm running WordPress on a developer ...
1
vote
1answer
33 views

SQL: name without a login name

I have noticed that when I open SQL server enterprise manager and I navigate to the list of users under a specific DB, I found users with"Name" but some have no "Login Name" value. What does this ...
1
vote
1answer
53 views

Does converting a disk from basic to dynamic require a reboot?

I'm finding conflicting info on converting a disk from basic to dynamic and have a few questions. Will it require a reboot? The server with the disk in question is hosting SQL Server 2008 R2, and ...
0
votes
1answer
92 views

IIS logparser - Count distinct from cs-uri-query?

I need to count how many DIFFERENT MAC´s that have accessed my IIS webserver and have a state value of 1. The "MAC" adress and the "state" value are in the actual query (cs-uri-query) So the log can ...
0
votes
1answer
460 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. ...
1
vote
1answer
284 views

DBLIB PDO driver keeps failing when trying to connect/query Microsoft Azure SQL database

So I'm using Linux (ubuntu) and I'm trying to connect to a Microsoft Azure SQL database. Server information: The server address is a1a1a1a1a1.database.windows.net (a1a1a1a1a1 is a placeholder for ...
0
votes
2answers
51 views

Ubuntu 10.04 database connection problems

I'm having some problems with a legacy program I'm starting back up. We had an image of this server, and the setup is Ubuntu 10.04, 5gb partition for mysql database, and 100gb filesystem. My issue ...
1
vote
1answer
36 views

Protecting SQL from Profiling

We have some sensitive IPR in some Stored Procedures. We encrypt the stored procedures. However, at the point they are created, they are plain text. Is there anyway we can prevent SQL Server Profiler ...
1
vote
1answer
24 views

create a view to show the backup status in every 10 mins

I have a question, my table have following data: userID, startTime, EndTime ————————————— 101, 04/11/2013 11:00:00, 04/11/2013 11:55:00 102, 04/11/2013 11:00:00, 04/11/2013 11:24:00 103, 04/11/2013 ...
0
votes
3answers
196 views

Server periodically freezing - Help Stabilizing [closed]

We run an asp.net/sql server data collection website with a hand full of clients dumping data in and running reports. We moved to a new server (specs below) and have had issues with it freezing and ...
0
votes
0answers
55 views

MySQL: copy column error: “Unknown column 'dbname.tablename.columnA' in 'field list'”

Wanting to copy the contents of one column in a table from one db to another db I found an answer on S.O. here; the second answer by slaakso (I didn't understand how to use the first answer) When I ...
0
votes
1answer
61 views

MySQL reclaim index space after large delete?

After performing a large delete in MySQL, I understand you need to run a NULL ALTER to reclaim disk space, is this also true for reclaiming index space? We have tables using > 10G of index space and ...
-1
votes
1answer
32 views

need help scripting website reboot

I have a small website that crashes once or twice a week. I have spoken to both the websites original designers, who has now retired and its host and both blame the other. The website can be ...
3
votes
1answer
66 views

How to create SQL account that can only perform certain actions?

I'm used to working on contracts where someone else is responsible for the SQL database. However, I'm now working a contract where I must set up a new SQL Server, so I set up MS SQL Server 2012 ...
0
votes
1answer
1k views

Telnet 1433 on SQL Server Failing

I work with a number of SQL servers. Some are clusters and some are standalone. Some of the standalone servers run multiple instances and some do not. What I've found is that any SQL server I have ...
0
votes
0answers
489 views

SQL PowerShell Snapin Problems

I am hoping this is an easy fix and oversight on my part. I need to be able to run the SQL cmdlets from remote machines. I have installed Microsoft® Windows PowerShell Extensions for SQL Server® 2008 ...
0
votes
1answer
130 views

SQL 2008 R2 User Connections and Total Server Memory counters spike at the same time on multiple servers

We use SolarWinds SAM software to monitor servers and applications. We started using it to monitor our SQL servers through the performance counters. We started getting alerts two to three times ...
1
vote
1answer
228 views

Why I can't execute SQL query on Amazon Redshift from VPC private instance?

I have an instance in a private subnet in an Amazon VPC. This instance uses a NAT to access the Internet. I use the Redshift JDBC driver to connect to a cluster hosted in the same region as my VPC ...
3
votes
1answer
233 views

Windows Server 2012 Forest and Domain functional levels compatibility

I'm using a Windows 2003 domain, and a currently planning for a Windows Server 2012 upgrade, so I'm looking at all software which could be hurted by a Domain (and Forest) functional level raise to ...
-1
votes
1answer
44 views

Guide to choose which is the best for VM - microsoft or vmware [closed]

i am confused between VM Ware and Microsoft Hyper V whic one is the best in terms of all. is there any comparison chart then please let me know. as to run os in vmware need to install esxi; it is ...
1
vote
1answer
36 views

Terminal Server trying to connect to 1433/tcp on client

We are facing a strange issue here. Everytime a user connects via RDP client to one of our terminal server, the server itself tries to establish a connection via 1433/tcp to the client (and even ...
1
vote
1answer
456 views

dbcc checkdb('XYZ', REPAIR_ALLOW_DATA_LOSS) indicating that XYZ is already open and can only have one user at a time

I have a DB, XYZ, that had a corrupt log file and now since the log file is totally unusable this is rendering this specific DB unusable and I need to be able to rebuild it. I've already done a lot ...
0
votes
2answers
92 views

Why is SQL Server IO so much slower than the disk capacity?

I'm running SQL Server 2012, and doing a simple SELECT * query, I can see that my disk IO in performance monitor is < 10MB/s. If I do a backup of the database, however, I see values > 200 MB/s. ...
0
votes
1answer
18 views

SQl Server not connecting

I am using visual studio 2012 and SQL Server 2008 R2... My Connection String is Data Source=MCPL-PRINT-PC\SCMSQLSERVER;Network Library=DBMSSOCN;Initial Catalog=SCM_DB;Integrated Security=True Now i ...
-2
votes
1answer
47 views

Is is safe to upgrade SQL server 2008

I have a windows vps with sql2008 express r2 (with tools) installed, one of my clients require full-text search feature. Sql 2008 with advance services has that feature. So my question is, is it ...
0
votes
2answers
142 views

Keep Getting an Error When Running My SQL Code

I keep receiving the dreaded "An expression of non-boolean type specified in a context where a condition is expected." errorr at the bolded "dbo.v_R_System.ResourceID" in the code below in the "From' ...
0
votes
2answers
79 views

How to allow domain groups access to SQL server?

I'm sure this is a simple problem, bu I've looked for days... I have a SQL server that is part of a domain. The domain has many many users. I want to allow select permissions to anyone within a ...
0
votes
0answers
108 views

Connection Timeout Expired

Message:Connection Timeout Expired. The timeout period elapsed during the post-login phase. The connection could have timed out while waiting for server to complete the login process and ...
0
votes
1answer
48 views

SQL Server normalizing for performance

I have a table create table Objects ( ObjectID bigint not null primary key, ObjectRef1 varchar(50) not null, ObjectRef2 varchar(50) not null, ObjectRef3 varchar(250) not null ) All ...
-1
votes
1answer
44 views

SQL Server 2008 R2 memory consumption for no usage [closed]

I have a application that uses SQL Server 2008 R2. I have a problem of memory consumption on the client side. Whenever the client runs the application, the SQL server starts consuming memory even if ...
0
votes
1answer
755 views

How do I grant select, insert privileges in Postgres on Cygwin?

How do I grant permissions in Postgres? I followed the documentation, however it is not working. $ psql tmadev psql (9.2.4) Type "help" for help. tmadev=# grant all privileges on database tmadev to ...
1
vote
3answers
119 views

MySQL high cpu load slow quries being logged need help to understand

I'm trying to troubleshoot a high load problem on a server, Today for some reason MySQL is taking up excessive CPU time. I have enabled slow-queries and found this query and others similar. The ...
0
votes
1answer
81 views

Which Database (SQL/NoSQL) is the best fit? [closed]

I have 2 nodes, one gateway and one worker. Data must be passed from gateway to worker (without direct connection). I would like to store a Key into a database identified with an ID and a Time To ...
0
votes
1answer
58 views

RDP Access in Windows Server 2012 [closed]

Is it possible to restrict RDP access the SQL server to be only from the Terminal Services server
1
vote
3answers
57 views

SQL Server 2005 Issue

I am stuck. I've just taken over maintenance on a SQL Server...that has not been backed up in quite a while...The log file has grown to over 1.61TB...Yes, 1.61TB. It has swallowed all available disk ...
8
votes
2answers
4k views

Third-party SSD solutions in ProLiant Gen8 servers

I was wondering if anyone had any specific experience using Intel DC3700 SSDs (or similar) in the HP (DL380p) Gen8 servers? I'm upgrading a set of database servers that use direct-attached storage. ...
0
votes
1answer
102 views

Server shuts down when running sql query

Sql Server 2005 Windows Server 2003 64 bit 8 processors 3 volumes with at least 100 gigs free on each I was adding an sql index for a table with millions of rows and the server shut down. Nothing ...
1
vote
1answer
89 views

SQL Databases get stuck in Unavailable State daily

Every day I notice several of my project DBs on SQL 2008 R2 (v. 10.50.2500) get into a limbo state where they are unavailable. They're not technically offline in this case. In Management Studio, ...
0
votes
0answers
226 views

Data Protection Manager and SQL

We are currently using Data protection manager 2012 SP1 to back up our medical records database in SQL Server 2008 R2. The database server is running Windows Server 2008 R2 as a virtual machine with ...
1
vote
1answer
573 views

centos mysql keeps crashing, what to do?

I recently got a dedicated server under CentOS with OVH. Everything has been working fine since 2 months, but starting a few days ago mysql keeps crashing and that causes various problems with my ...
-1
votes
2answers
84 views

SQL 2012 Server Database Transaction Replication performance issue [duplicate]

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented ...
1
vote
1answer
102 views

Importing old mediawiki SQL dump MAMP

I've been tasked with importing an SQL database to setup up with a local mediawiki website (v1.14). We were sent a SQL file with an image file to upload to the local site. After setting up mediawiki ...
0
votes
1answer
63 views

Grant user Permission using Wild Card on MYSQL

I'd like to Grant for example an insert permission for spacific user in all databases started by WA_ for example in my server I make the following syntax but it dosent work GRANT SELECT ON ...