Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. alistairpaul

    DataStage accessing remote 64-bit Universe File - failure

    Has anyone used DataStage to access a remote 64-bit universe file? We're testing out this scenario, and using UV/Net, connecting to Universe 9.6 and when we hit a record with a size larger than the separation size of the file, it does an immediate disconnect or lockup. Any light shed on this...
  2. alistairpaul

    View List of database/log files and their sizes

    I'm trying to setup a script or utility to automate the retrieval of all databases on a server, and for each database, get all it's data files, log files, and their allocated sizes as well as their data-used-sizes so I can better keep an eye on space usage. I've looked into SQL-DMO and have...
  3. alistairpaul

    Saving Diagram in electronic format?

    Does anyone have a good technique for saving/exporting a SQL Server diagram to an image file, or other file to be emailed around? Thanks!
  4. alistairpaul

    Need help retrieving computer's SID or other Unique ID

    Good Morning All - Does anyone have a code snippet to help me retrieve the SID of the computer, not the current logged-in user? I'm trying to gather some system and software information from a few computers, scripted, but I need to find a unique identifier for each system without the user...
  5. alistairpaul

    New to DW, Can you provide an outline or plan of action?

    Hi, I'm new to data warehousing, but have been doing SQL Server 7 admin for a while, along with some VB6, ASP/VBScript, and misc... My department's just been tasked with exploring the possibilities of data warehousing, and I was wondering if anyone has any "lists of...
  6. alistairpaul

    compiling to small small size?

    I'm a SQL DBA and part-time VB/VBS/ASP programmer. I've come upon something I'd like to do in C/C++, and don't know the language, but would like to learn. While playing with Visual C++ (6) last night, I made a silly little "hello world" app, with one single printf() line and an...
  7. alistairpaul

    Need help transferring SQL logins/passwords to other server

    Here's my issue - I'm fairly new to SQL Server and need to make a copy of a database on one server and move it to another server. I need the users/logins in this database to follow over to the other server, and I need the permissions to be applied correctly. My pitfall at the moment seems to...
  8. alistairpaul

    Can you get a list of Installed Programs in VBS??

    Does anyone know if there's a way to get the "Control Panel / Add/Remove Programs" list of programs using VBScript? Also, the current version of windows and some HDD statistics (total space, free space) ?? Thanks for any hints/clues/direction! Alistair
  9. alistairpaul

    How can you get the "month name" ??

    I tried a couple different ways of doing "if month(table.datefield) = 1 then monthnamevar = "Jan", but I was unsuccessful. Does anyone have a good way to do this? Thanks!
  10. alistairpaul

    Get Days/Hours/Mins between DateTime1 and DateTime2 - Crystal 7.0 ???

    Hi folks - I've got 2 fields that have datetime values in the form of '05/09/01 16:31:03'. I need to calculate the amount of days, hours, and minutes between the two fields. I've read Ken Hamady's stuff, but it references functions unavailable to me in CR 7.0, and I thought I saw a big...
  11. alistairpaul

    CRAXDRT and ASP - Is this possible?

    Here's what I need to do. I have an ODBC driver that can only be accessed by the Crystal Reports engine. It's proprietary, and written that way for a specific reason. If I want to get any data out programmatically, I have to basically use VB to access CRAXDRT.Application, load a report, and...
  12. alistairpaul

    Need to dynamically select which DLL to use (versions)

    I have a small program that uses the MS Word 9 Object library. All it does it use the Word.Application and Word.Document objects and their properties/methods. I don't care if the end-user has MS Word 97, or 2000. How can I code the app to use the appropriate DLL, or exit if they have no MS...
  13. alistairpaul

    Get # of records "affected by" statement

    Similar to the @@ERROR, is there a way to programmatically get the number of records affected by a SQL Statement issued by a program? MS SQL Server 7.0 If my post was helpful, please Mark it below. Thanks! - Al
  14. alistairpaul

    User sporadically unable to update stored procedure

    Any ideas why a user might all-of-a-sudden not be able to save a stored procedure? He's been able to do it all day, no permissions have changed, and now he reports that it appears to be saving, but when he goes to view it, it's actually not changed. Any ideas? Thanks! If my post was helpful...
  15. alistairpaul

    In need of VERY HARD Crystal Questions for Interview!

    Hi folks - we're about to interview some people that pride themselves on being Crystal experts and I was wondering if anyone could throw some 'killer' questions my way to really test their knowledge. Thanks for your help!

Part and Inventory Search

Back
Top