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
2answers
223 views

Best way to upgrade Hard Disks holding SQL Data Files?

We have an SQL 2005 Server we need to upgrade the Hard Disks on. The most efficient way I can think of to do this is the following; Run a backup using Backup Exec on the D:\ Partition (This ...
1
vote
2answers
189 views

Group By , COUNT(*) and JOIN

When running the SQL below, any placemark_types.id that doesn't have a id match in placemarks table does not return anything in the results. I'm trying to at least get a type_count of 0 back where ...
0
votes
1answer
238 views

GPO WMI username filter not working over RDP

I'm trying to write a WMI filter to prevent a GPO from applying to certain users SELECT * from Win32_ComputerSystem WHERE NOT UserName LIKE 'domain\\user1_%' AND NOT UserName LIKE 'domain\\user2_%' ...
1
vote
1answer
150 views

Failed Simple Maintenance Plan only when Full Backups do not run

Let me start off that I'm new to SQL administration and have inherited an older server that serves the main DB for our day in/out operations. So, my apologies in advanced to my beginner questions. ...
1
vote
1answer
437 views

Servers in DMZ will not communicate with each other

(Full disclosure: I rate barely above "noob" when it comes to networking.) My workplace recent got a new web server. Since we're nearing the end of an overhaul of our website, we're doing a slooooow ...
1
vote
0answers
119 views

Kerberos: connection from win app running from IIS to SQL failed

I have an IIS web-application with Windows authentication and impersonation. This application connects to SQL server. In this case Kerberos works fine. But there is a problem. Web-application runs ...
0
votes
3answers
388 views

How to update phpmyadmin on hosted website? [closed]

I have a personal home page and I decided to start a server. I use ipage.com and their phpmyadmin is an old version. How to update to the newest 3rd version? I've read documentations and the problem ...
1
vote
0answers
63 views

No remote access to PostgreSQL db

i'm stuck in connecting to a PostresSQL database from remote host. The server is accepting incoming connections on port 5432 and i've configured pg_hba.conf like this: local all all ...
0
votes
1answer
59 views

Delete data from a SQL Server database on a full partition

I have a SQL Server 2005 Database on a dedicated partition, during the time the database grown and now it have occupied all the space on the partition, now the problem is that the only operation I ...
3
votes
2answers
435 views

sql server trusted connection with windows 8 microsoft account

We have a few developers that work, connecting in through a VPN for access to the development SQL Server 2012. Historically they've used Win7 machines and develop the website against this database in ...
-3
votes
1answer
657 views

How To Change MS SQL 2008 R2 Hostname? [closed]

I Installed MS SQL 2008 R2 Express And Plesk 11 MS SQL Hostname is ".\MSSQLSERVER2008" Right Now ! I Want Change it to "localhost" Can U Help Me ?
3
votes
2answers
76 views

Connecting to SQL server over the internet

One of my clients has a db that contains their data (this server also host an ASP.NET webshop) and they had me write a program for their client which with they can query their db. My problem is that i ...
2
votes
5answers
1k 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
117 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
140 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
92 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
285 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
46 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
0answers
98 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
734 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
283 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
239 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
371 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
61 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
29 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
1k 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
322 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
268 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
320 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
168 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
49 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
157 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
3k 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
36 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
38 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
107 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 ...
1
vote
0answers
36 views

Basic SQL server install help needed [closed]

I have a server with 2 hard drives and a dedicated attached storage device. On the server with 2 hard drives I will install Sharepoint in raid 1 configuration. Should and most importantly can I ...
0
votes
0answers
32 views

WP RECOVERY unable to link DB to WP 'Error establishing a database connection'

I have the following error. Error establishing a database connection I have a WP +BP + Faecbook site that is down. I had a recent backup before I made the changes. I am tryng to restore that. I ...
0
votes
1answer
82 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
255 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 ...
0
votes
0answers
4k 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
232 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 ...
0
votes
0answers
103 views

Why doesn't SQL Server consume all System memory even after Max Memory Option is set

I am utterly confused. Just a month ago I went to a site where the site's SQL Server Database was eating up all the server memory. This is fine, and it was intended. This site was using SQL Server ...
-3
votes
1answer
876 views

How to restart A Sql Azure Instance? [closed]

How can I restart my SQL Azure Server ? Is this possible ?
1
vote
3answers
264 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
70 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 ...