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
5answers
2k 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 ...
1
vote
1answer
122 views

database size limit in SQL Server 2012 Express Edition

I want to use SQL Server 2012 Express Edition. Does someone know the maximum file size limitation of the database?
0
votes
1answer
143 views

What to do instead of shrinking your databases and how to fix issues caused by previously shrunk databases?

I'm a fairly new SQL Server DBA but come from a software engineering background. I've been reading on several blogs that shrinking a database on a regular basis is bad and I understand why. The issue ...
0
votes
1answer
130 views

Sql Server 2008 Create Foreign Key Manually

I have inherited an old database which wasn't designed very well. It is a Sql Server 2008 database which is missing quite a lot of Foreign Key relationships. Below shows two of the tables, and I am ...
0
votes
2answers
38 views

Where is the file size limit stored in the system tables in sql server

I have many databases restored from various other database servers on a shiny new server. I want to unify the log file size limits and allocation percentages. However, I'd like to not do this by hand ...
1
vote
1answer
37 views

SQL Edition, serverproperty

I am trying to find all the sql installations in our network. I found more than 100 machine names which has sql installation. I tried to connect to those machines via client tool, but was not able ...
0
votes
1answer
393 views

What are invalid table names in SQLServer?

So, apparently you can't name a table Trigger in SQLServer. Someone in my office found out the hard way porting an application from MySQL, I'm suspicious of whether or not that's a valid table name in ...
1
vote
1answer
49 views

Altering a table via SQL Server Management Studio - get SQL

Is there a way to get the ALTER statement run by the management studio when altering a table in the design view?
0
votes
1answer
107 views

SQL Server 2012 Memory usage

Since i upgraded to SQL Server 2012 I've noticed that it almost doesn't consume any memory at all. Before when i used SQL Server 2008 R2 it used at least 2-4 GB of RAM and now it only used like 150 MB ...
0
votes
1answer
1k views

Oracle- Can't access objects from other users schema

I have an oracle database with 2 users. I have created a table in one of the user accounts, but cannot access the table from the other account ("table or view does not exist"). It doesn't work when I ...
1
vote
1answer
306 views

What's the importance of restoring SQL Server system databases (model, master, etc.)?

I had to restore some production databases to a different drive on the same Microsoft SQL Server 2005 machine. That worked fine and the application using the databases is back online. However, i have ...
1
vote
1answer
336 views

Restoring Microsoft SQL databases to a different disk partition on the same server

We have a SQL Server 2005 box running Windows Server 2003 R2 Std 64bit. We have two production databases residing on one partition (which is an iSCSI software target), that partition got apparently ...
0
votes
1answer
475 views

SQL Server 2008 R2: starting SQL browser failed

During troubleshooting of the failed connection to sqldb in my testsystem I've tried to start sqlbrowser via command line. This results the following error message "failed starting SSRP redirection ...
0
votes
1answer
64 views

SQL Server on the internet

I've got a desktop application connecting to SQL Server directly, I see a lot of posts saying you shouldn't expose SQL Server directly to the internet but none say why. Some background: Scalability, ...
1
vote
1answer
21 views

advise on pointing reporting service data sources

It's possible I am unable to resolve this because I have been spoiled in other DEV environments where I had one database server for each reporting server. I need some advise on how to point a single ...
1
vote
1answer
31 views

SQL Database Core Usage

Is there any way to change what cores SQL 2012 Enterprise uses? Suppose you have 16 cores on a server, what is the process of going through and telling the database to only actively use 2 cores? Is ...
0
votes
1answer
2k views

Constant Errors on SQL server, Event ID 28005 and 4625

We have been getting the following errors on our SQL 2008 R2 server several times a second. I have searched the internet to its ends and I cannot find a solution that will work in our situation. I ...
1
vote
1answer
399 views

Update mysql database with arpwatch textfile database

I'm looking to keep arpwatch entries in a mysql database to crossreference with other information I'm storing based on mac addresses. I've manually imported the arpwatch database into my mysql ...
0
votes
1answer
605 views

Alias a linked Server in SQL server management studio?

Hoping someone can help - is there a way in SQL server management studio 2008 R2 that I can alias a linked SQL server? I have a server, added by IP address, to which I do not have the login ...
0
votes
2answers
545 views

How can I move a MySQL database to a new localhost? [closed]

I have a localhost (XAMPP) on an old pc. I need the MySQL database on my new mac with a localhost (MAMP). Issue is, pc doesn't have internet connection. Any way I can move the database over? Detailed ...
3
votes
1answer
228 views

SQL Server 2012 Management Studio Express - no server

I am having trouble with SQL Server 2012 Management Studio. There is no server name. Earlier I installed the 2008 version but something wasn't right so I uninstalled and installed 2012. Upon ...
1
vote
1answer
55 views

SQL Performance - Convert parameter or column type

I was asked this on an interview, and would like some feedback... I have a stored procedure that takes in a varchar parameter IsActive that is either a "YES" or "NO" string. The stored procedure ...
0
votes
1answer
181 views

MSSQL Incremental Database-to-Database backup/clone

I'm trying to save some time on a repeated task I keep getting asked to do. We have an internal application we'll call "App". This App has a database called "AppLive" We have a "Test" instance of ...
0
votes
3answers
24 views

Apache / PHP Begins to Deny SQL Requests after about 2000

We have a web page on our server that we use to run administrative scripts. For example, we might run the script "unenrolStudents()" which runs 5,000 SQL SET commands one after another and sets 5000 ...
2
votes
1answer
4k views

SQL Server (2012 Enterprise) Browser service failing

