Operating system produced by Microsoft. Windows is produced in various desktop and server versions.

learn more… | top users | synonyms

1
vote
1answer
243 views

Reconciling dm_os_windows_info windows_sku values, gathering same info from pre SQL Server 2008 R2 instances

I'm developing an inventory system for RDBMS deployments. I'm starting with SQL Server, and later will be pulling in info for Oracle & other RDBMS deployments. When you query [dm_os_windows_info] ...
1
vote
1answer
1k views

Failure to detach database

I used sp_detach_db to detach SQL Server 2005 databases. This works properly in Windows XP and Windows 7. However, the same fails in Windows Server 2008. The error message states: The process ...
1
vote
1answer
759 views

Change root password of mysql database

This could be a Rookie problem , but it seems that i am not able to solve it. I have MySQL server installed on my windows machine(MySQL 5.5) under the Admin username root. Some How i lost the ...
1
vote
2answers
465 views

How to automatically grant permissions to application created databases in SQL Server 2008 R2?

So I have an application that automatically creates a new database after the database it is currently in reaches a fixed number of rows. I need to be able to automatically assign a user within the ...
1
vote
1answer
177 views

db2 connecting to a db via alias and storing user name and password

I created a TCP node and I catalogued a db into it. The catalogued db needs user name and password to be accessed. Is there anyway I can store username and password in the cataologue (or other way)? I ...
1
vote
1answer
211 views

Restrict access for Windows administrator in PostgreSQL

Is there a way to protect PostgreSQL from user with Windows administrator rights? Like this question but for Postgres.
1
vote
2answers
423 views

Performance Counters for SQL Server Related to iSCSI Disk Access

I am planning to my SQL server databases (plus TLogs and TempDB) to a new LUN on our iSCSI SAN. The current LUN's used by these of these files are on their own two disk RAID 1 disk group and I'm ...
1
vote
2answers
911 views

“In Use” memory on a SQL Server box

I have a SQL Server 2012 database server with 64GB of RAM. A process called DataPumpService runs on the same box and loads around 400 million records from 2700 flat files. I want to understand what ...
1
vote
2answers
2k views

Why Oracle 11g installs in folder C:\app\<name_of_user>

Just curious, now Oracle 11g installs by default in folder C:\app\ Why? Before, Oracle was installed by default in folder C:\oracle... Why now is created "app" folder?
1
vote
3answers
2k views

Workarounds for setting default schema for domain group?

I am currently working on a project for a client, they have asked me to change the database from Oracle to SQL Server. So we migrated the database across to SQL Server 2008, when this was migrated ...
1
vote
1answer
638 views

Enterprise Manager Database Control on host with an underscore in it's name

I know it sounds awkward, but Enterprise Manager is refusing to be set up because of an underscore in the server name: C:\>emca -deconfig dbcontrol db -repos drop STARTED EMCA um 30.05.2012 ...
1
vote
2answers
1k views

MySQL Database and Table Loss

I have installed mysql and XAMPP on my system. I wanted to remove the mysql service of XAMPP. After removing it, I tried to install the new service for mysql using "MySQLInstanceConfig.exe". but now I ...
1
vote
1answer
3k views

High PageIOLatch_SH Waits with High Drive Idle times

We are experiencing high volume of PageIOLatch_SH waits on our database (row counts in the Billions). However it seems that our drive Idle time Percentage hovers around 50-60 percent. CPU usage is ...
1
vote
1answer
4k views

How to upgrade MySQL to newer version on existing database

I am having data of 20 GB with MySQL version 5.0.24. Now I want to update MySQL to newer version 5.5.16. We can do it by taking complete database backup and uninstall old MySQL and install new MySQL ...
1
vote
1answer
3k views

How can I configure PostgreSQL 9.0 to start automatically under Windows XP?

Yesterday I installed PostgreSQL 9.0 on Windows XP, and after the installation the DB was running. After booting the system this morning, the data base server did not start automatically. How do I ...
1
vote
1answer
153 views

db2pd: Database mydb not activated on partition 0

As a user with DBADM privileges I enter db2pd -db mydb -locks showdetail from the DB2 CLP. The command then fails with message Database mydb not activated on database partition 0. Option -locks ...
1
vote
1answer
132 views

MySQL Shutdown on Windows

