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]
0
votes
2answers
25 views
Export import sql database without downloading
Recently i need to change my server to another webhosting providers server. To do that just discovered that my MySQL database size is too much to download & upload with the access that I have.
...
-1
votes
0answers
13 views
SQL Server Data Tools- can not browse the deployed cube [closed]
I'm trying to browse the deployed cube, but it doesn't work.
I have this error: Element "return" was not found. Line 5, position 2.
How can I fix it?
Thanks in advance
1
vote
1answer
16 views
Plesk MS SQL Data backup restore issue
I am tiring to restore mssql backup in plesk but it showing following error please give me suggestions.
Error: dbbackup failed: Unable to restore database 'admin_db' Not valid backup Cannot open ...
0
votes
1answer
35 views
SQL Server Setup RAID 5, RAID 10
I am new to setting up SQL Servers and Vms. My predecessor used Raid 5 for C Drive where the SQL installation resided and RAID 10 for both database files and database logs.
I was wondering whether ...
2
votes
1answer
41 views
Does changing a Service from Automatic to Manual mean that it is unable to be started by other services/applications?
Morning all. We have a script that checks for services that are set to Automatic, but not running. It alerts us if this is the case. We've got a couple of services, like SQL Server Active Directory ...
0
votes
1answer
31 views
How to allow a SQL Login to see only ONE database
i have a SQL Server server 2008 r2. I wish to create a two new Login for a client who wishes to have access to their one database. But I don't want to give them access to the other my databases.
...
0
votes
1answer
19 views
SQL Error When Running My “Find All Unused Packages” in SCCM 2007 Report Console
SQL Error When Running My "Find All Unused Packages" in SCCM 2007 Report Console
Asked by: the_ratzenator I am trying to run an SCCM 2007 Report to find all unused Pacakges in my environment and I ...
0
votes
1answer
23 views
Remote servers replicating data to a Master server for reporting
I have Windows servers that are running SQL Server 200(5/8) in many remote locations on the east coast. At our corporate office, we are trying to set up a reporting server that can get as real-time as ...
-1
votes
0answers
16 views
writing a join query in oracle11g [closed]
i have to do a query in oracle 11g
but i really dont have any idea.would you please help me?
i want to cumpute the percentage of believers of every religion from the world’s population
...
0
votes
0answers
10 views
syntax error in a join query [migrated]
I have a query here:
For each country in America, give the highest mountain and its height; ordered by height.
and tables:
encompasses : country,continent
geo_mountain: mountain,country
...
1
vote
0answers
55 views
SQL Server: Worse performance on a new server
We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on ...
0
votes
3answers
42 views
How to connect to ms sql express?
I have sql express on my local network computer, I created new account, I enabled server auth, and when I am trying to connect to this account from local machine, everything works fine. But when I try ...
0
votes
0answers
19 views
Inserting nordic characters in database [migrated]
I want to insert some "special" (nordic) characters in my database (MS SQL 2012).
The script itself is made with PHP, and built on CodeIgniter.
The values looks fine until they enter the database, ...
0
votes
0answers
16 views
Running SSIS from workstations
I have to make a migration from SQL2000 to SQL 2008 R2. I currently have a few DTS packages that I run from user workstations to create some CSV files. They simply run a batch file on the WS that ...
0
votes
0answers
47 views
SQL failover cluster on single ESXi host
I'm setting up a virtual environment consisting of 10 VM's with 2 primary SQL databases required. The infrastructure allocates two pairs of SQL 2008 R2 Enterprise edition (VM's). The pairs are ...
-1
votes
1answer
23 views
SQL compare data from 2 tables [closed]
I have 2 tables where is MAC addresses stored. users.mac, workers.macs
Can you help with creating a code which compare data(MAC address) from both tables and print out only those which match.
0
votes
0answers
10 views
SQL Need advice how to add timestamp to this query [migrated]
I have this code:
select Users.phoneMac, Users.apMac, Locations.Lon, Locations.Lat
from Locations, Users
inner join (
select u.phoneMac, max(u.strenght) as most
from Users u, ...
0
votes
2answers
83 views
SQL Server does not exist or access denied on a local machine
I have the following exception when trying to open a connection to the server since last week.
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
I'm using MSSQL ...
0
votes
1answer
45 views
Compare two values in a single column SQL Server [closed]
I have a SQL Server database in which I ran a query that collects the data about two different tournamnets and the number of people enrolled in the tournament. So for instance the output is:
Name of ...
-1
votes
1answer
39 views
SQL How to select max value when comparing 2 sql tables. [closed]
[Need advice] How to select max value when comparing 2 sql tables.
Hi guys,
There is a project i am working on. And i stuck with this query. Maybe you guys could help me.
So some info about what i ...
0
votes
0answers
10 views
SQL Databases running on Windows 2003 R2 - SP2 - 64 Bit Enterprise edition
Can we expand the basic disK (NTFS ) that has the existing Databases like the ususal diskpart ?
Can some one pls confirm if we need any downtime or low i/o to do this ?
1
vote
0answers
34 views
SQL AlwaysOn auto fail over due to disk
All,
I'm in the process of evaluating SQL AlwaysOn, and everything is failing over as expected, except in one circumstance, when the disk goes belly up. In this case, SQL does nothing, other than ...
0
votes
1answer
22 views
how to proxy sql queries (INSERT, UPDATE e.t.c.)
I have installed cluster MYSQL (galley with mariadb)
As an application server installed Apache. on a server with Apache installed haproxy which proxies requests from php in this case installed for ...
0
votes
1answer
24 views
Sql Database Mirroring in a workgroup
I found an article explaining almost everything I need to know here:
http://www.sqlservercentral.com/blogs/kendalvandyke/2011/12/01/database-mirroring-in-a-windows-workgroup/
The only difference ...
0
votes
1answer
70 views
User upgraded to SQL Connector 6.6.5 now gets: Authentication with old password no longer supported, use 4.1 style passwords
I have a dev user who is running queries to bugzilla via .NET code, and after updating his connector gets the error "Authentication with old password no longer supported, use 4.1 style passwords." I ...
0
votes
0answers
15 views
MS SQL server 2008 R2 for databas slowing down
We are hosting a ERP/CRM system that uses MS SQL server 2008 R2 for database.
After a while some of this systems starts to feel "slow", high CPU utilz on database server and some maintance on the ...
0
votes
1answer
33 views
missing data after attach mdb
Recently, one of my customers had a server crash. Unfortunately, the 3th party who was responsible for the backup had 'forgotten' to schedule a backup of the DB (I know, I should have noticed that).
...
0
votes
0answers
27 views
Need some information about using SQL-Express 2012 with an OLD databse software
I have a friend who has managed to go for many years running their company on an old piece of software that is no longer supported. The original software vendor is no longer in business and the one ...
0
votes
1answer
58 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
0answers
24 views
Kerberos delegation on SQL cluster
Here's my setup.
A web server running ASP.NET web applications.
A SQL Clustered server, with 2 physical nodes.
Both of these are on the same domain.
The web server has been enabled for kerberos ...
0
votes
1answer
33 views
SQL server management studio 2005: Still can't copy column headers(checked option to include it already)!
I already changed the option to include column headers(Tools->option->results to grid->include column headers). Yet if I copy paste a Table or SQL query grid data results into Excel, i don't export ...
0
votes
2answers
93 views
Postgres INSERT ERROR: permission denied for schema public
In Postgres I created the following table inside a db called testing:
CREATE TABLE category_google_taxonomy (
category_id integer references category ON UPDATE CASCADE ON DELETE CASCADE,
...
0
votes
0answers
57 views
MS SQL 2008 - Can I use Windows Authentication to connect from a Mac
I have been using Navicat SQL on Mac (Snow Leopard) to connect to MS 2005 via "Basic Auth" and all is good.
However the DB is now being migrated to MS 2008 and try as I might I cant get on via Windows ...
0
votes
2answers
66 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
0answers
42 views
ssas mdx and t-sql gives different values
My situation:
There is a work database. Every day it is copied to another database named RetailDB. Fact and dimension tables of SSAS are based on VIEW-objects of tables in RetailDB.
So, I have this ...
0
votes
1answer
69 views
Hyper-V and Windows Server with Powershell/Automated?
So my work is looking into Automating Hyper-V Servers for Test Environments, Basically in the end we want to have a sort of Web/Form interface for selecting a server spin up. Right now it's done ...
-1
votes
2answers
125 views
What is a typical Compression Ratio for an SQL Database backup file? [closed]
One of my clients want us to give a safe estimate of how much disk space does a compressed SQL backup file take. They need to size their server hard disks accordingly.
We can rouhgly estimate the ...
1
vote
1answer
95 views
Enable MySQL to use more than 1 core (multicore)
I am running a very intensive MySQL query and noticed that only 1 core is being used to 100% while the other cores are idle. The system is running Ubuntu 12.04 and MySQL 5.5.28
Is there a way to ...
0
votes
0answers
22 views
SAP ERP with MS SQL Enterprise [duplicate]
My company has introduced a new SAP ERP suite which includes SQL Enterprise edition.
SAP ERP will be running on 5 physical servers with MS Windows Server.
Here is my Q. How many physical servers can ...
2
votes
0answers
54 views
Restricting access through ODBC to only schema views SQL 2008
I'm pretty green to SQL security, so maybe someone can help me. We've got a database application that, when installed, by default grants the public role access to all the tables in the database. When ...
-1
votes
2answers
58 views
Mysql very long query string [closed]
I have a problem with an ugly query. The query itself isn't so bad, the indexes are used and it is optimized. The problem is that the query is long, about 64k of text:
SELECT SUM( value ) AS ...
1
vote
0answers
114 views
SQL Server Replication Requires the actual server name
How Hard can it be?
Ive spent the last 4 hours googling just to find either nothing works, or people randomly posting information that 'sounds good'
My setup:
Two SQL2012 Servers, in two different ...
0
votes
0answers
61 views
Merge Replication fails on some tables (multiple publishers, single subscriber)
We had set up merge replication with multiple publishers and a single subscriber. The articles are four tables (similar across all four publications).
The problem is that 1 of the tables has been ...
1
vote
1answer
38 views
Backing up a mirrored SQL environment
I have 2 SQL servers in Mirror configuration.
I want to backup these servers but backing up the SQL databases in Mirror state causes an error.
These two mirrors also have a witness set.
I would ...
2
votes
2answers
213 views
MS SQL Server 2012 - Unable to access Instance on localhost
5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error:
...
3
votes
2answers
183 views
if I select more than 15 fields, I get catastrophic failure
Using sql server 2012 I am connecting to a linked server with Pervasive SQL on it.
When I do select * or select field1,field2,field3....field15 I am getting this error:
Msg 7399, Level 16, State 1, ...
0
votes
0answers
58 views
accessing a linked server but cannot select
I have a linked server to a pervasive sql 11 database from my sql server 2012 64bit using ODBC
I am able to see the databases on this server, but when I select * from any table I am getting this ...
0
votes
0answers
32 views
Sharepoint High Disk I/O - WSS_Search_SBS2011.mdf
Have a low specced server I've been troubleshooting (it is above MS's minimum specifications for SBS2011)
One of my next steps is disabling what I can of Sharepoint as it is not used.
Here are ...
0
votes
1answer
61 views
Separate Database For SQL Server Reports
I have researched this on here (and other sites) quite a bit.
I feel like I am missing something simple. So please direct me to another posting or help answer my question.
Basically, we have out ...
-1
votes
1answer
30 views
Advice for an address management webapplication with mySQL database [closed]
I need an application to store and manage addresses which is accessible via the internet. The tasks will be rather simple, like adding new entries, deleting them, exporting lists as Excel files etc.
...
