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
366 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
128 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
282 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
402 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
68 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
121 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
581 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
252 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
238 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
1answer
103 views

Space availability issue

I am using SQlserver2005. My database are becomeing very large and space is becoming very sparse. Please suggest what to do? (apart from buying space)
0
votes
1answer
180 views

Orphaned SQL Recordsets/Connections with IIS

I have an IIS 6 site running on Windows 2003 Server x86 with MS SQL2005 Enterprise edition running ASP Classic (no choice). The site runs very fast with about 8000 page views per hour. All of my SQL ...
0
votes
1answer
76 views

SQL Server Subscriber Migration

We're currently have one way transaction replication from a SQL Server 2005 OLTP publisher/distrbituor to two subscribers (one SQL 2005 and the other SQL2008 R2). Replication security is via the SQL ...
0
votes
1answer
769 views

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial ...
0
votes
1answer
386 views

SQL Server - Moving and Increasing number of TempDB

Based on best practices recommendation, we want to do the following Move tempDb to new dedicated drive Increase number of tempdb to 4 (all equally sized) Can anyone please share the commands, as I ...
0
votes
1answer
152 views

security in sql server 2008 r2, create special user

I have a system win server 2008/ sql server 2008 r2 where sql server is accessed by remote user (the same but multiple connections). I need to have a user who can create/alert databases but I do not ...
0
votes
1answer
61 views

Transactional replication

I have two databases in same instance of SQL Server 2005, configured for Transactional replication. When data is changed, the changes are replicated properly in both databases. For the new created ...
0
votes
1answer
179 views

SQL Server Backup Strategy for OLAP System

I need advise on what would be the best strategy for backups of OLAP database (WHICH is roughly 500gb in size) Would this be fine: 1. Weekly (Full) 2. Daily (Differential) No need to hourly log file ...
0
votes
1answer
335 views

SQL Server on VMWare - is transaction log corruption possible?

Scenario: SQL Server 2005 or 2008, Windows 2008 OS. Running in a VM hosted on VMWare ESX server. Is there any known issue with VMWare when it caches pass-through write request and it never reaches ...
0
votes
1answer
239 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
744 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
36 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
48 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
392 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
805 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
71 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
43 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
75 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
57 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
538 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
355 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
128 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
89 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
97 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
172 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
49 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
144 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
640 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
288 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
568 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
14 views

Stop SQL default instance

I have installed SQL Server 2014 named instance and configured to connect on static port 1433(Default SQL port). For example: db.mycompany.com\SQL2015,1433 But its able to connect to the default ...
-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
-5
votes
1answer
23 views

DB Server and Fully Qualified Domain Name

I have a hosted virtual server (Windows Server 2012 R2) that exists solely to host a few SQL databases. I need to purchase a SSL certificate to encrypt data but purchasing a certificate requires that ...