• Upload Excel to SQL Server Table

    I have an Excel spreadsheet with 3 fields being used. (1) Material x(30) Key (2) Description x(30) (3) Extended Description (text) I want to create a table that I can match to an existing table where the key is the Material and update the description and extended description on the existing table....

    WorkAround5 pointsBadges:
  • TVCPL Table

    I get this error when trying to create a return delivery in SAP. Copying is not possible because an entry is missing in Table TVCPL: ZRMC

    boocrews5 pointsBadges:
  • I need to reboot my OS on my Windows XP Home edition desktop

    Every time I turn my old Dell Dimensions desktop on, it reads writes/read error at checkpoint [PnP1]. I need a free copy of reboot disk for Windows XP Home Edition. Does anyone have one? Please help.

    nowl0075 pointsBadges:
  • Error message 503 outlook

    I periodically get error message as above when I use my contacts list or sometimes when i respond to e-mail. Error message 503 Valid RCPT command must preceed data

    shpdoc5 pointsBadges:
  • Why did my screen suddenly go dim and how can I fix it?

    While using Scribus self-publishing website my laptop screen went quite dim.  Restarting did nothing.  Windows 7 system

    TomBanfield5 pointsBadges:
  • What is calibration?

    What is calibration in Nokia Siemens?

    basu5 pointsBadges:
  • Drawing with hyperlinks

    I have a floor plan diagram that I would like to set up so when I hover over a location it will hyperlink to another sheet in the workbook.  Does anyone know how to do this?

    petercj5 pointsBadges:
  • Microsoft Dynamic question

    I need some help (I've tried to answer this question so many times but can't). A device connected across the imput of an S-R flip-flop to insure complementary inputs is? Expand terminals are used with logic gates to increase the? If the signal input to a sense amplifier exceeds the reference...

    gates5 pointsBadges:
  • ORA-01722 invalid number where clause in update statement. I want to log this error in error log table

    Oracle ora-01722 invalid number where clause in update statement. I want to log this error in error log table. How can i log?? Below is my Update statement, here empid is number. UPDATE SARVESH_TEST_ERR_TB SET empid = empid WHERE empid ='aaa' LOG ERRORS INTO SARVESH_ERR_LOGS_TB ('Error while...

    sarvesh02025 pointsBadges:
  • Install SQL Server Client Components on Windows XP

    I use my SQL Server 2000 Developer Edition disk to install client components on my Windows XP. I insert the CD into the drive. I click SQL Server 2000 Components on the first screen. I click Install Database Server on the next screen. An InstallShield icon appears for a few seconds and then...

    SteveInfoTool5 pointsBadges:
  • Differences between SQL Server 2005 Standard Edition and Enterprise Edition?

    What is the difference between running SQL Server 2005 Standard Edition and SQL Server 2005 Enterprise Edition?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to check Max Worker Threads in SQL Server 2005

    We've had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question

    BrentSheets6,875 pointsBadges:
  • Performance issues with a large table in SQL Server 2005

    I have an application that is managing inventory for a company that has multiple locations. Items are being inserted into an inventory table roughly every 5-6 seconds from three locations. At the same time, this company is packing inventory in boxes in order to fulfill orders. I have a table setup...

    Thecoolestguy5 pointsBadges:
  • ‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′

    How do I convert ISO dates of '0001-01-01' to SQL Server 2000 Datetime format?

    Jld10 pointsBadges:
  • Backing up a SQL Server 2000 database through VB.NET 2005

    How might I backup a SQL Server 2000 database through VB.NET 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server trigger, insert result of multiple where clause into a variable

    Hi All, I have a select statement that stores the result in a variable,this works fine if there is only one condition and field in the clause.How do I go about it if there is more than one? For example (Working one) SELECT @Variable = (SELECT [Field] FROM [Table] WHERE [FIELD] = Value) But I am...

    Jacquesvdm20 pointsBadges:
  • Backing up SQL Server 2005 databases to a tape drive

    I am currently running SQL Server 2005 and I’ve set up a maintenance plan that backs up my databases to the disk. I'd like to change that and backup my databases to a backup tape drive that's attached to a backup server. Can this done, and if so, how?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Script to restore database permissions during a migration to SQL Server 2005

    We are in the process of migrating from SQL Server 2000 to SQL Server 2005, and I'm searching for a script that can transfer and restore the database permissions of all accounts from SQL Server 2000 to SQL Server 2005. I used sp_help_revlog to restore the logins, but I still have to restore the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to add row to a SQL Server table where username can be inserted

    Say I have a table called "Customer" (SQL Server 2005) and 10 users have access rights to this table. If I want to add a row to this SQL Server table to insert the username who initially modified this row, how can I accomplish that task?

    SQL Server Ask the Experts2,585 pointsBadges:
  • vb.net 2008 and sql server 2008

    How can i connect to the sql database using the app.config file over a network and also have the ability to edit the app.config during installation or when the application is installed on another machine on the lan

    Semauel8515 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