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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by laradegroot

  1. laradegroot

    Script don't work

    Assuming you are using SQL Server Enterprise manager to check your database, I sometimes have to exit this program and reopen it before changes have taken place. In any case, helping you would be a lot easier if you would also list your code! Good luck! Lara
  2. laradegroot

    exclude null values

    I'm not quite sure why you would want to use the "nolock" statement this way, but the code select col_a from table (nolock) where col_b is not null should work (also without "(nolock)") Good luck! Lara
  3. laradegroot

    Select statement using variable values - Why doesn't this work?

    Since @TableSelect is a variable and not a table, you cannot select * from @TableSelect. However, changing your last statement to: select @TableSelect as 'TableSelect' Will result in a row called TableSelect with the output "admin.customers". Good luck! Lara
  4. laradegroot

    MSDE and ListAvailableSQLServers problem

    Oh, by the way, I found a post somewhere on the internet about DISABLENETWORKPROTOCOLS which has to have the value 0 to be able to appear on the network, but I have already installed the MSDE with this switch and it still doesn't work. Any other ideas????
  5. laradegroot

    MSDE and ListAvailableSQLServers problem

    Hi all, I'm am trying to list the names of all SQL database servers on a network, but somehow the MSDE servers don't show up in the list when I use the ListAvailableSQLServers command. Does anyone have any ideas on why this is happening?? How can I make sure the MSDE servers can also be found...
  6. laradegroot

    Strange date formatting problem

    Okay, I found the problem. Somehow my regional settings (US) were not affecting VB. Therefor it did not recognize that "Mar" was the month of March. Problem solved, thanx a lot for your help!! Regards, Lara :-)
  7. laradegroot

    Strange date formatting problem

    The date is retrieved in the format "May 31 2003 12:00PM" by an SQL-query. The strange thing is that when I try the code you wrote (in an empty project), and that works for you .... it still doesn't work for me (for March and May, it still does work for the other months....) It...
  8. laradegroot

    Strange date formatting problem

    In my application I am retrieving dates from an SQL database in the following format: Feb 5 2003 12:00PM Jan 28 2003 12:00PM Mar 7 2003 12:00PM I'm using the following code to convert this date to an "understandable" format: Format(Date, "dd-mm-yy HH:MM") This works...
See more

Part and Inventory Search

Back
Top