• Insert values into database from form VB.NET

    Hi guys, Having a bit of trouble with inserting values that i have in my form into my SQL database. Basically it supposed to calculate a customer who borrowed a DVD or CD. I select the date that the customer brings the returned item by selecting a datepicker. The calculation works fine, but i want...

    Darthswift0040 pointsBadges:
  • SQL Server 2005 database conversion

    Hi, we plan to migrate SQL Server 2005 from SQL Server 2000. We have a database with average size of 12GB. Can any one please let me know how to convert our database from SQL 2000 to SQL 2005.Thanks in advance.

    Anto5 pointsBadges:
  • Exporting a SQL database to MySQL

    I have a MS SQL .BAK database that I need to convert to MySQL. I was able to import the database but not actually export to MySQL. A friend of mine told me to use MySQL Migration Toolkit but it's been replaced by MySQL Workbench. Can I use this tool to migrate the database? Or is there another way...

    ITKE351,880 pointsBadges:
  • Delete all tables in SQL Server database?

    How to delete all tables of a database in SQL Server?

    Prcvjr220 pointsBadges:
  • How to read a table in SQL database

    How can I read a table in a SQL database?

    vSphereadmin5 pointsBadges:
  • Setting database security to prevent restoring databases on other SQL Servers

    Within a database in my SQL Server, I am able to control users from Alter Table and Alter SP, and a strong ‘sa’ password is also created. When I login to the backup of that database with a backup operator ID, the backup operator is able to restore the database, and his and others’ rights are...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Create A Fixed Text File From SQL DB Table

    Hello programmers. After doing much research I am unable to resolve how or where to custom format each field of my SQL table output into my text file. Can someone help me with enhancing the below vb script? I need to reformat certain values. Do I do the formatting in the Dim section or in the if...

    Ilfoprog50 pointsBadges:
  • How to Display Japanese character in Crystal Report 8.5

    Hi, I've some data stored in Japanese language in SQL Server 2005 database using nvarchar datatype. When I execute store procedure in SQL Server, it's showing japanese character properly in SQL server. However, when I'm trying to display data in crystal report 8.5, it's showing ????? character....

    Kaushalp50 pointsBadges:
  • Can somebody provide me SQL questions based on various situation?

    I have started working on SQL DB. During an interview question, there were various situations given through which we need to write some queries. Questions/ Situations where UNION , ORDERBY , JOINS , DATE Functions and others are used. Can somebody provide me SQL Join situation questions for...

    Mayurkhe295 pointsBadges:
  • Database and Log file location

    How do I change the default location for database and log files during a SQL 2005 installation?

    Quincy185 pointsBadges:
  • Store and retrieve image using SQL database

    How can I store and retrieve images using a SQL database?

    RAJA12us285 pointsBadges:
  • Connectionstring for paradox db password protected

    Hello everybody, Searching for answers I've found this interesting page!! I've created a SQL query to a paradox database, it works fine with a non- password protected table: Provider=MSDASQL;Persist Security Info=False;Mode=Read;Extended...

    Starbasestarfleet20 pointsBadges:
  • Copy a SQL Binary Large Object (BLOB) from one database to another

    Is there  a way to find out the name of a Blob stored in a database. I am trying the code below and apparently the name is not correct. SQL> Declare   2   tpsr Blob;   3   spsr blob;   4  Begin   5   Select '8502' into tpsr from ca90joetmp.spec_form_psr where spec_form_id = '90710';...

    Bobf15 pointsBadges:
  • Archiving Exchange 2007 in a SQL database

    How do you set up an SQL database/server to receive and store archiving/journaling for exchange 2003/2007 email.

    Cmoney5 pointsBadges:
  • SQL Database is corrupted

    Respected sir, Unfortunately the hard disk of my system is damaged, now I recovered my database. but it cannot be attached again to SQL management studio 2005. The error is myfile.mdf is not a primary database file. (SQL server, error 5171) Please sir help me.

    shampur5 pointsBadges:
  • VB.NET code to search if a record already exists or not

    Hi! I need a fresher..I want a VB.net code to search record from SQL database table by using two fields of table as a condition i.e client name and client code before saving any new record and if record already exist in table it give me message for that. I'm sending you the code. Please help...

    Sachinm10 pointsBadges:
  • Connecting a SQL database to Lotus Domino Designer

    I've been creating a Lotus Notes application that have dynamic combo boxes. Those boxes are going to be retrieved by selecting from a SQL database. Since I'm pretty new to Lotus Domino, could someone help with connecting my SQL database to Lotus Domino Designer? Thanks.

    ITKE351,880 pointsBadges:
  • It seems our SQL database is corrupted

    Hi, Is there a way to completely check a SQL-Anywhere database (5.5.05) integrity? "Validate" won't help: we had databases that were broken but "validate"  always told us that everything is o.k. :-( I had the idea to simple read every record in every table (first "select count(*) from...", second...

    basrhaidi5 pointsBadges:
  • SQL database recovery from corrupt database file!

    Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which contained copies of my SQL Server databases. A few days ago I lost some part of my data due to accidental deletion. I backed it up, so I tried to restore the database from the .bkf file. The problem comes...

    chengchong365 pointsBadges:
  • Security issues for MySQL in a cloud environment?

    Hi everyone! In general, I've been asked by my manager to find out about running a MySQL DB on a cloud -- has anyone done this, and what do you think are the security issues that can come up when doing so? More specifically, IT has questioned me about how auditing would work on a cloud, and what...

    MillyT5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following