Questions & Answers

  • Having problems connecting to SQL Server 2008 remotely

    I am trying to connect to my database in Visual Studio 2010 using the named instance by 123.123.123.123/instanceNameBut, I get the following error message: error provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server I have the following aspects enabled: open Port...

    ITKE351,905 pointsBadges:
  • CALLB error!

    Hi all, When I compiled a RPGLE member, I'm getting  this error : "CALLB cannot be used when DFTACTGRP (*YES) is specified for CRTBNDPGM or as a compile option keyword."  Can any one please explain me why this happens and how to handle this? Thanks!

    Sai4AS4001,420 pointsBadges:
  • Recommended Alarm Thresholds

    When setting alarms, are there any recommended thresholds for best practices? This would be for setting email alerts.

    ksmoler5 pointsBadges:
  • Why won’t the macro run in other worksheets?

    I want to make a table as part of a macro. The size of my document changes daily, so even though a choose control end before I make the table, it assigns specific cell numbers which it employs for subsequent runs of the macro. How to I get it to go to the last populated cell in a column...

    Felucha5 pointsBadges:
  • Pagination in different versions of SQL Server

    What's the best process (performance wise) to paginate results in different versions of SQL Server (2000, 2005, 2008 and 2012) if you also want to find the total number of results (before pagination)? Thanks!

    ITKE351,905 pointsBadges:
  • Cannot connect to SQL Server 2012

    I'm having trouble connecting to SQL Server 2012 database using C#. I get the following error message when I try to connect: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance...

    ITKE351,905 pointsBadges:
  • Stored Procedure code in SQL Management Studio

    I'm trying to find a way to step into a stored procedure code in SQL Management Studio (in SQL Server 2008). I've heard its possible with Visual Studio but I'm looking for a debugging solution for Management Studio.

    ITKE351,905 pointsBadges:
  • Using a table variable as input in a stored procedure

    Have just run into a problem. Currently our web service has been adding data to our SQL server 2008 tables by building a dynamic SQL INSERT command. It has started failing because of the data coming in. It contains a single quote in the name data ex. O' Brien. I am looking to pass the tables from...

    ToddN200015,060 pointsBadges:
  • Restore SQL Server 2000

    Our server crashed, I installed SQL 2000 on another server and would like to restore the databases from a backup copy. Please help.

    sfcharry5 pointsBadges:
  • Crystal Reports if then else

    Using Crystal 2008 if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} + {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice} Returns error on save " A Boolean required here"

    jdaniel11285 pointsBadges:
  • Powerbuilder and Word OLE

    How do I insert pictures in picture content control in Word during runtime from PB (if I have 5 predefined picture content controls already saved in a Word template?

    HariharanAthmaraman5 pointsBadges:
  • Privera software

    I'm an IT beginner and I want to learn more about Privera software. Can someone point me in the right direction?

    ki7uf8tz65 pointsBadges:
  • Oracle 9i Migration from Solaris to AIX

    Hi, We have to migrate the Oracle 9i Database from Solaris 2.8 to AIX 6.1. There are two databases of 500 GB and 1.5 TB respectively to be migrated. I did go through an article from Maria Anderson (Production DBA, Autodesk at...

    SolnSeeker5 pointsBadges:
  • Lotus Notes 4.6

    How to get back Workspace in Lotus Notes 4.6 after accidentally deleted the workspace. Actually I want to change existing mail database from server 2 to server but while exploring the mail server, I accidentally delete the existing mail workspace and I really need to get back the workspace. Please...

    prolog15 pointsBadges:
  • QR Code barcodes in .NET

    How could I generate barcodes not in black and white, but still it could be scanned, it this possible?

    Alice34570 pointsBadges:
  • Error Code 64: Host not available – ISA error

    Hello Sir;   When I am accessing the  internal website from other system, I get below error. How can I bypass internal broadcast  from ISA server?   I alread bypass from  broweser's internet option but still same issue.   With Regards Bhupendra Jesalpura 9426372705

    BhupenJesalpura10 pointsBadges:
  • Windows updates

    The following 3 updates always fail to download. K2810048 K2817474 K2833941

    AEUDESA5 pointsBadges:
  • Need to delete tons of records in SQL Server 2012?

    I have over 740 million records in a table and I need to delete all records with two field values. I can’t find a way to do it automatically and of course manual makes no sense at all. Is there any way I can do this?

    ITKE351,905 pointsBadges:
  • Why is my textbox always showing zero’s after the decimal point? (Visual Basic)

    I have a text box to where a user will insert text like 1234567. My intentions is to have that textbox add the comma's and decimal points once the focus has left it. However the results I am getting is 1,234,567.00 and not 12,345.67. Here is my code: Private Sub toothchart_TextChanged(ByVal sender...

    TryingHard125 pointsBadges:
  • Viewports in AutoCAD

    Is it possible to create circular viewports?

    IndyMike485 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