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
2answers
354 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
120 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
265 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
167 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
232 views

How to increase performance on ASP.NET/IIS/SQL website

We have a small internal ASP.NET website running on IIS8 and SQL2014 express. The server is an onsite dedicated server 2012 R2 VM that has both IIS and SQL server on it. The server CPU usage rarely ...
0
votes
2answers
63 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
111 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
480 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
218 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
196 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
43 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
576 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
78 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
159 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
376 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
47 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
457 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
95 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
190 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
301 views

SQL Server 2008 Express, need to copy a table from one server to another automatically

We have 2 servers with SQL Server 2008 Express for IVR systems and one for our website. The website's database server is more accessible on our network. I would like to copy some tables from the other ...
0
votes
2answers
493 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
1answer
195 views

Migrating databases from SQL 2000 to 2008 R2

Hands-ups, I have no idea what I'm doing! We have an old SQL 2000 Server with 2 databases. I have a new server running SQL Server 2008 R2. Can someone outline the basic steps of migrating the ...
0
votes
1answer
96 views

sql 2008 hard drive configuration

I'm building out a new SQL Server 2008R2 64BIT, will be running two user database of about 20gb and 15gb, maybe 50/50 read/write, and about 210 users Base hardware would be DL380, 48GB, and Intel® ...
0
votes
1answer
682 views

Error while installing sql server 2008 - “the collation was not found”

In the server configuration page of my Microsoft sql server 2008 setup, the database engine field in the collation tab is empty. I think it should be having "SQL_Latin1_General_CP1_CI_AS" written ...
0
votes
1answer
35 views

Using a subscriber database as a backup

I am trying to set up a transactional replication database on two MSSQL 2008 Standard servers. We need to be able to query off of the subscriber database, but we would also like to be able to use the ...
0
votes
1answer
44 views

MySQL Column Constraint

I need a table which will allow to insert values into a column with values greater than 10. When I tried in net, they suggested to create table in following way. CREATE TABLE test ( UID int(11) NOT ...
0
votes
1answer
50 views

SQL2008R2 Partitioning query

We have a complex query that returns results in 45 secs when run from the 01-05-11 to the 31-05-11, but when it is extended to the 01-06-11 it runs indefinately... THe tables are partition by ...
0
votes
1answer
371 views

Linked server sql server 2008 r2

We have two SQL servers and we've setup a them as linked servers. The queries works just fine if I connect remote desktop to one of them and execute query. If I try to execute query from third machine ...
0
votes
1answer
726 views

directory not owned by the 'mysql' or '_mysql' user

I have recently installed MSQL for a Rails App. After some tinkering, I have an error starting mysql now that reads as follows: Warning: The /usr/local/mysql/data directory is not owned by the ...
0
votes
1answer
70 views

SQL 2008 Performance Reports

Does anybody know of DMV's or reports that will show the historical performance of the stored procedures on the server? Also if that data is stored in a table or tables, what is the retention period ...
0
votes
1answer
41 views

Can't find SQL 2005 client and repoting tools after install

I've gone through the related questions and I'm still stuck. I installed SQL 2008 R2 Express and then it turned out I needed reporting services client tools in SQL 2005. I uninstalled SQL 2008 and ...
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
511 views

Gerrit uses wrong collation

I'm trying to authenticate Gerrit users using ldap against Active Directory. I get the following error. ERROR com.google.gerrit.server.cache.PopulatingCache : Cannot lookup ...
0
votes
1answer
336 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
3k 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
123 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
88 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
93 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
170 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
143 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
621 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
275 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
522 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, ...
0
votes
1answer
92 views

MySQL on a laptop for remote workers - MyISAM keeps corrupting

We have an application that is used by remote, mobile workers. It intalls WAMP (Server2Go) on a laptop and uses MySQL to store data locally. All tables are MyISAM. Once a day, the workers sync the ...
-1
votes
1answer
2k 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