• Insert for a table

    I have a table which consists of lakhs of records and itemnumber is one of the column.I want to insert those records into the same table but with different new itemnumber from another table.what is the best way of doing it?

    Vishy5 pointsBadges:
  • ODSObject to Infocube

    TransactionData Loading from ODSobject to Infocube Manually from FlatFile

    ITSME15 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs In Sql-Server 2005

    Hello All, I want to send email alert when aotomatic failover occurs in in Sql-Server 2005. I mirrored my database using High Safety with Automatic Failover option.

    ITHULK10 pointsBadges:
  • Trigger programs

    In a trigger program, is there a way to retrieve the program name that initiated the event?

    mcg15 pointsBadges:
  • Trouble configuring two Cisco 1310 for building-to-building Wi-Fi

    I tried to connect 2 Cisco 1310 for a building to building connection via Wi-Fi. I used the following sample configs found in this tip, called Configure Cisco wireless bridges for point-to-point networking. One the Cisco 1310 Access Points/Bridges starts up and the connection stays up for a few...

    NetworkingATE1,545 pointsBadges:
  • Can I update multiple Cisco AP’s and switches automatically?

    They are All Cisco. APs 1200 series and switches from 6509, 4506, 4006 to 3524. I have SO MANY of them and need an easier way then updating them manually. They all use SSH

    Karl Gechlik9,860 pointsBadges:
  • equivalent for crosstab query

    Is there any function in MySQL that can create a query similar to crosstab query in MS Access???

    Sgheorghian5 pointsBadges:
  • MS Access DB – Query

    I have an Access database this is in place for in person registration at a convention. The registration system uses a few data fields then prints a report. I can't get the report to work the way that i want it to. I need the report to pull the record that i just entered via query (or whatever if...

    Phixious15 pointsBadges:
  • Setting the ODBC in SQL Server 2005

    I use SQL Server 2000, and I am in the process of upgrading to SQL Server 2005. However, when setting the ODBC, the database option for SQL Server 2005 does not appear. Is there something I have to set first before the ODBC?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Error in SQL coding

    I am having a specific problem with coding in SQL, and I was curious if you could give me any advice. I have entered this code: CREATE TRIGGER UpdateAfterPayment On SupplierTransactionDetails For Insert, Update, Delete As Update S If i.DebitValue>0 S.Balance = S.Balance + i.DebitValue else...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Move/Copy System DB’s to new server in SQL 2005

    Trying to move system DB's to brand new server (really virtualized server). Server names are different. Any suggestions would be appreciated.

    Seandon5 pointsBadges:
  • Developer 10g

    I want to connect my forms and reports of developer 10g to other data sources. e.g. Sql Server. How can i connect to it through odbc?

    Kelp115 pointsBadges:
  • Printing a report in varying pagesizes

    I have a customer who want to the dot matrix printer to stop where the invoice ends.. it could be juz 3inches for some bills and A4 for some others..can anyone please tell me how to set the pagesize through code in VB6? I tried using the Printer.PaperSize property.. but no effect..anybody got a...

    DotComGuy875 pointsBadges:
  • VBA-question

    How do I transfer 30 text files at a time into my access DB? I was able to get the files, but it did not transfer into the database. Thanks.

    Bonjour15 pointsBadges:
  • Deleting Terminated Users from ACLs

    We have databases that include the names of teminated users in their ACLs. We think this happened because we had the wrong server identified as the admin server on these databases, or on templates that control them. For databases controlled by templates, if the users are defined in the template ACL...

    Brooklynegg3,845 pointsBadges:
  • send data from sqlserver to ms access

    i am a biginner to vb.net and i want to transfer my data in sqlserver to ms access.please anyone can help me to this regard .

    Usjpcha10 pointsBadges:
  • Creating Alert/Email when Automatic Failover Occurs

    Hi All, I am novice database administrator. I mirrored the database successfully. Now i want to received an Alert/Email when the failover occurs On my principal server. I will be very helpful if you provide me explanation in very short way or step by step. Thanks in Advance Best Regards Prasanna S...

    ITHULK10 pointsBadges:
  • Efficient storage of survey answers

    We have a website that asks the user a set of questions. The answers are curently stored in SQL database using a table that has: PersonID QuestionID AnswerID Value So one answer to one question is stored in each record. Some questions have more than one possible answers, so all answers to a given...

    Eyoder5 pointsBadges:
  • DB Tracking

    I need to track who made changes to a table. can audit do this if so how ?

    IT400EPP5 pointsBadges:
  • Mainframe Career – is it possible for me?

    hello, I have been working for a MNC in India for the past 2 years.My nature of Job includes creating SAS programs and using JCL to run this SAS and get reports or other stuff from the DB2 databases or files.I also write simple SQL queries for DB2.I am right now in a stage where i need to decide...

    Richard19835 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