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

    2008 Installation (Service Accounts)

    am in the process of trying to install 2008 using domain accounts for the services and receiving the error "the credentials you provided for the SQL Server Agent service are invalid. To continue, provide a valid account and password for the SQL Server Agent service" I am an administrator on...
  2. sshafe

    Datetime Select????

    SP2 8.00.534
  3. sshafe

    Datetime Select????

    I've ran in both EM and QA. Same results from both.
  4. sshafe

    Datetime Select????

    I am trying to figure out what routine within the software is populating this field. To your question. I can pull the data up through EM and that is exactly what it shows no maninipulation. Is there some kind of switch on the database that I'm unaware of that could cause this? SELECT...
  5. sshafe

    Datetime Select????

    Results: ex_recpt_date datetime no 8
  6. sshafe

    Datetime Select????

    no, but only because all the rows in the tables that are >= 03/23/2006 do not have a time on them. If I change the query to a date that will return rows. (our case 03/22/2006) it will return those rows, but only those rows with the time.
  7. sshafe

    Datetime Select????

    I didn't write this query. It was generated from Profiler from one of our vendor supplied applications. Besides, that is not keeping the query from returning rows. Also, I have commented out the line that is holding up returning rows.
  8. sshafe

    Datetime Select????

    Now I am totally confused....I ran the same query against another database, similiar table, same column, same datatype and IT WORKED???? Here is my query select slot_item.* from item_master, slot_item WITH (NOLOCK) WHERE (slot_item.sku_id=item_master.sku_id AND slot_item.sku_id <> 0...
  9. sshafe

    Datetime Select????

    Still doesn't work.
  10. sshafe

    Datetime Select????

    I am doing a select from a datetime column where > '3/23/2006'. It is not returning rows that do not have a time. What is the deal? Returns - 3/24/2006 3:33:25 PM Does not return - 3/24/2006 Thanks in advance.
  11. sshafe

    DeleteFile Question

    I have got a large number of log files that need to be deleted. Rather than do this manually, I would like to write a quick little script to do this. My question is, how does vbscript handle the deletefile command. I am worried about machine resources being consumed by a large delete. I...
  12. sshafe

    Switching Databases

    I have written a script that loops through a list of SQL Server machines, then the databases inside of the server, then tables. Problem is that I'm currently just using a "use database" command to change to the next database, but for some reason it's not working. I get the message...
  13. sshafe

    Transaction Logs and Backups

    If I'm in simple recovery mode, when are the transaction logs truncated? Is it as soon as a full backup is done? Or do I have to specify a special parameter? Reason for asking: I had a transaction log grow to 13G about 2 1/2 hours after a differential backup. I'm trying to narrow down if...
  14. sshafe

    LogMon to kick off script

    Has anyone every used a tool called LogMon to monitor files? Here's my issue.... I use LogMon to tell when my daily import file has been placed on the drive. Once the file is there, Logmon is supposed to kick off my vbscript to run the actually import. Problem... It only works if I'm logged...
  15. sshafe

    find largest files on a drive

    I am trying to make a list of 5 or 10 of the largest files on a drive. Any ideas where to start? Thanks in advance
  16. sshafe

    strComp not working

    OK, just for other's who might have the same problem as I did, here was the problem....HIDDEN CARRIAGE RETURN... I simply removed it from the string and now it works like a charm :-) Thanks for everyone's help.
  17. sshafe

    strComp not working

    I pulled the strings from the log file I'm writing to and did a compare with those, they did match. So if that's the case and they are indeed the same, why aren't the variables matching within the script?
  18. sshafe

    strComp not working

    I've tried just about everything from putting an extra \ so that it would take the next as a literal to doing =. I've also tried setting them as regular expressions to try and match that way. I'm just don't know what else to try. :-(
  19. sshafe

    strComp not working

    I trim the variables right before this step: strTogether = trim(strTogether) dbfile1 = trim(dbfile1)
  20. sshafe

    strComp not working

    I'm about to pull my hair out with this problem. I am trying to compare directories to make sure the are the same using the strComp. If (strComp(strTogether, dbfile1, vbTextCompare) = 0) then result: no match on C:\DB2\NODE0000\SQL00010 C:\DB2\NODE0000\SQL00010...

Part and Inventory Search

Back
Top