Search results for query: *

I'm trying to return a list of distinct attributes, and a COUNT of the number of rows with that distinct attributes, this is from 2 tables with the same schema: Results e.g. (PackReference, Total) ABC123 2 DEF678 1 GHI901 6 SELECT PackReference, SUM('TotalRecords') AS...

Has anyone had any experience of using multiple internet connections (in our case 2 ADSL lines) with a Watchguard Firebox? At the moment, we have a firebox III/700, and a single ADSL router hanging off the External port and want to add another ADSL connection. Is it possible to maintain the...

We have records in the following manner: Record CreatedBy TimeCreated 1 Chris 13:30 2 Chris 12:12 3 Chris 13:31 4 Chris 12:14 5 Chris 09:34 I want to run a query that will fetch all records for a user where the...

We have hundreds of users, all of whom do not require a profile/their settings preserved - they do not have roaming profiles. However, when they logon Windows automatically creates a local profile in the C:\Documents and Settings\... folder. This happens at each computer the user logs into, so...

Is there anyway of getting the values of an attribute (across several rows) into one single row? If I have: Company Date Surname Notes ------------------------------------------------ IBM 01/04 Smith Here are some notes IBM 07/09 Smith This person also made some...

I'm trying to delegate control of users to some members of our staff (they are non-administrators). I am using GPO to deploy the adminpak.msi (from Windows 2000 Server CD) to them when they log on to a station. I have delegated control of the relevent objects (in Active Directory Users &...

Hi, I've got a PPP multilink connection active on my windows 2000 server (4 modems connecting as a bundled 180kbps connection) which appears as one connection. When I do an ipconfig to display all adapters, it only shows a LAN connection, no PPP adapter. Surely it should show a PPP conenction...

Can anyone recommend any software which can achieve the following. We have a server with 4 Dialup networking accounts. Clients on our internal network use this as an Internet gateway. I want to setup some sort of rule which specifies that certain computers use dialup account 1, others use...

I have a 1:M relationship between two tables A and B. If I do a join over A.id = B.id it will obviously retrieve all records from table B which join over .id with table A. How do I have so that it only retrieves one record from B (the most recent in B based on a datetime value in B)? A...

When adding an MSI package to a group policy object, is there anyway to add parameters to the execution of that package? e.g. (msiexec /i) acrobat.msi /qb-! I have developed an MSI package for adobe acrobat installation and need to execute the MSI file with some parameters to perform a silent...

I'm using GPO to deploy common utilities to users. I am astonished however that major players do not offer .msi packaged redistributable installers for their software. I refer to Winzip and Adobe Acrobat reader. Has anyone had any experience deploying these using GPO? I can get an MSI for...

I've found out that using Jscript's sorting algorithm can be faster than doing a bubble sort so am using the following code. However it is not generating a sorted array. I want it to overwrite my unsorted array and return it sorted (the array is called 'SoftwareUsers') : <script...

Any ideas why I kepe getting the persistant error: "Error 16916: A cursor with the name 'RsCursor' does not exist" I have declared the cursor?? CREATE PROCEDURE NoTaskOwner AS DECLARE RsCursor CURSOR FOR SELECT case_id FROM FaultLog WHERE AssignedTo IS NULL FOR READ ONLY OPEN RsCursor GO...

I'm just configuring an SUS server, and looking at all the patches and updates it has fetched. There are quite a lot - many of them not applicable to any of our machines. For example it has downloaded 500 or so updates to windows 2003 servers, which we have none of! Is there any way to specify...

I'm just experimenting with GPO to install software on computers as users log on - this works great and installs software at log on. (in this case MS Excel 2000) (I do this through Active Directory Users & Computers > Group Policy > User Configuration > Software Settings > Software Installation...

I'm working on a crystal report (.rpt) that was created in a previous version of crystal reports. I am using version 9 to edit the report, but need to save in this old format/version (pre-version 9). When I want to save it asks me "This report is from a previous version of Crystal Reports. Do...

I'm recieving an error that has no support on the Veritas support site (below). It occurs regardless of what server I back up (local or remote). Any idea what it is? Backups have been working fine until about 2 days ago. But nothing of any note has happened apart from adding a few new servers...

We have a DNS server on our Domain controller, which is set up with a forward lookup zone (Active Directory integrated) and to allow forwarding to our ISP DNS servers. However, we have no default reverse lookup zone. I seem to remember on our old NT4 DNS server it has records for in-arpa or...

I'm planning on setting up a RAS server to allow me to dial into our server. I could in theory have 4 dialup connections to the RAS server (each at about 50kbps). This is in turn connected to a gateway which will provide internet access. Is there any program or way I could combine these...

However I try and run Newprof, I constantly get a program error (detailed below). Can newprof only be run at logon? I am using it in a script and it keeps giving the error. Running Windowss 2000 professional, Outlook 2000. ______________________ NEWPROF.exe has generated errors and will be...