• ,temporary files, on win02/03 servers in access(.ldb files) and excel are not deleting when applications are closed

    can someone provide a possible solution

    Wildbull5 pointsBadges:
  • URL link in PHP/MySQL script

    I am adding a URL within a table with PHP and a MySQL Database, my string doesn't show all of the URL, it cuts it off.

    Jviney35 pointsBadges:
  • Moving data from iSeries to DB2 on Windows

    I need to get data from a iSeries DB2 system to my Windows DB2 system. The DBA produced and sent me a savf file. How can I important that savf file into DB2?

    Claudek75 pointsBadges:
  • Syntax to reference a table on a database residing on another server

    I have the following insert statement: insert into Resident(Identifier_Type,Identifier,Full_Name,Dob,DL_Number,DL_State,Change_User,Change_Date,Change_PropID) select N'SS',Social,Full_Name,DOB,DL_Number,N'TX',Change_User,Change_Date,Change_PropID from N'haa-sql1.imisTest.dbo.Resident' I'm getting...

    MParkhouse5 pointsBadges:
  • Table size in SQL Sever 2000

    Please, I need a script to know the size of every tables in my DB. I found that my database is growing above what I expected,and I need to know the size of its tables.

    Yunior5 pointsBadges:
  • Stopping transactional replication from skipping a block of records

    Have you ever run into an instance in SQL 2005 where transactional replication is skipping a specific block of records? I have tried many troubleshooting techniques: dropped/created sub and pub, created new empty destination table, reinitialized and several others. New transactions come across just...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Convert OO Base to MSA

    Is there a way to convert an existing Open Office Base database to MS Access?

    Naomih15 pointsBadges:
  • Finding the appropriate settings for copying tables within databases

    I have a table in a database that has 104456 records. I would like to copy the data to another table within that database. When I execute the command “insert into ChangeInsuranceTxnHistory select * from ChangeInsuranceTxn”, the following error occurs: "Could not allocate space for object...

    SQL Server Ask the Experts2,585 pointsBadges:
  • php script Question and Answer

    I am looking for a php script that show a photo of a person and ask who is this person. and you type in the persons name and it will gave you and answer of yes or no. or something like this, where I might be able edit

    Oneplace5 pointsBadges:
  • limit number of users in access 2003

    I converted access 2000 to access 2003 and I did the front end/back end approach. I need to limit the number of users accessing the front end so it doesn't lock up the application and not populate the look up table...I inherited this application

    Herdine30 pointsBadges:
  • Aggregate data

    Can I manipulate aggregate tables at the census tract level? In essence, could I create dummy variables, such as: white, black, hipanic, other for 100 census tracts? Or is this only possible with individual level data?

    Romanov385 pointsBadges:
  • Copy Attachments to Folder

    Anyone have a lotusscript to copy attachments to a folder? Also need to extract to excel a view but right now i think i can handle that with NotesSQL ODBC. The attachments part is buging me the most. This is not a mail system.... We have a database setup for document approvals. Lotus Domino 6.5

    Maramor140 pointsBadges:
  • maxicode from spool file on pick list with labels

    I need to present substitutes for some form software to a client. They need to create replace existing form software with form software that can creaate UPS shipping labels. The primary reason for switch is current forms software claims they can not make Maxicode from an AS400 spool file and...

    JoeVB5 pointsBadges:
  • Notifications Microsoft Access and Outlook

    I have created a form and one of the fields in the form is for the date of expiry for certifications. Is there a way that access can send a notification or some type of flagging through Outlook (or any other method for that matter) to let me know that someones certification expiry date is coming up?

    Tkalanchey5 pointsBadges:
  • Data Sources for SSAS 2000

    I have a short term issue where I will need a SSAS2000 cube to be using data from a SQLServer2005 database. Can I do this directly? If not, can I Export MSSS2005 data directly to the MSSS2000 database? (Sorry for such a simple question- I am a newbie).

    Petro5 pointsBadges:
  • Table creation in SQL Server 2005

    Hi, I need to prevent users to use CREATE TABLE but I need them to be able to execute a stored procedure that creates a table. Is it possible to allow users to create tables in SQL Server 2005 only through a stored procedure? Thanks in advance.

    Alediamo10 pointsBadges:
  • return array in postgres

    when i execute following function in postgres, it gives me null. select get_strelements('1000-2000-3000-4000',array[''::text]); here, "get_strelements" function is as follows: CREATE OR REPLACE FUNCTION "public"."get_strelements" (str varchar, dummyarr "pg_catalog"."anyarray") RETURNS...

    Johny15 pointsBadges:
  • How to optimize results coming from database

    Sir, I hv created a software which searches for the information the user wants. If only one user is using database at a time then it gives response in milliseconds. But when at a time 10 or more than that start using it then throughput decreases. So how i should do optimization

    Oracle expert5 pointsBadges:
  • How do I Autopopulate a few field on my my form?

    I have a database created in Access 07 and in this database I have tables, forms and reports. I have a table where I have all the Plan info and I also have a table into where the info is stored after being entered on the form. On my form I have a plan number, plan name what I want to happen is when...

    Lisarod25 pointsBadges:
  • Rookie using DSNTEP2 and IBM JCL – Need Help with JCL

    I'd appreciate some help here. My JCL background is HP3000 / MPEX and HP-UX, but my IBM mainframe JCL experience is over ten (10) years old. So I'm having problems creating a JCL - my brain can't remember command syntax's from that long ago. I need to create a JCL that will accept an input file of...

    Jonty Walker105 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