OLTP in Oracle
The answer could be different depeding on the operation being performed. In Oracle there are many different types and levels of locks, and some operations would cause one type or level of locks while other operations would cause a totally different set of locks. In general, there are two basic types of locks, which are [...]

View Answer   |  April 20, 2010  2:47 PM
OLTP in Oracle, Oracle 10g, Row Level Security

How useful is SCJP?
You need to go with your interest. It is not guaranteed that if you have done some certification you will get good job Certification will definitely help to get a job, but first make a success of you current studies, and then while you are looking for a job start pursuing SCJP. If you can [...]

View Answer   |  April 20, 2010  10:42 AM
IT careers, SCJP, Sun Certifications

Which certification will benefit me
Hi Amrathi. If I were in your situation I would have gone for the “SAP Certified Application Associate – Project Management with SAP ERP 6.0″ certification, get a job that have some project management as part of the job description and only after that pursue the PMP qualification. I dont know your situation, but if [...]

View Answer   |  April 20, 2010  9:53 AM
IT careers, PMP, Project management, SAP certifications, SAP Enterprise Resource Planning, SAP SRM, Supplier relationship management

SQL query
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]

View Answer   |  May 14, 2013  5:35 PM
MySQL, MySQL admin, MySQL query

Save or export vb 6 form
Basically you have to: -Include a picture box control in your form -Resize it to the size of your form -Use the BitBlt function to copy the form image to the pincture box -Save the contents of the picture box to disk. <a href=”http://www.codeproject.com/KB/vb-interop/SaveFormImageToFile.aspx”>Here</a> is some example code.

View Answer   |  April 19, 2010  5:09 PM
Access Database, Database import/export, PDF, save or export vb 6 form, VB 6

How to use Insert command between two servers to speed up performance
Your best bet will probably be to use SSIS to copy the records to the other server. This will allow you to control how large the batches are as they are inserted.

View Answer   |  April 18, 2010  3:22 AM
sql 2005 Performance Issues, SQL database replication, SQL Express, SQL Server 2005, SQL Server 2005 performance

Have you taken a shot at the Intel Open Port IT Scavenger Hunt?
i want to know java interview Question & Answer

View Answer   |  April 16, 2010  1:12 PM
AS/400, Channel, CIO, Contests, CRM, Data management, Database, DataCenter, Development, Exchange, Giveaways, Intel Open Port, ITKE, ITKE Contests, Knowledge Points, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SQL Server, Storage, Virtualization, VoIP

SQL 2005 Security to access 2 databases on same server via Stored Procedure
Setup both databases with cross database chaining. <pre>ALTER DATABASE FirstDB SET DB_CHAINING ON GO ALTER DATABASE SecondDB SET DB_CHAINING ON GO </pre> After you do this the users will need to exist in both databases. With the stored procedure in the FirstDB database, no rights need to be granted to the objects in the SecondDB [...]

View Answer   |  April 16, 2010  8:16 AM
Database management, Security, SQL 2005, SQL Server 2005, Windows Server 2003

Microsoft Live Chat: Introducing Microsoft SQL Server 2008 R2 on 4/22 11am ET
Thanks for the invite.

View Answer   |  April 16, 2010  3:22 AM
Database, Exchange, Microsoft Live Chat, Oracle, SQL Azure database, SQL Server 2008, SQL Server 2008 administration, SQL Server 2008 R2, Windows

Access 2007 filters
If you created the filter using the “Filter” button, then that option will be disabled. In the Advanced Filter Options you have to click on ‘Advanced Filter/Sort…” to enable the “Save as Query” option. -CarlosDL

View Answer   |  April 15, 2010  3:24 PM
Access 2007, Access 2007 functions

User circumventing security
First, make sure your procedural and policy ducks are in a row and carefully align what you do and say within that policy. Second, think through your priorities. Suspecting one end user has acquired super-user access may have serious overall implications — such as potential violation of defense contracting requirements or HIPAA obligations. Perhaps the [...]

View Answer   |  April 14, 2010  8:05 PM
Application security, Database, Encryption, Exchange, Instant Messaging, Secure Coding, Security

mysqldatetime exception
Hi, Me also got the same exception in my application, this is only happen by the Web.config file in out application, In web.config connection string we placed a property like : allow zero datetime=true; Please try to remove this in your connection string in web.config file.. thanks S.V.Narayana

View Answer   |  April 13, 2010  7:43 AM
C#, MySQL

Create a LNotes DB replica for Unique ids only
There is a nearly-complete version of lotusscript code that could be adapted to your need in Lotus Designer Help. This is a link to the 8.5.1 Publib page. This help information has not changed since Notes 6.5, so it should work with any supported version you are using. <a href=”http://publib.boulder.ibm.com/infocenter/domhelp/v8r0/index.jsp?topic=/com.ibm.designer.domino.main.doc/H_EXAMPLES_SAVE_METHOD_RE.html”>Link to page.</a>

View Answer   |  April 10, 2010  9:24 PM
Lotus Notes, Lotus Notes replication, Replicating databases

Retrieving data tables without backup SQL
You don’t. If the database is in full recovery, and you still have the log you can try using Lumigent’s Log Explore or Quest’s LiteSpeed to roll back the transaction and see if it will give you back the data. I’m 99% sure that it won’t. I’m pretty sure that you have lost the data. [...]

View Answer   |  April 9, 2010  7:15 AM
SQL Data Types, SQL Server backup, SQL Server tables, SQL tables

automatically populate field sequentially from list
thank you for responding. i’m sorry, this is the first time i’ve actually been on a site like this and i’m actually new to Access. i’ve never received training but i do ok developing simple databases. I’m using Access 2003. i created a table for the employee and unit because i thought that giving it [...]

View Answer   |  April 8, 2010  4:34 PM
Database

View a concise list of all Job Schedules SQL Server 2000
Yes there is… Many thanks for the tip.

View Answer   |  April 8, 2010  3:11 PM
SQL job scheduler, SQL Server 2000

passing array as parameter to stored procedure in mysql
AFAIK that is not allowed in MySql. You can, however, construct a comma separated string and pass it as a varchar.

View Answer   |  April 8, 2010  12:38 AM
MySQL, MySQL Query Browser

Access 2003 – Setting Form’s Recordsource
AFAIK, the Access Jet engine doesn’t support CASE expressions. It worked in the Pass-through query because when using that type of query the command is sent directly to the external database (without being parsed by the Jet engine). Access <a href=”http://www.techonthenet.com/access/functions/advanced/iif.php”>IIF function</a> provides similar functionality. -CarlosDL ————–

View Answer   |  April 8, 2010  12:14 AM
Access, Access 2003, Access 2003 forms

Generating Contracts Documents Automatically in Microsoft Access
It is possible, but plenty of coding will be required. I am currently working on a project that is creating contracts based on Access data. You can use the mail merge process to combine documents and get data from MS Access. The only problem is that if the data starts growing beyond 100000 rows (contracts), [...]

View Answer   |  April 7, 2010  7:53 PM
Microsoft Access

Joining 2 tables in MS Access and Searching & Retrieving records using ComboBox in VB and ADODC control
Check out: http://www.everythingaccess.com/tutorials.asp?ID=Build-a-search-criteria-form

View Answer   |  April 7, 2010  7:49 PM
Access Tables, ADODC, ComboBox, Microsoft Access