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
61 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 ...
-1
votes
2answers
282 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
1answer
125 views

Multiple POST SQL injection from same IP [duplicate]

Recently I checked my Apache domlog and noticed the following attack: POST ...
0
votes
2answers
561 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
1answer
195 views

Are there simple command line tools to decode a SQL Injection request string? [closed]

My web server periodically comes under attack, and I get a bunch of requests that look like /my.page?union+all+select+0x31303235343830303536%2C0x31303235343830303536%2C0x31303235343830303536-- Are ...
0
votes
1answer
61 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
49 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
1k 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
174 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
93 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
60 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
68 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 ...
12
votes
2answers
12k 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
130 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
198 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
344 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 ...
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 ...
-1
votes
2answers
150 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
147 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 ...
3
votes
1answer
310 views

Are SQL Collations per Instance or per Database?

I have a single SQL Instance, let's say MSSQLSRV - is the collation per Instance, i.e. every database in the given instance has the same collation, or are collations set per database? i.e. multiple ...
0
votes
1answer
83 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 ...
0
votes
3answers
51 views

SQL Instances and Servers

I have two installations of SQL on two seperate boxes (I have "Inherited" these). A SQL 2005 Installation, with instance called SQL2005 - I connect to this via SQL Studio Manager and when I connect ...
0
votes
2answers
2k views

SQL Management Studio on Windows 7 64Bit

We're scratching our heads a bit here. We have SQL Server 2000 on our internal systems and I have a new machine. My old windows XP machine had Mgmt Studio (full version). I have tried to run the SQL ...
-1
votes
1answer
1k views

SQL Server 2012 - No connection could be made because the target machine actively refused it

I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked. I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL ...
0
votes
3answers
62 views

Connecting mySQL to MSSQL

I need a little advise, I need to sync a DB that is currently on a Server 2008(SQL Server 2005) machine and I use Studio Express to connect to it. I need a way of syncing this DB to mysql that lives ...
0
votes
0answers
83 views

Tips on Copying 3 Database files nearing 250 GB?

We are upgrading from SQL Workgroup 2005 to SQL Standard 2012. We have plenty of databases of smaller sizes that copied over with straight windows file copy in a reasonable time frame. We have one ...
0
votes
1answer
50 views

Need to DROP TABLE from 100s of SQL backup files

I have MS SQL Server 2008 available to me. Is it possible to script (perhaps with Powershell?) the processing of all my backup files to drop a table (or two) from each one? I used 7-Zip on the command ...
0
votes
2answers
108 views

Upgraded SQL server, performance plummets

Seeking help with a new SQL server. A client of mine was running an aging SBS 2003 server (Xeon 3060, 4 gig of RAM) and a line of business application with a 25 gig SQL Database using SQL Server ...
0
votes
1answer
53 views

MySQL replication as both master and slave (replication loop?)

I've got two MySQL servers, one as a master in the replication process and the other as the slave. I was wondering if anything bad would happen if I made the current master a slave to the current ...
0
votes
1answer
178 views

Sql server 2008 R2 using Half of the memory [closed]

i built a new 2 cpu 8 core 40 gb ram Server for our ERP software which use Sql server 2008 R2 on Win server 2008 standart R2, in Sql There are 7 databases, 2 of them for Tests, 2 of them to keep ...
0
votes
1answer
4k views

mysqldump ignore table with wildcard

I need to take a dump of a database containing 50 odd tables of which I want to exclude about 15 odd that have prefix 'exam_' I tried mysqldump --ignore-table=dbname.exam_* and even tried ...
1
vote
1answer
24 views

Migrating from SQL 2008 to SQl express on the same VM

I have a windows 2008 r2 VM running SQL std 2008. I want to migrate my database from SQL server to SQL express which is a free product. Since I have one VM, I plan to install SQL express alongside SQL ...
0
votes
2answers
50 views

Export import sql database without downloading

Recently i need to change my server to another webhosting providers server. To do that just discovered that my MySQL database size is too much to download & upload with the access that I have. ...
0
votes
1answer
51 views

SQL Server Setup RAID 5, RAID 10

I am new to setting up SQL Servers and Vms. My predecessor used Raid 5 for C Drive where the SQL installation resided and RAID 10 for both database files and database logs. I was wondering whether ...
2
votes
1answer
143 views

Does changing a Service from Automatic to Manual mean that it is unable to be started by other services/applications?

Morning all. We have a script that checks for services that are set to Automatic, but not running. It alerts us if this is the case. We've got a couple of services, like SQL Server Active Directory ...
0
votes
1answer
40 views

How to allow a SQL Login to see only ONE database

i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases. ...
1
vote
1answer
355 views

Dynamic column enumeration for preventing SQL injection

I have an application which is completely for internal use but I'm trying to make sure I have my bases covered on SQL injection. Unless someone else has some information to point me otherwise there ...
0
votes
1answer
406 views

SQL Error When Running My “Find All Unused Packages” in SCCM 2007 Report Console

SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I ...
0
votes
1answer
36 views

Remote servers replicating data to a Master server for reporting

I have Windows servers that are running SQL Server 200(5/8) in many remote locations on the east coast. At our corporate office, we are trying to set up a reporting server that can get as real-time as ...
1
vote
0answers
87 views

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
0
votes
3answers
88 views

How to connect to ms sql express?

I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
0
votes
0answers
81 views

SQL failover cluster on single ESXi host

I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
0
votes
2answers
1k views

SQL Server does not exist or access denied on a local machine

I have the following exception when trying to open a connection to the server since last week. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I'm using MSSQL ...
0
votes
1answer
316 views

Compare two values in a single column SQL Server [closed]

I have a SQL Server database in which I ran a query that collects the data about two different tournamnets and the number of people enrolled in the tournament. So for instance the output is: Name of ...
1
vote
1answer
253 views

SQL AlwaysOn auto fail over due to disk

All, I'm in the process of evaluating SQL AlwaysOn, and everything is failing over as expected, except in one circumstance, when the disk goes belly up. In this case, SQL does nothing, other than ...
5
votes
3answers
3k views

SQL Server Collation settings for System Center Service Manager 2012

There is a lot of conflicting or confusing information surrounding the required collation settings for SQL Server, as it pertains to hosting the SCSM 2012 database and associated data warehouse ...
0
votes
1answer
1k views

How to check web server logs for SQL injection?

If I have a PHP site hosted on Apache and someone hacks it using SQL injection, is there a way I can find out exactly which script caused this by looking at my web server logs? Or using some other ...
0
votes
1answer
298 views

Sql Database Mirroring in a workgroup

I found an article explaining almost everything I need to know here: http://www.sqlservercentral.com/blogs/kendalvandyke/2011/12/01/database-mirroring-in-a-windows-workgroup/ The only difference ...
0
votes
1answer
693 views

User upgraded to SQL Connector 6.6.5 now gets: Authentication with old password no longer supported, use 4.1 style passwords

I have a dev user who is running queries to bugzilla via .NET code, and after updating his connector gets the error "Authentication with old password no longer supported, use 4.1 style passwords." I ...
2
votes
1answer
3k views

Why does a mysql query, that requires copying to tmp table, randomly sometimes consume 100% CPU during several seconds?

I have some crazy SQL queries in my PHP scripts which badly need some optimization. However the question is NOT about how to optimize them. These queries have a lot of "join"s and some bizarre "order ...