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
22 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.
...
2
votes
0answers
53 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 ...
0
votes
3answers
40 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 ...
-1
votes
0answers
12 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
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 ...
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 ...
1
vote
1answer
726 views
Weird Windows 2003 MSDTC and SQL 2005 issue
scenario:
Windows 2003 sp2 x64 enterprise edition.
SQL 2005 sp2 cu9 x64 Enterprise edition
After restarting the resource groups on two node active-active cluster, 3 SQL 2005 instances start up fine. ...
0
votes
1answer
18 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
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 ...
0
votes
1answer
1k 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 ...
3
votes
2answers
203 views
sql server trusted connection with windows 8 microsoft account
We have a few developers that work, connecting in through a VPN for access to the development SQL Server 2012. Historically they've used Win7 machines and develop the website against this database in ...
0
votes
5answers
4k views
SQL Server Log File Won't Shrink due cause “log are pending replication” on non replicated DB?
I have a non Mission Critial DB 9am-5pm SQL Server database that I have set up to do nightly full backups and log backups every 30 minutes during business hours. The database is in full recovery and ...
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
22 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
...
5
votes
2answers
3k views
How to attach mdf files from a different SQL Server Install?
Hi I have mdf and ldf files from a different SQL Server install from a machine i dont have access to now, and would like attach them to my current install to get at the data. When I try this, I get an ...
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
1answer
911 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
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, ...
1
vote
1answer
576 views
How do I troubleshoot root cause of a hung windows (2003) server?
I have a pair of Windows (2003 Server) servers both running MS SQL Server (2008 EE) that each hang every few months. This has been occurring intermittently :( for the past 15 months pretty much since ...
0
votes
2answers
81 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
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
22 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, ...
2
votes
1answer
889 views
Problem accessing MICROSOFT##SSEE database (Error: 18456, Severity: 14, State: 16.)
After an unexpected server shutdown due to a power failure, I can no longer connect to the internal windows database MICROSOFT##SSEE which is hosting Central Admin for my SBS 2008 server.
The log ...
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
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
38 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 ?
5
votes
1answer
2k views
How do you get the minimum and maximum memory allocation of a SQL instance using T-SQL?
I'm managing about 90 SQL Server instances and need a query to determine how much memory has been allocated to each instance. Please note, I'm not asking how to set it, just to see what it's currently ...
1
vote
0answers
33 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 ...
18
votes
8answers
50k views
SQL Server 2008 Express - “Best” backup solution?
What backup solutions would you recommend when using SQL Server 2008 Express? I'm pretty new to SQL Server, but as I'm coming from an MySQL background I thought of setting up replication on another ...
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
69 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 ...
2
votes
3answers
3k views
Can't Open Port 1433 on Window Server 2008 (attempting to connect to SQL Server 2008 Express)
I'm trying to open Port 1433 on windows firewall but not having much luck.
I've added a new Inbound Rule (attempting to open TCP 1433) which looks okay and appears to be on but when I run netstat -an ...
0
votes
0answers
14 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 ...
6
votes
3answers
9k views
Postgres: How can I see all SQL statements being executed by the database server?
I'm in the process of reviewing every SQL statement that an application makes against the database, for performance reasons.
Is there an easy way to log all statements that are executed by the ...
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
89 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
56 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
65 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 ...
0
votes
1answer
4k views
query from sql table via powershell
I've created a SQL Server database with a simple table on my local machine. I try to query some information from this table. Here is my code:
$connection= New-Object ...