SQL Server (2012 Enterprise) Browser service failing I have a problem as described below: I have an instance of SQL Server 2012 Enterprise (thanks to MSDN) for local development on my PC. I try to ...
0
votes
1answer
39 views

SQL Server 2008 data migration to another SQL 2008 server

I am currently running SQL server 2008 (SQLserverold) which homes databases for systemn center Service Manager 2012 Datawarehouse. This server is very old and needs to be decommisioned. Prior to ...
2
votes
0answers
41 views

SQL Replication cannot access file

When setting up a subscriber it fails on the first sync with the message The process could not read file <file-name> due to OS error 2 I have tried setting the security rights for the ...
0
votes
2answers
111 views

changing the default port of Mcrosoft SQL Server [duplicate]

Possible Duplicate: port number of SQL Server Can any one guide me on How can I change the default port of Microsoft SQL Server in my Windows VPS? I am using Windows 2008 as my operating ...
0
votes
1answer
83 views

MySQL broke; how can I save some of the tables?

For some reason my MySQL can't connect any more. I'm running three WordPress sites and I need to save the tables. That's what I really really really really care about. Here is the problem: ...
1
vote
0answers
340 views

Installation of Access Database Engine 32-bit Fails

I am trying to install Access Database Engine 2007 32-bit. The splash screen comes up, you click "Next", then it fails with the error: Installation ended prematurely because of an error You click ...
1
vote
0answers
7k views

Cannot telnet to SQL Server on port 1433

I've been working solidly on this issue for the past three weeks. I cannot seem to find where the actual issue is. I just recently found this article on how to troubleshoot the connection. I made it ...
-1
votes
2answers
245 views

The good SQL database to process a lot of data?

I have to process like 10-100 millions records. I have to give the data to the client when it's finish. The data is givent as SQL requests to execute in the database. He have a powerful server with ...
-2
votes
1answer
1k views

How to restart A Sql Azure Instance? [closed]

How can I restart my SQL Azure Server ? Is this possible ?
1
vote
3answers
281 views

Sending an email via cron

I'd like some advice on how best to send an email after running a SQL query. Every day, I would like to run a PHP/SQL script to identify users who should be emailed. After this runs, I would like to ...
0
votes
1answer
81 views

SQL Server 2005 connection to SQL Server 2008 R2

I having trouble with SQL Server 2008 R2 Express. I installed it and the service is running but SQLexpress, but without success. I even tired to uninstall SQL Server 2008 R2 and I could it said that I ...
0
votes
1answer
92 views

Issue restoring Sql Server DB -

Im trying to restore one our DB on Sql2008r2 but i keep getting this error: " netStagingDB_log.ldf' is claimed by 'ftrow_FTCat_Sheds' and 'ftrow_FTCat_Codes'. The WITH MOVE clause can be used to ...
1
vote
1answer
124 views

Remove permissions on sysobjects table for db user sql 2012 like in ms sql 2000

In a bygone age in ms sql 2000, if I wanted to remove a db users ability to view the sysobjects table in Ent. Manager I'd find the user in the database, right click him, select properties and then ...
1
vote
1answer
331 views

MS SQL Server 2000 timeout error with no apparent cause

Morning All, I'm having trouble with query timeouts in MS SQL Server 2000. It is used as a backend for Intuitive ERP, a rather old ERP system based on MS Access. My problem is that, when performing ...
2
votes
1answer
441 views

yum: Difference between mysql, mysql-server and mysql-devel

What are the differences between the packages here? mysql, mysql-server and mysql-devel I am installing a SQL server to use with PHP, but I found these three packages and am not sure which to use.
1
vote
3answers
451 views

Slow PostgreSQL response over VPN

I'm having a problem with a medical records program that uses a Postgre SQL as a backend. Several offices are connecting to a corporate site via Cisco VPNs. There is an ASA5055 at corporate and most ...
0
votes
3answers
146 views

How to link mysql query to a php process?

I noticed I have an abnormally large amount of mysqld processes which have various mysql queries; I've restarted mysqld and all of these processes come back within 10 seconds. I know the processes ...
1
vote
1answer
460 views

How can I set up an authentication system with single instance storage of credentials and several authentication methods/interfaces?

Background: I have a collection of Linux-based servers (let's say a few dozen) that are hosted in different locations. Some servers are lone satellites while others are hosted together in the same ...
1
vote
1answer
36 views

Installing Asp.net 3.5 sp1 on windows 2008 web server edition

I am trying to install sql server 2012 on windows 2008 web server edition but failing as asp.net 3.5 sp1 is missing. I cannot add asp.net 3.5 on this version as there is no 'Application Server' role. ...
1
vote
2answers
364 views

automatically restart sql server after job completes

I'm looking for a way to automatically restart the SQL service after an agent job has completed or as the last step of an agent job. It occurs to me that the agent service is dependent on the server ...
2
votes
1answer
568 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 ...
1
vote
2answers
240 views

what would need to change on IIS for SSL Enabled SQL server

I have IIS set with windows intergrated security, the intranet c# web application connects database with trust connection. Everything works fine until we enabled SSL on the database (Sql server 2008), ...
0
votes
1answer
110 views

Error 1045 while configuring mysql

I can install the mysql but while configuring it i am getting error like this: ** 1045 : access denied for user root@loaclhost.** i can install it i cant configure it. Please help...I am quite new to ...
7
votes
1answer
7k views

How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?

I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
0
votes
1answer
114 views

How to stop Java web app on server remotely

I remotely ran a Java web application on a server using TightVNC. One of the tasks of the web app was that it would schedule and do a specific task every 15 minutes. Turns out the code is incorrect ...
2
votes
1answer
374 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 ...