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

2
votes
1answer
443 views

Database Mirroring of SQL server

I have two databases that are mirrored to another server using database mirroring. The mirror server has to be down for some reason for few days. Now the production server is having principal ...
2
votes
2answers
12k views

How can I safely kill a long running MSSQL query?

Recently we had a SQL job inserting into a database. The query had been running for a few days unecessarily so it was killed using KILL SPID. The process then began to roll back for several days and ...
2
votes
1answer
172 views

How to View the IP routing table

How can I see ip routes I've added with ip route add default via x.x.x.55 table test1 for example I added 199 test1 and 198 test2 and 197 test3 to /etc/iproute2/rt_tables then I run: ip route add ...
2
votes
3answers
659 views

MySQL Injection Attacks? Random URL's Causing Errors

We just started running our own web server a few months ago on Rackspace (they are great). I use NewRelic (also pretty cool) to monitor server usage and I am getting error alerts that appear to me to ...
2
votes
5answers
3k views

Mysql - drop database with # in name

How can i delete database with # in name? Like that: #mysql50#mysql.backup I don't know who is possible to created it, but it happened. When I try DROP DATABASE name, I have error: ERROR 1102 ...
2
votes
4answers
4k views

iSeries DB2 - SQL GUI Tool

Can someone suggest a good free Database tool with SQL support for connection to an iSeries. Currently I am using the green screen and it is quite frustrating.
2
votes
5answers
2k views

Backing up a SQL Server 2008 R2 Database without stored procedures

Is it possible to back up a SQL Server database, but only back up the Table structures and content (i.e. not include the stored procedures, views etc?) The scenario: We have a data centre hosted ...
2
votes
1answer
741 views

How to count unique values?

