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
3answers
60 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
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 ...
0
votes
3answers
55 views

Error in connecting SQL Server

I have a LAN network consisting of 2 laptops where my friend's laptop is acting as a server and my laptop is acting as a client...I could detect my friend's instance i.e PC/SQLEXPRESS an d so can ...
0
votes
3answers
76 views

MYSQL Installation Problem

I was downloaded the MYSQL from this link http://dev.mysql.com/downloads/mysql/ But i cannot able to find the Installation file... How to create database & Table in mysql? It will work like SQL ...
2
votes
2answers
334 views

Creating sphinx table in mysql crashes mysql - why?

I've got the latest version of sphinx installed. I have created the index with no problems and searchd starts up with no problems. However, whenever I try to create a test table (straight from the ...
1
vote
2answers
112 views

Is it possible to get a list of all jobs that access a database in SQL server?

Is it possible to get a list of all jobs that access a database in SQL? I can't figure a way to do this. I can get a list of all jobs but not what dbs they access. Thanks
1
vote
2answers
250 views

Centralized Database Backup Server

We have database servers running on MySQL and Microsoft SQL. Is there a software that can do automated backups to all our database servers? I've already evaluated zrm of mysql(no web access,hard to ...
1
vote
2answers
166 views

DAC connection port SQL Server 2005 SP3

We have a named instance of SQL Server 2005 SP3 on an active/active cluster. We find that the Dedicated Admin connection (DAC) is not on one consistent port, the port changes whenever we reboot. We ...
0
votes
2answers
59 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 ...
0
votes
2answers
100 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
2answers
291 views

SQL Server account and login permissions for NAS?

We use MS SQL server express 2008 R2 to store data for our application. Recently, we've started storing the databases on a shared NAS drive. Previously, we had the sql server "log in as" built in ...
0
votes
2answers
173 views

SQL data and log files on Equallogic volumes

I've recently begun an exercise in looking into SQL best practices in terms of performance. I've read that it is recommended to put MS SQL data files (mdf) and log files (ldf) on separate volumes. ...
0
votes
2answers
144 views

SQL services wont start due to incorrect drive letter after windows restore

SQL services wont start due to incorrect drive letter after windows restore Had a server crash, was successfully able to reinstall windows and restore the server SQL and all the necessary services ...
0
votes
2answers
42 views

using multiple schemes in a clustered sql server 2008 Database

I have a SQL server 2008 R2 database with 2 schemas, i need to enhance the performance of the server so we plan to cluster the DB, we will have 2 nodes . is it possible to separate each scheme so each ...
0
votes
2answers
536 views

Any way to allow local computer login to access domain network remotely?

I am setting up a laptop for a customer (Windows 7). He needs to be able to access SQL server on his office network while on the road. What we are trying to do: Since he will be out of the office, he ...
0
votes
2answers
76 views

VPN connection in both ways

I am not familiar with VPN, Just a quick question: I have a VPN connection to a remote server from my local computer. I can ping the remote server and also connect to the SQL server in that machine ...
0
votes
2answers
155 views

mysql error InnoDB: 13

mysql not started @ server boot automatically but I can start manually as long as log as user "mysql" by using "/etc/init.d/mysql.server" the error I got on the log is InnoDB: Operating system error ...
0
votes
2answers
367 views

How do I backup and restore a database using sql script?

I have a Database of 50Gb of data on Test Server A, I want to take the Backup and I want to Restore it to Test Server B. I need Backup and Restore step by step with query's?
0
votes
2answers
46 views

Network MSSQL with local failover

I currently have a database setup where my MSSQL 2008 R2 server runs on my local network, but the program runs on a notebook that is normally mobile and away from the network. VPN works, but I'm ...
0
votes
2answers
398 views

SQL Server Snapshot Replication Subscriber (Editable or Read-Only)

I need to create a copy of my SQL 2008 R2 Enterprise database and have it located on the same server as the original. I will be using this second copy of the database as the target of a mostly ...
0
votes
2answers
86 views

Defragment a FILESTREAM data container

Has anyone ever tried to defrag a FILESTREAM data container using the Windows Disk Defragmenter? Does this work without taking the FILESTREAM enabled database offline? If this doesn't work, can ...
0
votes
2answers
187 views

MySQL Monitoring - Cloud Instances - No System Access

