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!

  • Congratulations strongm 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. ramsfield

    Inventory Problem

    Whether I enter slpinfo from a working or non-working workstation, I receive the same response, showing the correct DA address and scope. The container(s) have an effective policy, but not directly associated. Containers in the vlan and ones which are not are configured that same and have the...
  2. ramsfield

    Inventory Problem

    We are currently running Zenworks 7 on a SuSE server. The server is running both NCP and Samba. We are expiercing an issue with most of our PCs that are on vlans. Our computers on the main network segment run inventory just fine, but computers on the vlans do not. They produce the following...
  3. ramsfield

    Connection Refused messages

    aixmurderer, I think you misunderstood. The comcast address is an external address. I am guessing that our spam server is trying to bounce a message back to comcast saying the message was underlivable. Our GW server is on the same subnet as our spam box which is on a 10 dot network.
  4. ramsfield

    Connection Refused messages

    We have been getting lots of connection refused messages in our mail queue. Here is out setup, our email comes into a dedicated spam box which is running postfix, amavis and spamassasin for processing. (The spam box is Suse Linux 10, 1GB of ram, dual core CPU. The cpu load is less than 1%. The...
  5. ramsfield

    Import of WS fails

    Just installed Zenworks 7.0 on OES linux and cannot import workstations via AWI or manually. When trying to manually import the workstations via zwsreg the client reports "No import Policy found". This occurs on all machines, Windows 2000 w/SP4 and XP Pro SP2. Here is the log file. uesday...
  6. ramsfield

    Fonts

    Is it possible to share fonts with another computer. Meaning can I set up a font folder on a server and somehow have the desktops refernce the share to obtain the fonts? Or do I have to copy all the fonts to each machine?
  7. ramsfield

    Access/Word 97 - Merge current record to Word Form

    I would like to link the current record being viewed to a word form. So, when a button is clicked, Word would open and "merge" the record with the form. The word document is already set up and linked to the database.
  8. ramsfield

    Text field in trigger

    The application limits the insertion of records to one at a time. The text field is the important part, we have two more triggers that works with this one, one for deletes and one for updates. We really need to be able to track what is changing within the text field.
  9. ramsfield

    Text field in trigger

    ...AS datetime DECLARE @csa_time3 AS datetime DECLARE @csa_ampm1 AS varchar(1) DECLARE @csa_ampm2 AS varchar(1) DECLARE @csa_ampm3 AS varchar(1) /*DECLARE @csa_notes AS text*/ DECLARE @csa_hold_flag AS varchar(1) DECLARE @csa_disp AS varchar(4) DECLARE @csa_assigned_to AS varchar(4) DECLARE...
  10. ramsfield

    Ghost user?

    Well, as long as the blue smoke doesn't escape from the computer, we will be OK. Thanks again fo ryour help!
  11. ramsfield

    Ghost user?

    Yes, two for this database. dbo (sa) - master db imagex - mason db dbo db_owner sa master 1 imagex ImageXRole imagex mason 7 Both of which are valid users
  12. ramsfield

    Ghost user?

    Dennis, this worked. Thank you! So how can there be a user without there being a user? Meaning, I did not see this user anywhere, but was able to delete him? Did an association get orphaned or ?
  13. ramsfield

    Ghost user?

    I have a database that has been running for some time without problems. We have recently built a new server and are in the process of moving the database from the old to the new. When I use the import / export wizard, the process starts fine but then fails with the error message User or role...
  14. ramsfield

    Scheduled job fails

    After overlooking the step history.... Executed as user: NT AUTHORITY\SYSTEM. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step failed. I changed the field properties of one field of the...
  15. ramsfield

    Scheduled job fails

    Denis, yes, I just checked the database and it is set correctly. You are right about that, you never know. Its always good to double check. I have even added this step to a job that runs fine, but it still fails. It kind of elimanates the job, but implicates the interaction between the agent...
  16. ramsfield

    Scheduled job fails

    The job is owned by SA. The sql agent is started by a member of the sysadmin group. The error is non-discript: The job failed. The Job was invoked by User sa. The last step to run was step 1 (Logged_in_users).
  17. ramsfield

    Scheduled job fails

    I have the following code in a store procedure. I have a scheduled job setup to run every half hour. The job fails everytime with no indication as to why. If I exec the stored procedure from query analzyer it runs just fine. However, when I run it as a scheduled job it fails. I have also tried...
  18. ramsfield

    Stored procedure - Insert Table

    I have the following stored procedure. I would like it to take all the results and insert them into a table. The current script only inserts one result. How can I make it return and insert all the results? If I just run the select statement, without the variables, I receive about 30 rows...
  19. ramsfield

    Date problem in View

    After further review I realized the problem is caused by certain dates missing from the dbo.tblTime.[Date] table. This was a mistake on my part. The statement works as expected...as long as all the related tables are populated correctly. Thanks for everyones help
  20. ramsfield

    Date problem in View

    Could you provide an example? I am not real familiar with cases

Part and Inventory Search

Back
Top