Managing Orphaned SIDs on AD objects
Security Explorer will allow you to centrally discover and remove Orphaned SIDs. www.securityexplorer.com

View Answer   |  January 26, 2011  10:26 PM
Developers, Development, Exchange security, Security, Windows

VIEW_TABLE_USAGE SQL 2005
The INFORMATION_SCHEMA.VIEW_TABLE_USAGE uses the sys.sql_dependencies catalog view to figure out what the objects that are used are. If a table was renamed or dropped and recreated then sys.sql_dependencies won’t be correct, and VIEW_TABLE_USAGE won’t be correct. Try altering the view which isn’t returning correctly to rebuild the information in sys.sql_dependencies. [kccrosser] You can also try: [...]

View Answer   |  January 26, 2011  7:25 PM
SQL, SQL 2005, VIEW_TABLE_USAGE

Cumulative totals in Access 2003
Can you use a report to display this information? Reports has a Running Sum property for an object. Or use could use VB in the report to keep a running sum. If you want it in a query, you could create a function in a module. You would have your running total dimmed in the [...]

View Answer   |  January 25, 2011  4:45 PM
Access 2003, Access 2003 forms, Access Database, Access query

How to run an applet in NetBeans 6.8
Right click on the class that extends JApplet and select “Run File”. Your project could be a Java Application or Java Class Library. Your class declaration must be public and extend JApplet, so Netbeans recognize it as an Applet and then run it.

View Answer   |  January 25, 2011  2:53 PM
Applet, Java, Java applets, NetBeans, NetBeans 6.x

Error Message when trying to change Parameters – Crystal Reports 11
Assuming that WHSP_USER is the object owner, and SP_RPT_DAILY_LANE_EXCEPTION is a stored function or procedure, and it exists, then probably the calling user doesn’t have the appropriate privileges to execute the procedure/function.

View Answer   |  January 25, 2011  2:07 PM
Crystal Reports 11, Crystal Reports error messages, Crystal Reports Errors, Parameters

Upgrading for database structure
the best way to to this upgrade, is to use an ETL like Talend ou Informatica. Talend is an open source we use it for our data migration. for more informations you can visit talend web site best regards

View Answer   |  January 25, 2011  9:50 AM
Java/J2EE, JBoss application server, MySQL Database, Oracle, SQL Server, SQL Server 2005, WebLogic Server, WebSphere Application Server

Application Upgrade and Data migration
The best practice for migration of data from one database platform to another database platform, involves first understanding and mapping your data and then ensuring that you are not using database specific features and if you are then to remap the relationship to a schema or set of schemas that your new database platform will [...]

View Answer   |  January 24, 2011  9:36 PM
Database, Development, Oracle, SQL Server, Web application development

iSeries Access Macro to run from a program.
I have no idea if it will work or not but have you tried STRPCCMD activate the macro. “STRPCCMD PCCMD(‘START C:DOWNLOADEXCElTEST.xls’) pause(*no) (*NO) ” will open an exceltest in excel. You might need to use rundll with correct structure to open a macro.There are sites available to see how to use both. you might come [...]

View Answer   |  January 24, 2011  3:12 PM
iSeries Access, iSeries macros, Macros, V5R4

Fingerprint recognition in Java
There is some commercial APIs to manage fingerprint scanners like those: http://www.griaulebiometrics.com/javadoc/FingerprintSDKJava/ http://www.123id.us/products_developer_cvtsdk.html http://www.biofoundry.com/products/biofoundryFreeTrial.html But I think could be a better way to read about JavaPOS (Point of Service) and JXFS (Java eXtensions for Financial Services). Both technologies are made for Financial Devices like ATMs and kiosk services. It is possible this hardware has fingerprint [...]

View Answer   |  January 22, 2011  12:54 AM
Access, Fingerprint authentication, Java, Java programming, Source code

TGIF: IT Book Giveaway
answer to the question…hyper v host not responding to scvmm r2…. http://support.microsoft.com/kb/976640