Folks, I am running MySQL on Windows8 for my personal (casual) use. I am trying to determine if there is a way to automatically and cleanly shutdown MySQL whenever I shutdown my Windows8 computer. ...
1
vote
1answer
4k views

mysql replication on windows server

How to setup replication(Master/slave) in MySQL 5.6 while both servers are windows based? All the things i have fond are Linux based replication. kindly someone help who experienced replication with ...
1
vote
1answer
344 views

Postgresql: When using SSH tunnel, I receive the fe_sendauth: no password supplied error

I am SSH Tunneling to my postgreql server. I have previously successfully configured 9 + win XP dev PCs to connect to this postgresql server, those PCs still connect successfully. I am now setting up ...
1
vote
2answers
272 views

mysqldump with automatically generated export name

When I do database dumps through MySQL WorkBench it picks a filename for me which is the current date (YYYMMDD). Now, I want to do this in a batch file since I want to make weekly dumps automatically ...
1
vote
1answer
516 views

MySQLdump on specific db date

I'm new in here and i don't really know where to start but here is my concern. I need to backyp a MySQL DB running under windows once a week. For e.g every friday i need to backup and transfer to ...
1
vote
1answer
575 views

Determining the full postgresql size on windows

While opening the Programs and Features tool panel on my Windows 7 (64-bit), I found that my postgresql (8.4) install was taking 108 GB. I do not use postgresql myself, I just use a tool that need a ...
1
vote
1answer
774 views

Connect to SQL Server using OLEDB or ODBC?

We have a desktop application written in Visual Basic .NET. One our clients needs to use ODBC instead of OLEDB to connect to the SQL Server 2008 R2 Database. The company has several databases ...
1
vote
1answer
1k views

Connection to MySQL Remotely

I want to connect to MySQL Server hosted on a Linux Machine from my Windows Machine using Command Prompt with the following command: prompt>mysql -u root -p -h remote_hostname Connections, ...
1
vote
2answers
972 views

Which oracle should I download for windows 7 x64?

My os is: windows 7 x64 I tried to download oracle and install it in my computer, but I have downloaded 3 different oracle releases(including oracle 11G), they can't be installed. They reported ...
1
vote
1answer
33 views

Cannot delete MySQL trigger. Appears in information_schema, but no .TRN file

I have a MySQL database with a few tables and triggers. A process was trying to drop one of the triggers and it failed with the following error: Malformed file type header in file 'trigger_name.TRN' ...
1
vote
2answers
97 views

MySQL 5.7 - Where is the mysql_secret file on Windows 7?

I've just installed a copy of MySQL 5.7 for testing, and I love the fact that it now only creates a single root account, and puts the password into a file called .mysql_secret. There's just one ...
1
vote
1answer
30 views

MySQL InnoDB restoration from hardware failure

One of my server went down due to old hardware failure on a old Dell server that's over 10 years old. I was able to recover the files and got it to a local machine. I want to restore a MySQL instance ...
1
vote
1answer
60 views

Why MySQL init_connect variable gets updated after rebooting?

After SET GLOBAL init_connect=''; query everything works fine. However after rebooting the server or restarting the MySQL service it updates the init_connect value to some random value (OÇÿOÇÖ). Do I ...
1
vote
1answer
566 views

MySQL service stops after trying to grant privileges to a user

I am using MySQL 5.6, I was trying to create a super user for specific database but I got ERROR 1396 (HY000): Operation CREATE USER failed for 'superuser'@'%' Then I thought maybe there is already ...
1
vote
1answer
332 views

How to take physical backup of MYSQL database

I am trying to find out some tool which can take physical backup of MYSQL database. Like mysqlbackup but it is not open source. There is mysqldump but i want to take physical backup. Can someone ...
1
vote
1answer
973 views

mysql server cannot launch in windows 7

I have been using MySQL as a windows service successfully on my windows 7 machine for perhaps a year. It has always worked fine. Here are the steps which I think caused it to no longer launch: ...
1
vote
1answer
2k views

Inserting empty string on Windows MySQL doesn't use default value

Why inserting '' on a column with default integer value on MYSQL/WINDOWS produces ERROR 1366 (HY000): Incorrect integer value: '' for column 'id' at row 1 The query is: insert into test2 (id,test) ...
1
vote
1answer
133 views

MySQL database stops working after log enabled

I have this strange issue. I have MySql workbench, which I use to write queries for MySQL database (xampp 3.2.1). Everything works fine, but recently I found myself having to profile the queries my ...
1
vote
1answer
97 views

