• how to get list of encrypted objets in sqlserver 2005?

    i need a list of encrypted store procedure name,encrypted trigger ,encrypted functions from sql server 2005.

    Subrata735 pointsBadges:
  • MS Access ActiveX Control

    I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that? Thanks, Asuasol

    Asuasol10 pointsBadges:
  • access2k unicode text column even # of bytes error

    a certain row(s?) in an access2k table is corrupted. it causes the application to fail quite often requiring a messy procedure of bringing it up to date each time and it's been like this for years so no older backup exists. archive and fix fails for the same reason (unicode text column width must...

    Santa35 pointsBadges:
  • Combined Address

    I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address. Someone suggested that I create a calculated field. I tried this but all that it is doing is...

    Thuzinec10 pointsBadges:
  • Net Present Value

    In an Access Form, I want to be able to have five values in text boxes and use those five values along with another value in the form, the return rate, to produce the Net Present Value

    Mattylar125 pointsBadges:
  • Open Import window via code in MS Access

    Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.

    Rjwilcox45 pointsBadges:
  • Grouping and Sorting

    I have a Crystal report in which I want to group employee number but sort the group by hire date. Is this possible?

    KatSil10 pointsBadges:
  • Populating a db with information stored on another db

    I have a general how-to question. I need to populate a database with information stored on a separate database. I have never done this before and I would like to know the process that is usually used. A little information concerning the databases. My database is set up through phpMyAdmin. The...

    LoganGoesPlaces45 pointsBadges:
  • MySQL Stored Procedures in Crystal Reports

    Hi, am using Crystal Reports 9 and MySQL 5 DBMS. I have a stored procedure which accepts a parameter, Crystal Reports won't accept this stored procedure and cites 'Incorrect Number of Arguments; expected 1, got 0'. Im pretty new to MySQL and perhaps I shouldn't be creating stored procs the way I...

    Les za30 pointsBadges:
  • Save Access 2007 format as 2000 format with VBA

    how can i save the curent database as a 2000 format with vba

    Dave b10 pointsBadges:
  • Data Migration Betrieve Tables to MS SQL Server 2005

    Hi! could somebody help us advice on what to do and what to prepare if we are going to migration our current database Betrieve tables to MS SQL Server 2005? Thanks. Note: We are currently accessing the Betrieve tables thru PervasiveSQL v8 engine.

    Wonderer0820 pointsBadges:
  • Moving a SQL database from one host to another

    I need to help out in a move of a site coded in ASP/VBScript from one host we're having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don't know how to move the SQL database along with the site. Can...

    Kwoodall10 pointsBadges:
  • While loop Vs Cursor

    What is difference between navigating records in while loop and cursor ?

    Just dream5 pointsBadges:
  • Is there a way to set up database mirroring in SQL Server 2005 to receive failover notification?

    I'm setting up database mirroring in SQL Server 2005 Standard Edition and was wondering if there is a way for SQL Server to send me a notification of a failover and for it to automatically run a script when the mirror is brought online.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Split Databases – BE Structural Changes Version: 2007 (12.0)

    Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?

    Thuzinec10 pointsBadges:
  • Update table to remove invalid char type (tab) Oracle

    I need to update a table I have in oracle that has an invalid character type in it. It looks like it is a tab character. Can someone give me a script to update this field in the table to remove a tab character from a field and replace it with a space - I assume? Very few rows have this 'bad' data...

    Meb10 pointsBadges:
  • How can I accomplish load balancing with redundancy?

    I have two links with different ISP's and both the (512Kbps) links are terminated on separate Cisco routers (2811). Currently, we are using one link. Another link is new. I want to do load sharing and redundancy between them. Right now I am not using BGP (routers are configured in simple manner)....

    NetworkingATE1,545 pointsBadges:
  • Embedded SQL in a Cobol program using a sub-select in the select clause

    The following works fine in SQLPLUS: SELECT SOVLCUR_PIDM INTO :STDN-PIDM FROM SOVLCUR WHERE SOVLCUR_PIDM = :HOLD-STU-PIDM AND SOVLCUR_LEVL_CODE = 'UG' AND SOVLCUR_LMOD_CODE = SB_CURRICULUM_STR.F_LEARNER AND SOVLCUR_CURRENT_IND = 'Y' SSRMEET_ROOM_CODE FROM SSBSECT, SSRMEET, SGRSPRT WHERE...

    Warpmail5 pointsBadges:
  • SQL linking to database in XP

    First of all, I tried to create an ODBC connection to a local SQL database. It successfully created but it does not show up. I know it is there because I can link to it via Access or if I try to create the same one again, it tells me it is already there and if I want to overwrite it. In trying to...

    Bigblew15 pointsBadges:
  • Deletion of Macros when doing a repair & compact

    We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up--what do you think could be the problem?

    SharieL10 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