• 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:
  • 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,310 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:
  • How to read a table in SQL database

    How can I read a table in a SQL database?

    vSphereadmin5 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,310 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:
  • Database replication in SQL Express

    Please suggest me some way about how to replicate data at regular intervals among two or more systems having its own SQL Express database.

    jyotikumari275 pointsBadges:
  • What’s the best way to create a cloud-based SQL database?

    We have a website that's currently being hosted on Amazon S3 and it's working fine. But we have run into a problem with our data (and it's static). So the next step we're looking at is to create a SQL database in the cloud so we can store user data. Could we possibly do this through Amazon AWS or...

    ITKE351,310 pointsBadges:
  • SQL 2000 migration to SQL 2005 – need to preserve user security

    Hi, I have a customer that is planning on moving to new hardware and performing a SQL upgrade (2000->2005).  I know that our application (FileNet Image Services) is sensitive to what we refer to as an "orphaned" database.  Our app stops working if a database is simply detached/attached to...

    Vitomizer5 pointsBadges:
  • Database Creation

    Recieving an error for database creation permission for sql 2005. Please advise

    Praya5 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