Immigrate to file-per-table mode in MySQL

I have 20 MySQL databases and in each there are about 20 tables. All the data is saved in a file called ibData1. Now I discovered about the file per table mode but if I change the value in the my.ini ...
1
vote
1answer
492 views

Connecting to a MySQL database on Mac from a VMWare fusion Virtual Machine

I have MariaDB (5.5.34-MariaDB) installed on a Mac (OS 10.8.5) I can connect to the database fine locally (127.0.0.1) on port 3306. But when I try to connect to the database from windows 7 64bit ...
1
vote
1answer
3k views

How to grant rights for a user in DB2 Express?

I have installed DB2 Express on a PC. My user is not an administrator user, however as far as i know, it is possible to grant a user rights, so he can create/delete/modify a database. I have ...
1
vote
2answers
322 views

Why does MySQL + Windows Server = crashed tables periodically?

Windows Server 2008 R2 x64 MySQL Server 5.6.14 x64 Is anyone else having an issue in where some tables are marked as crashed on a Microsoft Windows server? We have a couple of Windows servers (not by ...
1
vote
1answer
64 views

Poor query performance in MySQL

I have a 10 million record table in a MySQL 5.5 InnoDB. It's running in a 16GB RAM server with good CPU and fast HD. When I run the following query SELECT DISTINCT knowledge_id, ...
1
vote
2answers
784 views

Need to install Oracle Express 11g Release 2 on a Windows 7 64-bit laptop

I need the Oracle 11g Release 2 sample schemas (HR, OE, etc.) in order to do most of the available online tutorials. I was hoping to install Oracle Express Edition on my Windows 7 laptop to get ...
1
vote
1answer
358 views

Oracle Express intermittently stops responding, requiring a OS reboot to fix

I've been having an issue with Oracle XE the past 2 days and it's really been making me pull my hair out. There seems to be no rhyme nor reason why this happens, or when it does, but it happened 6 ...
1
vote
1answer
130 views

MySQL-test suite not included with windows mysql installer?

I noticed in my MySQL folder there is no mysql-test. Why is that? Is it possible to add it?
1
vote
2answers
7k views

MySQL Installation error: Unable to update security settings

I tried to configure MySQL server 5.5 on Windows and this is what I get mysql-server-5.5-winx64:56 - Attempting to update security settings. mysql-server-5.5-winx64:100 - Unable to update security ...
1
vote
1answer
125 views

Does Microsoft Security Bulletin MS11-049 affect SQL Server 2008 SP3?

The security bulletin does not list SQL Server 2008 SP3 under affected software but it came out prior to that service pack. We are running SP3 but this issue is still showing up on a vulnerability ...
1
vote
1answer
313 views

Correct Selection of SQL server instance db owner login name

I am attempting to connect RSA Archer (5.2) to an instance of SQL server 2008 r2 on WS 2008 R2. When Archer attempts it's initial connection I get - The ConnectString property has not been ...
1
vote
2answers
3k views

MySQL not responding, Writing to net status

I just had to reboot MySQL to regain access to some of my website. It had under 300MB of RAM used. Another product was working fine though, accessing it's own tables which are InnoDB. Here's the show ...
1
vote
1answer
11k views

Trying to install SQL Server 2008 Management Studio Express

On a Wndows Server 2008 R2 64 bits, I installed Visual Studio 2010 Express, which installed a SQL Server 2008 Express: Trying to install a SQL Server Management Studio, first I'm required to ...
1
vote
1answer
434 views

Mysql 5.0 on Windows 2008

I have a problem with MySQL on Windows Server 2008 x64. This is the first time I've installed MySQL 5.5 with performance problems. I decided to go back to the older version that worked well with ...
1
vote
1answer
522 views

Can I install sql server on Win XP machine with user profile on D drive?

Is it possible to install sql server on a windows xp machine where the user profiles are created on a non system root directory, that is, on D drive rather than C drive? I am trying to install SQL ...
1
vote
1answer
757 views

Tutorial for installing and setting up 'streaming replication' with PostgreSQL on Windows XP

Please refer to the diagram in the link below. While looking at my goals. http://i.stack.imgur.com/GkVWb.png GOAL: Get PostgreSQL 9.1 running on 3 terminals on the 'on site' location. 'on ...