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

    Multiple SCCM servers and firewalls

    I have been asked to take a look at a system that has multiple SCCM servers in different sites. These are all linked together, and the system works well. One of the reasons for the system is software inventory, and this is what I am concerned about here. We now need to change the network, to...
  2. bartsimpson

    Remove Exchange 2007 corrupt PF

    I have an Exchange 2007 server ( the only one in the organisation ), and need to remove it. Only problem is, the EDB files have become corrupt due to a disk failure. They are gone, no more. Also no backup. So, I have run the removal tool, and have got as far as I can until it complains that I...
  3. bartsimpson

    Corrupt disk

    I have a corrupt disk on an Exchange server. My problem is that I want to back up one of the EDB files, but Windows is giving an error : 0x8007045d . The disk failed last night, and I have managed to get it running by cold-starting the server. Seems it isn't quite right, as I can't access the...
  4. bartsimpson

    Central Admin shows blank screen

    I have a MOSS 2007 installation on a Win 2008 box, with IIS7. I can get the main IIS page to display, but whenever I go into Central Admin, all I get is a blank screen. The source is : <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content="text/html...
  5. bartsimpson

    Restore using STSADM

    I'm moving a SharePoint system from one server to another, and have successfully used STSADM to move the content across, with a restoremethod of new. I now need to do another backup / restore cycle before I go live, but as predicted, the new option won't work, as the database is now populated...
  6. bartsimpson

    USB memory stick read only

    I need to protect my network by setting any USB drives ( HDD, memory stick, camera etc ) to read only. I've found a reg edit to disable them, but read only is more difficult. Does anyone have a regedit to fix this ?
  7. bartsimpson

    difference between two tables

    I have two access tables, where the structure in each is exactly the same. They were taken from the same database, one a month later than the other. There are some records that have been deleted - I can use the "Find unmatched query" wizard to find them, no problem. Some data was changed in the...
  8. bartsimpson

    Restore failed with skipped files

    I'm in the middle of a restore, and the server suddenly stopped restoring, and began skipping files. No further files were restored to the end of the job. Help !
  9. bartsimpson

    Infrared link

    I have an application that uses a COM port to communicate to another piece of equipment ( Running on a Dell laptop, Win XP Pro ). The other piece of equipment is a small box with only an infrared port. I have enabled the IRDa port on the Dell laptop, and have created a wireless link. But the...
  10. bartsimpson

    List of dates, need to insert missing days

    I have a list of data in Excel, which is sorted in date order : 1/1/04 a 2/1/04 b 2/1/04 f 3/1/04 c 4/1/04 d 7/1/04 a etc As you see, there are some dates missing - does anyone know a quick way of inserting rows into the data with a date there so I get 1/1/04 a 2/1/04 b 2/1/04 f 3/1/04 c...
  11. bartsimpson

    Registry key for ADO

    I'm running an application in Excel that accesses a SQL database using ADO. I need to enable ActiveX data objects for a group of PCs. We run policies on site, and so I'm trying to find a way that I can enable ADO on all PCs without having to visit them all - which would be very difficult due to...
  12. bartsimpson

    Accessing a SP via ODBC

    I have written a stored procedure that I can run using EXEC spMyProcedure 1,2 from query analyser. I need to access this procedure from MS Excel, passing the parameters. How do I do this ? I can't see the stored procedure using ODBC, even though I have given myself EXEC permissions. Then how do...
  13. bartsimpson

    Excel, views and groups

    I have a lot of data that I summarise in a view. This gives me data such as : group summary 1 summary 2 1 57 26 2 45 43 The data in the groups are sorted by date. I want to return this data to an Excel spreadsheet using MS Query, which can...
  14. bartsimpson

    Days per month in a group

    I need to do some calculations on data for a number of months, based on the number of days in the month. For example, if I have 3 events in january, then I would have a figure of 3 / 31 = 0.097. I do this for all of the months in the year, in one report, based on a group by month. Many people...
  15. bartsimpson

    Use DTS to update a table, not just add data

    I have two tables, and I need to update one from another every 8 hours. I want to replace the data in the destination table, but I can't do an update, as I can't get a query to update one table from another. What is the best way to get DTS to perform this task, or is there another method I...
  16. bartsimpson

    divide by zero, but divisor is not zero

    I have written a view that lists data, and divides one column by another to give me a new column. This works for the first 16 rows of data, but when it hits row 17, I get a divide by zero error. There is no zero in the divisor column. The SQL is below : SELECT volts AS [Voltage Ave]...
  17. bartsimpson

    Crystal Enterprise 10 graphs on screen

    I've just recieved Crystal Reports 10 Pro, and will be upgrading my production server from v9 to v10. I use the v9 RAS server on the production server. v10 doesn't have RAS, but ships with enterprise express. This means 5 named users, where the RAS server meant 1 concurrent user. Seems like a...
  18. bartsimpson

    Print Job Manager is unable to delete job

    I'm running Open Server 5.0.6, and have a bunch of printers printing to HP Jet Direct printers. Occasionally, a print job hangs the queue, and I'm able to delete it from SCO ADMIN's print job manager. This cures the problem. This time, however, I'm not able to delete the offending print job. The...
  19. bartsimpson

    Change start day of the week for a group

    How do I change the start day of the week ? I'm grouping on a date field, and Crystal groups from Sunday to Saturday by default. I need to change the grouping to Monday to Sunday. Help !
  20. bartsimpson

    Service not starting

    I'm trying to start a Crystal Repport Application Server service on a Win 2K server, SP4. I have my personal user name, and also a new user name to start it with. If I use my username, then it begins OK. Using the new user name returns an error - "Service did not start, the service did not...

Part and Inventory Search

Back
Top