• Backing up and copying a database across SQL Servers

    I have SQL Sever 2005 on both servers A and B, although I do not have SQL Studio Manager on server A. I would like to backup a SQL database from server B onto server A, and then copy it over to server B and restore it to the same database. How would I go about doing this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I connect DB and input values in stored procedures using VBA

    Hi all, I'm using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me.

    Jprpvk5 pointsBadges:
  • Conversion of SQL Server 2000 to iSeries DB2 V6R1

    Hi there. We are converting SQL Server 2000 to DB2 on iSeries V6R1. We’re ok with the JDE tables and views, but are having difficulty with the non-JDE tables, views, and stored procedures. Is there a tool or something that could help us? Thank you.

    Tprusko5 pointsBadges:
  • Code Impact Analysis Tool

    Hi, Need a tool to do the impact analysis of .net/java/com code files and should produce the matched code/classes/objects/methods/references etc. for a particular database hit (stored-procedure or select/insert/update query)

    Kvrao5 pointsBadges:
  • Dcom Error – event id 10003.

    I am getting Dcom Error,in eventlog file. its appearing frequantly. how to solve this problem, please anybody help me.this is what showing in the event log. Event Type: Error Event Source: DCOM Event Category: None Event ID: 10003 Date: 9/4/2004 Time: 8:50:51 AM User: N/A Computer: Database server...

    Hfakruddin0 pointsBadges:
  • How do you create stored procedures in SQL Server 2000?

    How do you create stored procedures in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Inbound and outbound interfaces in SAP

    I have been asked to find out the list of Inbound and Outbound interfaces in SAP and their structures. Basically we will try to write a module which can send data in the SAP required format and also receive the data from the SAP in their format and load it in our SQL Server table. Is there a way I...

    rajivk5 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:
  • Get data from one MySQL datebase server to another in real time

    Hi, I am using MySQL database. I want to create one more database which I want to get updated in real time from the remote MySQL database server. Kindly help me in this. Thanks

    Chetanm145 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:
  • Bundling SQL Express Edition

    Is it free to Bundle the SQL Express Edition within our Product or along with our Product CD/DVD?

    Rajeshbs45 pointsBadges:
  • How to check browser activity?

    Hi, I'm working a project, in that I'm storing login, logout time. What if i don't click logout button and close my browser, or somehow my system shutdown.I cannot store the logout time, so that my program will be in error state. Tell me how to get the logout time when my programmer didn't click...

    Karthij5 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:
  • How to upload data from Excel into SQL Server 2005

    Hi, Please tell me, how can I upload data from excel into SQL 2005 Thanks & regards, Ambrish Srivastav

    Ambrish 82310 pointsBadges:
  • How can we reindex a SQL Server 2000 database?

    We have a SQL Server 2000 database that has never been reindexed. Do you have any suggestions? Is there a link to a step-by-step process for SQL Server database reindexeing you can share?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Clustering in SQL Server 2005/Windows Server 2003

    Does clustering become Active/Active when using SQL Server 2005 and Windows Server 2003?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Sql Server 2005 ensure columns sum within a table

    How can I ensure the total sum of 5 columns within the same table equals 100 during insert or update in SQL Server 2005?

    Timmytong5 pointsBadges:
  • How to implement an Entity Relationship Diagram into a working database?

    I need to implement a ER diagram into a working database. I'm hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement "Is a" relationhips, how to implement...

    Obhasha0795 pointsBadges:
  • External Table / SQL Loader

    Hi, We are using this new SQL loader for a month now and it is working fine, but suddenly when we upload new csv files from the client we received this error message when i select the table it gave me this message: ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-29400: data cartridge...

    External10 pointsBadges:
  • Implementing Encrypted SQL Server Database Columns

    This is the problem I'm facing: The database (SQL Server 2005) holds more than 5 million customer records. These records contain sensitive credit-card information that must be encrypted. Implementing an application-side encryption solution involves VB6 and .Net technologies. How to achieve a...

    Kansai5 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