Results 1 to 15 of 15

Thread: FAO Plenderj

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Jul 2002
    Location
    Dublin, Ireland
    Posts
    2,148

    FAO Plenderj

    Data model install scripts attached....

    [list=1][*]run \Data Model\create_printmonitor_db.sql[*]run \Data Model\Tables\inst_db.bat[*]run \Data Model\Views\inst_db.bat[*]run \Data Model\Stored procedures\inst_db.bat[*]run \Data Model\Reference Data\inst_db.bat[/list=1]

    HTH,
    D.
    Attached Files Attached Files

  2. #2
    KING BODWAD XXI BodwadUK's Avatar
    Join Date
    Aug 2002
    Location
    Nottingham
    Posts
    2,176
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT
    VIRUS ALERT



    Naughty boy take over the admin job like me. Legally
    If you dribble then you are as mad as me

    Lost World Creations Website (XBOX Indie games)
    Lene Marlin

  3. #3
    type Woss is new Grumpy; wossname's Avatar
    Join Date
    Aug 2002
    Location
    #!/bin/bash
    Posts
    5,682
    I notice that Merrion has quickly remembered to change the name of the attachment from "Snake_Game.zip" to "Data_model.zip"!


  4. #4
    KING BODWAD XXI BodwadUK's Avatar
    Join Date
    Aug 2002
    Location
    Nottingham
    Posts
    2,176
    If you dribble then you are as mad as me

    Lost World Creations Website (XBOX Indie games)
    Lene Marlin

  5. #5
    Ex-Super Mod'rater Electroman's Avatar
    Join Date
    Sep 2000
    Location
    Newcastle, England
    Posts
    4,349
    I run the files and it Shutdown my internet .






    When your thread has been resolved please edit the original post in the thread ()
    and amend "-[RESOLVED]-" to the end of the title and change the icon to , Thank you.

    When posting Code use the [VBCode]Code Here[/VBCode] tags to be able to use the code highlighting.

  6. #6

    Thread Starter
    PowerPoster
    Join Date
    Jul 2002
    Location
    Dublin, Ireland
    Posts
    2,148
    Your names vill also go on ze list!

  7. #7
    KING BODWAD XXI BodwadUK's Avatar
    Join Date
    Aug 2002
    Location
    Nottingham
    Posts
    2,176
    NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO!!!!!!!!!!!!!!!!!!!!!


    We are dooooooooooooooooooooooooommmmmmmmmmmmmmmmmmmmeeeeeeeeeeeeeeeeeeeeeeeedddddddddddddddddddddd
    If you dribble then you are as mad as me

    Lost World Creations Website (XBOX Indie games)
    Lene Marlin

  8. #8
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170
    I am not domed.

  9. #9

    Thread Starter
    PowerPoster
    Join Date
    Jul 2002
    Location
    Dublin, Ireland
    Posts
    2,148
    Updated Printer_Usage_Reports.sql

    (Added "Documents printed this week")
    Attached Files Attached Files

  10. #10
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    I'll be installing this lot on our server today. I know I said I'd do it earlier, but I'm too lazy
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]

  11. #11

    Thread Starter
    PowerPoster
    Join Date
    Jul 2002
    Location
    Dublin, Ireland
    Posts
    2,148
    No probs. Should be another .exe drop later on this week (To add the filter by document functionality when I work out how to implement it...)

  12. #12

    Thread Starter
    PowerPoster
    Join Date
    Jul 2002
    Location
    Dublin, Ireland
    Posts
    2,148
    Note: when you install MSDE and the PrintMonitorServer you should go to the "Event Viewer" app and set the Application log settings to "Overwrite log entries as needed" because it soon fills up with all the various SQL server messages

  13. #13
    Retired VBF Adm1nistrator plenderj's Avatar
    Join Date
    Jan 2001
    Location
    Dublin, Ireland
    Posts
    10,359
    Righty. Seems to be going okay. That last set of installation files went perfectly with the batch file you wrote. Very nice
    Anyway, I had to re-import the actual report data/sql statements. Perhaps you could implement that into the table insertion script?

    Its up and running now so I'll see if it has recorded anything later.
    Microsoft MVP : Visual Developer - Visual Basic [2004-2005]

  14. #14
    type Woss is new Grumpy; wossname's Avatar
    Join Date
    Aug 2002
    Location
    #!/bin/bash
    Posts
    5,682
    Originally posted by Merrion
    Your names vill also go on ze list!
    Don't tell him your name Bodwad!



    Dad's Army is teh ub3r r0x0rs.
    I don't live here any more.

  15. #15
    KING BODWAD XXI BodwadUK's Avatar
    Join Date
    Aug 2002
    Location
    Nottingham
    Posts
    2,176
    That was a good program. Funny and witty.


    Now all we have is 'The office' YAWN BORING


    I was watching Naked gun and almost laughed my pants off. Getting airplane soon
    If you dribble then you are as mad as me

    Lost World Creations Website (XBOX Indie games)
    Lene Marlin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width