Search results for query: *

Windows XP (Development Machines) Websphere 6.0.0.0 Can anyone tell me if it's possible to use the MQ .NET API without installing the full client? We want to be able to ensure all solution's build across all development boxes with as light an install as possible. Using FileMon and RegMon I've...

Thanks, Stef. I don't think we do have this. Is it something I can get from PartnerSource? Regards, JJayUK

We have a set of old VBA modules loaded in as chunk files that we have lost the original VB source for. Does anyone know if it's possible to decompile/disassemble these files to view the original code? Any help appreciated Regards, JJayUK

Hello, Using the local demo version which we use to develop with we lost one of the AMPS (AMP 1) which went to FATAL. Using vprocmanager I executed a BOOT command and the status of the AMP is now UTILITY. When trying to execute the REBUILD command, though, I'm getting the error: REBUILD...

Hi, It's been a while since I've used Java but am trying to resolve a client's issue passing SOAP messages to one of our web services (the web service is actually .NET). I've downloaded the latest version from SUN which also included Net Beans. I then tried to download and install the Web...

This could probably be done using a WMI query and the .NET System.Management namespace. Take a look at the documentation for more info. Thanks, ChrisA Regards, JJayUK

We have an application that has a number of customer performance counters added. When the application is installed (using Install Shield) the counters appear fine on each server where the application, is provided you run perfmon on the actual server. When we try to add counters to perfmon...

Kim, I know this is an old thread but this is a problem I've seen a few times and finally have an answer. The problem is not the proxy account itself, but the account the SQL Server Services run under. You *must* reset the SQl Server Services to run under a suitable account with suitable...

I have an application reading performance counters and representing the data returned in a set of progress bars. The timer triggers every 100 milliseconds and reads the next performance counter before updating the progress bar with the new value. My form crashs whenever I try to close it...

Your first question: This seems needlessly complicated and I don't think SQL Server could manage it anyway. Second: Yes. Sybase provide Windows compatible ODBC software which allows you to connect straight to Sybase using ODBC. I've been using it for years. If you have the Sybase install...

We recently upgraded our server to use a Compaq SDLT drive for running backups. Since we installed it one of the tape drives never works and the other comes up with intermittent problems. We are running SQL Server 7.0 with SP4 applied. This never happened with the standard DLT. Has anyone...

Not sure if there's an easier way but... You could build up a SQL String to run and use the EXEC() command to run it. Try selecting the data into variables so you have: @Custom_Attribute_Value @Custom_Attribute Now build a SQL that uses the CONVERT/CAST functions: SELECT @SQLString =...

Is there a way to tell whether an object in a directory is a folder or a file? I'm hoping to be able to pass in a string with the filename and get some kind of response that lets me determine if the named file is a file object or folder. Any help appreciated, Thanks v. much in advance...

Hi, I'm trying to use the media player control on a form to display a helpful, small avi animation that lets the user know processing is going on behind the scenes - a kind of 'Please wait' form. The form loads and displays the avi file correctly but whenever the processing it's supposed to do...

Most system stored procedures that return recordsets can be invoked as part of an INSERT statement. CREATE TABLE #DATA ( DATA CHAR(500) ) INSERT #DATA EXEC master..xp_cmdshell('DIR *.*') Will load the results of the DIR *.* operation into the table called #DATA. I don't see why you cannot...

Hi, We are running SQL Server 2000 SP2 on Windows 2000 SP1. I want users other than 'sa' to be able to run the xp_cmdshell extended stored procedure. I gather that, in order to do this I need to specify a valid NT account as a proxy account for the 'xp_cmdshell' to run under. I've tried this...

Hi, Anyone know of any problems using Super DLT tape drives with SQL Server 7 SP4? Ever since we upgraded to SP4 we've had a SDLT drive fail every time a bakcup is run. (Read errors). Every piece of hardware has been replaced but we're still getting problems. Any ideas? Regards, JJayUK

Hi, Does anyone know of an easy way to tell if a job is executing using T-SQL? I've had a hunt around the sysjobs and sysjobhistory tables but can't really find anything. I've also tried sp_help_job @execution_status = 1 but this will return *all* jobs currently running. I need to know...

I'm talking about a *lot* of data, more than the Excel limit. I want to get away from the slowness of the Microsoft Query stuff which doesn't seem to use the server to execute queries. It seems to copy large chunks of the data down from the network which is slow.... Regards, JJayUK

Hi, Does anyone know of a front-end app that will allow users to create queries with little or no knowledge of SQL? I'm talking about a Microsoft Query kind of program that allows you to create queries by pointing and clicking but will go off and generate the sql for you on the server. Anyone...