• Storing BLOB to file through SQL Server 2005

    I want to know how to Export BLOB data to a JPG File at the SQL Server end ... NOT USING C# or VB

    Naeem5 pointsBadges:
  • How to use partitioning in SQL Server database to avoid ‘timeout’ errors

    We have over 300 stores, and with each store having 30gb+ databases, each server is being upgraded to at least 6gb+ memory which is being forced allocated to SQL Server. I want to start to partition the existing SQL Server database by date. How do I go about doing it, because I have absolutely no...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using shell execute from Visual Basic

    How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland

    Rolandsk5 pointsBadges:
  • No such interface supported

    "No such interface supported" msg shown in try method, while i m assining a dataset to crystal report viewer by following code, dim cr as rpt1 = new rpt1 cr.setdatasource(dataset) crviewer1.ReportSource = cr

    It-base5 pointsBadges:
  • I need help with how to programmatically backup a database

    I’m trying to programmatically backup a database using the following command: expdp system/system_password directory=dir_exp job_name=jobexp SCHEMAS=my_schema where "system_password" is the actual "system" password and "my_schema" is the name of the schema I want to export. How can I verify in an...

    OracleATE190 pointsBadges:
  • Running Procedures within the PL/SQL program

    WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!

    Nimsalwayz5 pointsBadges:
  • Can you connect a Cisco 7940 desktop IP phone through a wireless switch/bridge to a Cisco access point?

    Is it possible to connect a Cisco 7940 desktop IP phone through a wireless switch or bridge to a Cisco access point (AP) and make it work? I am having problems with this setup. It is most probably unsupported but we sure would like to make it work. Thanks!

    NetworkingATE1,545 pointsBadges:
  • How to pass a Whereclause from a form to another form’s subform in Access 2000?

    In FormA, I have a start_date and end_date fields for users to select the date range. The start_date and end_date will pass to FormB.subform where the subform is a continous form to display the records after filtered by the date range. My question is: how can I pass the date range to the subform of...

    Wonder195 pointsBadges:
  • Network design and infrastructure for a small business with on-site and remote access workers

    My company occupies a small self-contained, single-story business unit (of which they are the sole occupants) which is part of a larger business park. They employ 24 staff comprising of a CEO, 5 administrators, 2 business development managers and 16 specialist consultants. The administrators and...

    NetworkingATE1,545 pointsBadges:
  • SQL 2005 error code = 80004003: Invalid Pointer

    After (successfully???) attaching a database to a VM Ware instance of MS SQL Server 2005 and setting what appear to be appropriate access to the SQL server itself and the database involved, and making sure that sharing and security are properly set on the SQL server, I am receiving the following...

    Pressler29042,190 pointsBadges:
  • BLOB Data move from Oracle 9i to Oracle 10g

    I want to move BLOB data from oracle9i to oracle 10g through java application. I am getting following error : java.sql.SQLException: ORA-00942: table or view does not exist. Using JDK1.5 & ojdbc5.jar

    AUpadhyay5 pointsBadges:
  • what is outside_cryptomap_dyn_20

    what is outside_cryptomap_dyn_20

    Ajwal5 pointsBadges:
  • Installation and updates

    Howdy folks, Tryin to keep things going around here....need some advice. I have Win2003 servers and Active Directory.....single domain....approx. 100 client computers.....one location. Am upgrading all computers from Office XP to Office 2003. My project: Install Office 2003 and all updates remotely...

    TheVyrys0 pointsBadges:
  • How to prevent SQL update trigger from firing on insert?

    Category: SQL Server 2005, T-SQL I have an insert trigger on TableA that updates Column1 in TableA. I also have an update trigger on TableA that I don't want to fire, or at least not to execute certain code, when a new record is inserted in the table. How can this be achieved? I don't want to use a...

    Leo W5 pointsBadges:
  • full-text replication SQL Server 2000

    I'm having problems replicating a table that has full-text enabled using sql server 2000 sp4. When I start the distribution agent I get the following error: Cannot use a CONTAINS or FREETEXT predicate on table 'dbo.proposals' because it is not full-text indexed. I have run sp_fulltext_database...

    MarkT35 pointsBadges:
  • Flickering subform in Access

    Hi, I have a continuous subform that, upon opening the database, flickers constantly. This flickering can be stopped either by alt-tabbing away from Access and back again or by hitting F9. The main form has a button that changes the source object of the subframe to a different continuous subform,...

    Mickeymongoose1235 pointsBadges:
  • how to import GAL in microsoft exchange 2003 from csv

    how to import GAL in microsoft exchange 2003 from csv

    Yundhi5 pointsBadges:
  • How to replace edited dataset in QMF through jcl( i.e Batch)

    I have exported one dataset 'IN105.Nord1'through QMF , then I have edited it and now I want to import it in QMF by same name( i.e IN105.Nord1') which I can do it through QMF . But now I would like to achieve same thing by running QMF through jcls( i.e through batch).Can I replace edited dataset...

    Panky5 pointsBadges:
  • Eenabling full outer join option in crystal report

    When i use Crystal Report 10, i alwaya found FULL OUTER JOIN option as disable. How to enable this option ?

    TariqMalhi15 pointsBadges:
  • Delete query

    Can you help me solve the following problem. Whenever i have an order where the field Audit = True, i will have to delete all the previous orders having the Audit = True. And only when customerid = 121. With other words i have to delete the previous orders having Audit = true but not the last one....

    Samotek15 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