Are there any MySQL monitoring suites/tools built to use on systems such as Amazon RDS where you do not have system access? Looking for something beyond custom tools (nagios, zenoss, ganglia, ...
0
votes
2answers
404 views

Running sql server 2000 backup file on sql server 2008

I restored sql server 2000 .bak file to sql server 2008 by --RESTORE FILELISTONLY --FROM DISK = 'D:\DBHarshal\full backup august 6.BAK' --ALTER DATABASE EPICSms --SET SINGLE_USER WITH --ROLLBACK ...
0
votes
2answers
99 views

Restoring Database on SQL Server 2005 Issues

I have created a backup of my production database and whenever I try to restore it on my local machine I get the following error: The media family on device ...
-2
votes
2answers
70 views

Uninstall SQL Server

how do I uninstall SQL Server 2008 manually? Add/remove programs does not uninstall everything. Thanks in advance.
-3
votes
2answers
259 views

MySQL fails once per day. How to change “localhost” to 127.0.0.1

I get a can't connect through this socket once per day. Is this datadir correct?: [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock Aborted connection 1270592 to db: 'leechprotect' ...
0
votes
1answer
68 views

Shrink a DB and Log File in SQL after a database clear

We have a script that we use for client conversions that deletes all date from almost every table from a database. We do this so that we can clear out any data not related to the application ...
0
votes
1answer
54 views

find out which method is pegging my IIS 7 server?

I have a pretty simple web service app running on my server but every once and awhile it pegs one of my cores to 25% constantly until I stop and re-start then it goes back down to between 1% ~7%. I ...
0
votes
1answer
311 views

Is it possible to hide a Perspective with XMLA in Analysis Services 2008?

I have a SSAS cube that has 2 perspectives. The second perspective is only used in a secured environment. I would like this perspective to be hidden when new users connect to the general populations ...
0
votes
1answer
2k views

Error: Package 'Microsoft SQL Management Studio Package' failed to load. In SQL Server Management Studio

I had installed SQL Server 2008 R2, the installation was succesful. But I can't open the Management Studio because this error is shown: Package 'Microsoft SQL Management Studio Package' failed to ...
0
votes
1answer
116 views

Can't submit timesheets on Project 2007 and Server 2008R2 new install

I'm trying to test move a SharePoint 2007 and Project 2007 to Server 2008R2 and using SQL 2008 as the backend. I'm setting it up just like I have done numerous times for Server '03 and there are no ...
0
votes
1answer
86 views

Distributed Microsoft SQL server deployment - Cluster?

I have a website, I want to host on two diffident very far deployments. I have a rather good connection between them. But the users have a good connection only to what's near them. My Idea is to ...
0
votes
1answer
91 views

Stop unauthorized attempts to access port 1433

I'm picking up huge amounts of attempts to access our SQL database through port 1433 (Windows Server 2008). How do I configure a firewall rule that only allows access from the box IP only so that the ...
0
votes
1answer
167 views

Linked SQL Server to Oracle

Getting this error when executing SQL Server query only when connected via remote Desktop. When running the query from desktop, no problem. Is this a tsnNames issue? Linked server to Oracle 9i ...
0
votes
1answer
48 views

SQL installation

I just installed postgresql9.0.3 and when I went to the bin to run psql it asked for a password....I am typing the password which I gave at the time of installation but nothing is being written on the ...
0
votes
1answer
140 views

Database event trigger by timer

Suppose I have a table with the current users logged in on my website. And if I there isn't any "activity" from one of his/her username in a time interval it would be deleted from the table. What ...
0
votes
1answer
563 views

SQL Server 2008 Error when restoring DB backup: “specified cast is not available”

I was using SSMS to restore a database backup onto another database in a SQL Server 2008 instance, when I received the error message: "specified cast is not available". The backup was made on a SQL ...
0
votes
1answer
262 views

MS SQL Query Count & Sum

select count(distinct consumerno), sum (case when ccon like '%D%' then 1 else 0 end) as Domestic, sum (case when ccon like '%B%' then 1 else 0 end) as Business from consumer left join contract on ...
0
votes
1answer
44 views

Patching New Node on SQL Server 2005 /Windows 2003

adding a third node to an active/active cluster (currently sp3, no updates). adding the node for each virtual server through add/remove programs seems straightforward, but need to also install sp3 on ...
0
votes
1answer
309 views

Can Backup Exec 2010 Policy “steps” be bound to specific selection lists?

I'm trying to make a policy like this: Step 1: Backup everything in full Step 2: Come back and do transaction log backups on SQL/Sharepoint (with truncate) Step 3: Verify Backups. But when it ...
0
votes
1answer
38 views

Can not access SQL 2005?

the SQL has been installed but there is no server name and the Program does not accept any server name , and all the options , like the TCP , ports and Remote access are enabled
0
votes
1answer
433 views

Sql server 2005 linked server to 2008 error A severe error occurred on the current command

I am able to query few tables on the linked server but few tables are giving me this error. Msg 0, Level 11, State 0, Line 0 A severe error occurred on the current command. The results, if any, ...
-1
votes
1answer
1k views

SQL Server 2008 setup error Attempted to perform an unauthorized operation

I am trying to install SQL Server 2008 Standard Edition on windows 7 and during installation it give error: Attempted to perform an unauthorized operation