I am trying get the number of unique ip_addresses (in this case '3'). The table looks like this: Structure: CREATE TABLE bandits ( key text NOT NULL, ip_address inet, offence text, count ...
2
votes
3answers
921 views

Can I restore a SQL server backup (.bak) without the password?

Is there any way to restore a SQL server backup (.bak) without the password? The file is not encrypted so I can see most of the data when I open it with notepad but I can't restore it to SQL Server.
2
votes
1answer
338 views

Programmatically add/delete users in Exchange

I've got the following set up: ASP.Net site that allows my internal employees to add in new hire information (no secure data, just stuff like name/address/phone) and when they submit this it goes ...
2
votes
3answers
16k views

Access is denied error installing SQL Server 2008 on Windows 7

Attempting to install SQL Server 2008 R2, Standard, Developer Edition, and/or Express on Windows 7 Enterprise, I keep getting 'Access is denied' at the very end of the installation. Contents of log: ...
2
votes
3answers
4k views

SQL Server 2008, not enough disk space

I'm executing sql query on my database. I have SQL Server 2008 installed on my D harddrive which has 55 GB free space. I have also C drive which has sth like 150 MB free (right now). While executing ...
2
votes
3answers
2k views

Managing SQL Server users via Active directory groups

I'm building SQL Server instance for reporting purposes. My plan is to use AD groups for server and database logins. I have several groups with different roles (admin, developer, user etc.), and I ...
2
votes
4answers
8k views

MySQL asking a user for SUPER privilege to perform a delete

When trying to do a delete operation on a table, mysql reports the following error: Error code 1227: Access denied; you need the SUPER privilege for this operation. However, my user has this ...
2
votes
4answers
269 views

SQL 2005 Standard Questions

I have a question about the tempdb files and hyperthreading. Here are the sw/hw specs. Server 2008 SP2 Standard X64 SQL 2005 Standard Sp3 x64 Dual Quad Core Xeon's E5540's (HT enabled) 12 GB Ram My ...
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?
2
votes
1answer
178 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
814 views

Blind SQL Injection PCI failure

I am working on a client's PCI compliance. One of the failing items is: 3.1.4. Blind SQL Injection (httpgenericscriptblindsqlinjection) The offered solutions is simply: "Ensure that the Web ...
2
votes
1answer
61 views

Copy a database from Denali CPT3 to SQL 2008 R2

Ok, officially this one is messing with my head. I had the worst idea to try out the SQL server Denali CPT3 when it came out on our development environment. And it seemed ok so we used and gathered a ...
2
votes
3answers
129 views

Server RAID and Partition Config for Small SQL Environment

I've got 5 databases that run on separate servers using SQL Express. Some of these include a Citrix Datastore, Citrix Edgesite Server, an AV db, Time and Billing App, and a document management ...
2
votes
1answer
560 views

Do we really need to perform MS SQL database integrity check regularly?

What's the benefit of performing regular database integrity checks? Can't we just perform it when there's a problem?
2
votes
1answer
2k views

'Service does not respond in a timely fashion' error when restarting Sql Server

When I try to restart my SQL server, I get the following error: Why this error happens and how to solve this?
2
votes
3answers
487 views

Trying to upgrade SQL Server 2008 to R2 getting strange error

The error states: No mapping between account names and security IDs was done. This is during an upgrade of 2008 sql server with sp3 to r2. This results in the database engine not being installed :( ...
2
votes
1answer
69 views

How to Properly Migrate SQL

If I am changing servers, I usually migrate my wordpress database by going to phpmyadmin and doing an SQL Export on one server and doing an Import on the other server. I notice that in this process, ...
2
votes
2answers
2k views

What is more important to SQL 2008, RAM or CPU power?

I currently have a server which runs SSIS 2008 and SQL 2008. I want to improve the performance of the server and keep the performance of the server steady when SSIS is running. I have an SSIS package ...
2
votes
1answer
239 views

Is it safe to abort a CHECK TABLE (mysql) query? (check table TBL_NAME fast)

Is it safe to abort a CHECK TABLE (mysql) query? (check table TBL_NAME fast) Or can this have impact on the data? Corruption? The table has GBs of data and the server crashed so, now its checking, ...
2
votes
5answers
242 views

sql server - shrink database size

I have a SQL Server 2008 DB. I store mainly text data in it, but also inserted some blobs in it. The size of the DB increased. Now I deleted the blobs, but it seems that the size of the DB stayed the ...
2
votes
1answer
791 views

Installing MS SQL Server 2008 R2 side by side with MS SQL 2008 R2 Express edition

I have to install full version of MS SQL 2008 R2 (it's Web edition) side by side with MS SQL 2008 Express (for a short period, before migrating all db's to full version). I guess that it can be ...
2
votes
3answers
622 views

SQL Server 2005 backups for previous 5 days on disk?

My goal is simple. I want to have SQL Server keep a nightly backup of a DB for a rolling 5 days. So each night at some time I want a new DB backup made and one deleted such that I have a rolling 5 ...
2
votes
2answers
167 views

SQL database testing: How to capture state of my database for rollback

I have a SQL server (MS SQL 2005) in my development environment. I have a suite of unit tests for some .net code that will connect to the database and perform some operations. If the code under test ...
2
votes
1answer
88 views

Role with owner privilege?

How can i create new role and provide owner privilege for specific database in SQL Server?
2
votes
3answers
1k views

SQL CE thread unsafe - alternatives?

I have discovered that SQL CE is not thread safe: SQL CE objects are not thread-safe and are not thread affinitive either. If an instance of SqlCeConnection or SqlCeTransaction is shared across ...
2
votes
5answers
921 views

Copy data from Access to SQL

I have a an access DB that is to be eventually be replaced by a SQL DB with a web front end. The web application is currently in development. I have copied the Access DB to SQL using the Migration ...
2
votes
4answers
2k views

SQL Server I/O Error 21

I am trying to take backup of one DB Which is showing Continuosly I/O Error 21 (The device is not ready) deteceted during read at offset 0x000000000000000040 in file e:\test.ndf Error 823. The Step ...
2
votes
1answer
42 views

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not ...
2
votes
1answer
1k 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 ...
2
votes
1answer
4k views

ERROR 1 (HY000): Can't create/write to file (Error code :13)

Iam trying to create a mysql table in linux with changing data directory to another location. The selected forlder having full permission. But I got an error 'Can't create/write to file'. I googled ...
2
votes
1answer
551 views

How should I configure my Active Directory servers so that if one goes down, users are not kicked off SQL?

Today, we shut down one of our Active Directory servers during office hours to check the loading on a UPS. Since all the server did was provide Active Directory in a separate building incase the main ...
2
votes
3answers
216 views

How do I secure Sql Server 2008 R2

I have both a dedicated and a VPS (from Fasthosts) virtual server - the web sites/applications I run on these, access Sql Server stored on the same web server. Until now, I have logged onto Sql ...
2
votes
1answer
202 views

Multipathing vs. bonded connections

I recently tried to sell the idea of multipathing one of our production databases (thanks to Brent at SQL Pass summit!) currently using just 1 database file (189GB!!!) on a physical server with 2 ...
2
votes
1answer
142 views

Problem migrating SQL Server to MySQL

I currently have a SQL Server 2008 database on Windows Server 2008 and I want to move the data to a MySQL 5.1.54 database on a Ubuntu server. I downloaded the MySQL ODBC 5.1 driver, created a DSN with ...
2
votes
1answer
57 views

Migrating data from SQL Server 2000 to SQL Server 2005

I have to migrate existing data which is in SQL Server 2000 to SQL Server 2005. The schema of two databases is different. For Example Locations table in SS2000 is split into two tables and has ...
2
votes
6answers
436 views

SQL Server 2005: Selects good, Inserts bad

We've come across a perplexing problem with our database application. We're running the application in 3 different (but similarly spec'd) environments. Select Insert Env1 0.81ms 0.94ms ...
2
votes
3answers
86 views

Set up a temporary reliable database server on a budget of $0.00

I am helping run a Model United Nations conference for high school students. The conference is completely organized and staffed by university students. I am writing an application that will keep track ...
2
votes
2answers
94 views

Sql Server Limiting Access

I am not sure if what I want is possible but here we go. At work we have a dedicated SQL Server 2008 box that host the various databases that we need to run. We have a remote person (lets' call them ...
2
votes
3answers
6k views

Can't Open Port 1433 on Window Server 2008 (attempting to connect to SQL Server 2008 Express)

I'm trying to open Port 1433 on windows firewall but not having much luck. I've added a new Inbound Rule (attempting to open TCP 1433) which looks okay and appears to be on but when I run netstat -an ...
2
votes
2answers
699 views

SQL Server 2008: Can't remotely connect via management studio yet can telnet in OK. All settings appear OK

I am in the process of trying to configure SQL Server 2008 to accept remote connections. I have been through all the documentation I can find and yet when I attempt to connect through management ...
2
votes
2answers
4k views

IIS7 ASP - Provider cannot be found. It may not be properly installed

Getting a strange error for an old site I am trying to move to a new server - The new server is Win2008 64bit with IIS7. This site is working perfectly on an IIS6 Win2003 server, but I have just ...
2
votes
2answers
689 views

default PUBLIC settings

does anyone know of any security risks with the default PUBLIC settings for sql 2005/8? i ran sp_helprotect and it listed out the PUBLIC grants, and now i have an auditor telling me that i have a ...
2
votes
2answers
484 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. ...