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

    Automated File Distribution

    I don't know if this is the correctt forum to ask this question. Is there a software tool that will automatically distribute OS files on the active directory level to multiple servers in the same domain? I seem to remember using a tool like this a few years ago, but I don't remember what it...
  2. EdwinGene

    Recurring Jobs Not Recurring

    SQL Server 2005. I have two recurring SQL Agent jobs on one of my servers. They are the only two jobs on the server, at present. One of them is scheduled to recur once a day at midnight, and the other is scheduled to recur once every 15 minutes. Neither job is recurring. The schedules are...
  3. EdwinGene

    Disk Space Monitoring

    Snakeroot, Yes I eventually found this. Unfortunately, we have OLE Automation turned off as part of our security configuration, so I can't use the sp_OA stored procedures. Thanks, anyway, though.
  4. EdwinGene

    Disk Space Monitoring

    You're talking about "several options" on the Google results page? You obviously saw the numerous links in the Google results page (as I did when I googled xp_fixeddrives, earlier), but you didn't actually follow and read any of them, did you? Because, if you had, you would have realized they...
  5. EdwinGene

    Disk Space Monitoring

    We want to monitor free disk space on the hard drives of our SQL Server boxes, but we want to do it by percentage of free space so that we can reuse the same monitor, regardless of the size of the hard drives on the box, and not have to create one-off monitors for each server. The...
  6. EdwinGene

    ExecuteSQLTask SQL Statement Property

    In an ActiveX task, I have instantiated an object for an existing ExecuteSQLTask. Now I am trying to set the SQL Statement property for the instantiated task, but I can't figure out the name of the property. The DyanamicProperties task name of "SQLStatement" is not correct. How do I set the...
  7. EdwinGene

    Pull the most current record

    thorny00, Using Last Name and First Name for your unique identifiers may not work. There are probably millions of John Smith's and Jim Jones's in the country. It may not be happening in your DB right now, but it could in the future. It's something that needs to be accounted for in your code...
  8. EdwinGene

    Pull the most current record

    jbenson001, Should work, unless, for some reason the same person has multiple address values (for example, my zip code was changed last year even though I still lived at the same address). Then you would return multiple records for that person. A rare occurrence, I admit, but a possibility...
  9. EdwinGene

    Pull the most current record

    You don't give much detail about the structure of table foo, so I'm going to make a few assumptions. 1. A person can have more than one record in table foo. Otherwise why would you need find a way to select the most recent? 2. There must be a way, in table foo, to determine which records are...
  10. EdwinGene

    Puzzler

    OK. I can see now that I was so used to using queries to return matched records that I was thinking of this query in the same way. But it isn't the same, its the opposite. This query is returning unmatched records. So if I insert a filter which decreases the number of matched records, the...
  11. EdwinGene

    Puzzler

    This is not a critical production question, only something I have found that I can't figure out. I have this query that returns 103,038 records: Select a.RecId From dbo.TableA a Left Outer Join dbo.TableB b on b.TableA_RecId = a.RecId Where b.RecId is NULL If I modify this...
  12. EdwinGene

    Problem with Insert query

    dgillz, The error means that you are trying to insert an explicit value into the destination table's identity column. This is usually not allowed because SQL Server keeps track of and inserts the unique values into the column to insure that the values stay unique. To resolve the issue depends...
  13. EdwinGene

    Division by zero!

    You're right, James. Sorry. I remembered wrong.
  14. EdwinGene

    Best Way to Select Next/Previous Record

    You didn't want to do that. I misread your original post. I thought you wanted to access the columns in record key order. If all you want to do is get the next record, regardless of the value in the record key column, the identity column would be the best solution.
  15. EdwinGene

    Division by zero!

    In the first place, charindex() will not work, because charindex() looks for only one char. You will have to use patindex(), which looks for a string. Secondly, could you use patindex() to look for '/0)'?
  16. EdwinGene

    Best Way to Select Next/Previous Record

    And when I say RecordKey, I am talking about your 'record 12', 'record 17' column.
  17. EdwinGene

    Best Way to Select Next/Previous Record

    That's what the 'Where' clause is for. It finds the smallest record key which is larger than the current record key.
  18. EdwinGene

    Process 52... c0000005 EXCEPTION_ACCESS_VIOLATION

    Full Error Message: SqlDumpExceptionHandler: Process 52 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION SQL Server is terminating this process. I can't post the stored procedure for proprietary reasons. Suffice to say that I have put statements into the stored procedure at...
  19. EdwinGene

    Best Way to Select Next/Previous Record

    You don't say what the value is in your "distinct record key". For the purposes of this reply I am just going to assume that the "distinct record key" is unique, numeric, non-sequential (meaning there are gaps), and not in order. Declare @RecordKey Int -- Get the first "distinct record key"...
  20. EdwinGene

    Process 52... c0000005 EXCEPTION_ACCESS_VIOLATION

    I'm running a stored procedure, and when it finishes I get the fatal exception error in the subject line. I have traced through the stored procedure, and it seems to complete normally, so it looks like this error is generated after the stored procedure completes, but before control returns to...

Part and Inventory Search

Back
Top