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
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. ...

1 2 3 4 5 17