Database

Database

Hello,

I have a server with Windows 2003 Server installed and inside the server, I installed several applications and one of them is MS SQL Server. I'm using MS SQL Server for a custom desktop application that I developed and for some time everything works great with no problem whatsoever.

Lately, I'm considering changing the database from MS SQL Server to MySQL so, I can access the database from around the world. Unfortunately, it means I need to adjust some things to make the desktop application work fine using MySQL like when it used MS SQL Server for the database. Using the same desktop application I can access and manipulate databases inside MySQL without having to develop new applications for it.

  • 987 views
  • 1 answers
  • 24 votes

Hello,

I am a student. I am naive in the computer world as well as software section. Now a days I am studying Microsoft SQL server. I am using Microsoft SQL server 2005 edition. I have a database mdf file and log file. I need to attach those files again in the database. As my SQL server is new, this database is not there. But I don’t know exactly how to attach a database.

Can anyone tell me?

Help me please.

  • 1088 views
  • 1 answers
  • 24 votes

Hello!

The following databases are running on my computer:

Informix DNS 10.00FC8 with Linux RedHat

MS SQL Version 2008 Express running on my Windows 2003 R2 SP2

And lastly, I am running IBM client Version 3.5 TC4 when connecting with Windows Server to Linux. I configured the Informix and linked the server to SQL with the help of OLE Database for ODBC. It was working but it failed on completion. I need to use the OPENQUERY in SQL to make it work flawlessly. I want to know if it is just fine to and if OPENQUERY is working better than selecting it in the simplest way.

  • 1741 views
  • 1 answers
  • 22 votes

I've made a little progress with packaging and making a runtime file for my Access 2007 app using Microsoft info pages. But for some reason, I'm getting a blank application when I test-package it and then tried and run the file.

  • 5626 views
  • 2 answers
  • 22 votes

Hey guys,

I have deleted an oracle data file. But it seems I couldn't completely remove it because when I'm trying to make a new one with the same name oracle says: "data file already exists !!!" What to do?

  • 1046 views
  • 6 answers
  • 13 votes

Hi all,

I am having problems removing a data file in oracle database. I removed it but when I tried to make one with the same name then it said that "data file already exists".

But how it can exist when I personally deleted the file?

Can anyone help me?

  • 2146 views
  • 1 answers
  • 22 votes

I have installed MAMP yesterday, and had it working great. Was very impressed. Then today I got to start working on a new template and I got the Error Message: 

  • 2751 views
  • 2 answers
  • 24 votes

Can any one help me altering an Oracle table? I have made a table and it has some data in it. But unfortunately, I forgot to make any primary key on that table. Is it possible to make a primary key now? I don't want to delete my previous data, that is already in the table.

  • 1619 views
  • 6 answers
  • 22 votes

Our company uses Microsoft SQL Server 2005 as the database management system. We have several databases hosted on it. Everyday we create a scheduled backup using the Microsoft SQL Server Agent. The backup runs at 7 pm every night. Each backup runs up to around several gigabytes. We need to retain only 2 days backup on the production server and overwrite the older files. How do I go about doing a rolling backup for databases in Microsoft SQL Server?

  • 2840 views
  • 8 answers
  • 24 votes

Hello,

I am using Microsoft SQL Server 2005 edition. I want to restore a database. I have the backup file for my desired database. As i am new to SQL Server, I can not restore this back up file as a working database. I need help to restore this.
 
One thing should be mentioned is that the restored database must do as it did before. Can anyone tell me how can I restore the backup file as a database in Microsoft SQL Server 2005?
  • 959 views
  • 2 answers
  • 21 votes

Latest Articles

Free cloud mining is coming! RICH Miner launches mobile mining, everyone can earn cryptocurrencies

RICH Miner officially launches a new mobile cloud mining application, subverting the traditional mining model! No need to buy mining machines, no technical experience required, just a mobile phone, global users can start the...

Rokid Max 2 Review: I Tried AR Glasses So I Could Watch Netflix in...

I’m not a tech geek. I don’t keep up with every new gadget launch. I fly a few times a year, watch many movies on my phone, and live in a small apartment where...

Top 10 Technology Trends For 2025

With 2025 just around the corner, it is time to start thinking about what tech trends will be coming our way. Tech moves at a rapid pace. Some things may pop up next year...

Latest Blogs

Top 10 New Laptop Entrants That Shook The Public

The finest laptops are powerful enough to do your daily tasks, comfortable enough to use all day, and power-efficient enough to ensure you don't run out of battery power unexpectedly. Of course, all these...

10 Facts About The Dark Web

Before getting into knowing the facts, let’s have a brief about the Dark Web. The dark web is the data of the World Wide Web that is accessible only through special software, combinations, or...

Top 10 Latest Steam Cleaner Machines

While looking for a chemical-free way to clear and purify both durable and low grounds in your home, a steam cleaner is an excellent solution. With a spurt of superheated steam, this cleaning equipment...

Latest Tips

Top 10 Internet Monitoring Software

Internet monitoring software keeps a log of all internet activities. You can install this type of software on your computer remotely or by the administrator. An operating console controls this software. This type of...

Top 10 Best Partition Manager Software

A Hard Disk Drive is usually partitioned into various smaller drives for optimization. A partition manager helps make this process easier and more efficient. Here, let’s discuss the top 10 best partition manager software. 1....

Top 10 Best Online Music Production Software

Music production is the initial stage of any song. Music production can be done either in studios or at home using an online music production software. Here, let’s discuss the top 10 best online...