26.7 C
Chennai, India
Tuesday, January 25, 2022 03:34 PM
MS SQL Server

MS SQL Server

  • 2317 views
  • 1 answers
  • 20 votes

Please help as I am trying to set up SQL but been getting an error that says: "MsiGetProductInfo failed to retrieve ProductVersion for package with Product Code =__. Error code:1605". I don't know what's wrong because it's a genuine software.

  Did they give me the wrong one?

My client is waiting for me to set this one up for him and I only have few more days to go to perfect this. I honestly have no idea because this is the first time I encountered this error. Hoping for your kind consideration to answer this.

Thank you so much.  

Christine. 

  • 2952 views
  • 2 answers
  • 20 votes

Guys, please help me. I am new to PHP programming and I'm having a hard time in connecting the database to my PHP site. Please help me with this.

  • 1892 views
  • 6 answers
  • 13 votes

Hi to all,

I am an IT student. I just started using MS SQL Server. I am using 2005 edition of MS SQL. As I said I am new, so I am not familiar with all the tools. I created a database in the computer and I need to create the same database in another computer. So I need to take a back up of the existing database. I tried but I failed to create a back up.

I need some help.

  • 1444 views
  • 1 answers
  • 13 votes

I am operating a Windows 7 Home Premium OS with successfully installed MS SQL Server 2005 and Netbeans version 7.0 beta. Everything is working properly without any problem in software. I want to develop a Java project which is to be connected to a MS SQL Server database.

I am facing a problem that the Netbeans IDE is unable to connect with MS SQL Server database. The databases Node is shown in the Services Window when I click it, SQL Server is not shown but I can see Java DB database. I have registered the JDBC driver for MS SQL Server with Netbeans, but still I don't know how to connect to the database.

  • 3945 views
  • 1 answers
  • 22 votes

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.

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

  • 1080 views
  • 1 answers
  • 24 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?

  • 2822 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?
  • 952 views
  • 2 answers
  • 21 votes

I am attempting to create an Index on one of my tables. I keep getting "operation timed out". Why is this?

  • 1800 views
  • 8 answers
  • 23 votes

Articles

Blogs

Tips