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

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

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

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

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

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

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!

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

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

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

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

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

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!