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 Chriss Miller 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

    How to judge the value which I get from database is null?

    correction to above statement.. if Len(Trim("^" * recordSet("name"))) = 1 Then
  4. alistairpaul

    How to judge the value which I get from database is null?

    another good thing to do is the following: if Len(Trim(&quot;^&quot; & recordSet(&quot;name&quot;))) < 1 Then response.write &quot;no name&quot; else response.write recordSet(&quot;name&quot;) end if this will check for a string containing only spaces, as well as nulls.
  5. alistairpaul

    Merging Dates

    Without going into huge detail and writing the entire thing - here's what I would do. Put all of it into a stored procedure, or just do it all through code. Grab current record's date, and number of absence (1). Goto next record. If next/current record's date is same as variable holding last...
  6. alistairpaul

    how to shrink the size of a logfile?

    If SQL Server 7.0, it can sometimes be buggy. It may help to sp_detach_db the database, rename the log file (windows explorer), then sp_attach_db the database, specifying only the name of the data file. It will then automatically create a blank log file (small size) for you.
  7. alistairpaul

    Making a date update based on chnages in another field

    You should be able to make this or something like this work: Private Sub text1_AfterUpdate() Text2.Value = Now() End Sub Put that code into your Form's code module, and change the &quot;text_1&quot; part of the Sub's name to the name of your control of the value you'll be changing. Then...
  8. alistairpaul

    How create a new database using vbscript?

    What type of database? MS Access, SQL Server, other? Some ways are below: ==== MS Access ==== Create a standard blank MS Access MDB file, named &quot;DEFAULT.MDB&quot; When ready to create a new database, copy the &quot;DEFAULT.MDB&quot; file to the filename that the user provided, then use...
  9. alistairpaul

    Oracle DB

    You should be able to access it using an OLEDB connection as you would any other database. Here's a page that will give you the connection string for Oracle http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForOracleFromMicrosoft Hope it's of some help.
  10. alistairpaul

    Saving Diagram in electronic format?

    Thanks - but I've already been down both of those roads. I know Alt-PrintScreen does a decent job, but what if all of the diagram doesn't fit on the screen, but prints to fit in a page - Then you have to take multiple print-screens and put them together. As for Acrobat - I've been looking for...
  11. 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!
  12. 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...
  13. alistairpaul

    Eject CD

    Go to: http://161.58.84.209/graphics/tip197.html and look for the Function EjectCD() .. should do the trick ( as well as including the API ref )
  14. alistairpaul

    MAPI Mayhem

    This works fine for me: set olApp=WScript.CreateObject(&quot;Outlook.Application&quot;) set mailitem=olApp.CreateItem(0) set nameSpace = olApp.GetNameSpace(&quot;MAPI&quot;) mailitem.Recipients.Add(acctname) mailitem.Subject = mailsubject mailitem.HTMLBody = mybody mailitem.Importance = 2...
  15. alistairpaul

    Passing Listbox value to msgbox

    to do your messagebox, you need to write some client-side vbscript that will be output to the client from your ASP script, instead of processed on the server-side.
  16. alistairpaul

    FileSystemObject trouble accross Domains.

    Try making an account on &quot;Domain1&quot;, we'll call it &quot;myInternetUser&quot;. Go to &quot;Domain2\Fileserver&quot;, and give the necessary permissions to &quot;Domain1\myInternetUser&quot;. Then, in your IIS:Internet Services Console, set the web-directory, or ASP page to use the...
  17. alistairpaul

    How do i run a &quot;silent&quot; program that waits for a certain time??

    The easiest way to do this is just to stick all of your code into &quot;Sub Main()&quot; in a module, compile your EXE, and schedule it, like someone mentioned above. I do this quite frequently for all of my little utilities.. but i normally use VBScript for my &quot;nightly tasks&quot;, just...
  18. alistairpaul

    msgbox

    When I do a MsgBox() function, I don't ever get the &quot;VBScript&quot; on the title bar.. Simply whatever i put into the title.. MsgBox &quot;Hello&quot;, , &quot;MyTitle&quot; But wait.. I am talking about Script files, not VBScript embedded into IE. - Can't comment about that.
  19. alistairpaul

    SQL To MSDE

    Download it here.. http://msdn.microsoft.com/vstudio/downloads/addins/msde/download.asp haven't even touched VS.NET yet. still bogged down with current work. :)
  20. 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 &quot;lists of...

Part and Inventory Search

Back
Top