View Answer   |  January 21, 2011  7:52 PM
Desktop virtualization, embedded Linux, Giveaways, Hyper-V, IT Books, Linux, NetApp, Open source software, VirtualBox, VRDP

SQL and Dates
Are you trying to find the # of days from today to the date in your table? If so use the datediff function… datediff(DAY,getdate(),BMDTOR)

View Answer   |  January 21, 2011  6:29 PM
SQL, SQL Query, SQL Server

SQL command question
Look up the JOIN syntax. That allows you to join multiple tables together to find out stuff like this.

View Answer   |  January 21, 2011  6:26 PM
SQL commands, SQL Server, SQL Server tables, SQL tables

Restoring AS/400 after power outage: Src Code on IPL C1001020
Here is the answer from IBM I got this with a google search for C1001020 * If the system hangs after the code that sent you to this procedure appears in the control panel, perform these steps to reset the service processor. Attention: The system firmware level should be periodically checked on all servers and [...]

View Answer   |  January 21, 2011  3:10 PM
AS/400, AS/400 administration, IPL error, Source code, Source code management

Just started learning java programming, how do I become a Java Programmer?
Try these respources: http://www.javacoffeebreak.com/tutorials/gettingstarted/index.html http://www.freejavaguide.com/corejava.htm http://www.javabeginner.com/ http://richardbowles.tripod.com/java/guide/menu.htm http://www.quickjavaguide.org Hope these help!

View Answer   |  January 21, 2011  11:57 AM
Career development, IT careers, IT salaries, Java developers, Java programming, JavaScript

Sending HTML emails directly from the AS/400
Hi, You could try the SNDDST command, specifying the following parameters: TYPE = *LMSG – long message TOINTNET = email address – this address must be in the directory list. (Press F1 to read about it). SUBJECT = 60 chars max LONGMSG = The body email content I think you can put html code into [...]

View Answer   |  January 20, 2011  9:05 PM
AS/400, AS/400 email, HTML, HTML email

Why does my COUNTIF for the middle row not come up with the right counts?
They are in each cell. So 4 cells has each =COUNTIF(J2:J34,”<60″) – COUNTIF(J2:J34<b>,”<=29″)</b>

View Answer   |  January 20, 2011  5:14 PM
COUNTIF statement, Excel formulas, Excel functions

Calendar entries in Novell Groupwise
First u have to create an Appointment…. 1. Click the Actions menu and choose Auto-Date…. 2. Use Formula tabs to schedule events that occur on same day each week / same day each month 3. To use the Formula tab, follow the wording conventions as set by GroupWise. (u can go for Help for this [...]

View Answer   |  January 19, 2011  9:52 AM
C#, Novell, Novell desktop, Novell GroupWise

Need assistance to decide a career in SAP BI
SAP Business Intelligence or SAP BI is a platform and toolkit for businesses, and provides solutions that gives companies power over their business results. The job alike Business Development Manager or rather say better control over the business or something like this. Now the Q about BI, it is a one kind of technology, based [...]

View Answer   |  January 19, 2011  5:12 AM
Career in SAP BI, Project Management Office, SAP BI, SAP careers

how to use databases made in access or excel in sql
Definitely it is possible. U did not mention here which version of Access u r using ! Though try out this tricks…. There is a way called “Upsizing” which helps to convert access database into Sql (here sql means, assuming Sql Server) . To run the Upsizing Wizard in Access, Click Tools > Database Utilities [...]

View Answer   |  January 19, 2011  4:56 AM
Access, C#, excel, Import external data, SQL Server, SQL Server database

Connect to Oracle 10g with VB6 using ADO
One thing that is not clearly specified in the above article is that you need to have Oracle client software installed. The following article may help as well: Displaying an Oracle 10G XE Table with Visual Basic 6.0

View Answer   |  May 8, 2013  4:45 PM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6