Search results for query: *

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...

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...

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

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.

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...

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.

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...

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...

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.

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...

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!

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...

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 )

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...

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.

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...

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...

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.

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. :)

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...