Recent content by EdwinGene

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

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

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.

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

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

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

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

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

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

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

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

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

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

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.

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)'?