Forum Replies Created

Viewing 15 posts - 7,066 through 7,080 (of 7,498 total)

  • RE: Select Query

    Don't worry, must have been a top-secret question

    I see a blank message too.

    have a nice day

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 19, 2004 at 4:51 am

    #503287

  • RE: difference between localhost and (local)

    is tcp/ip enabled to be used for sqlserver ?

    If I'm correct (local) uses namedpipes

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 19, 2004 at 12:09 am

    #503260

  • RE: SQL Agent Question

    IMO jobs are "posted" into the active sqlagent-memory. This is done at startuptime of sqlagent or at job-modification time when you use the propre sp's.

    Allerts with joblaunch are intercepted by...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 16, 2004 at 12:12 am

    #503075

  • RE: Joining on and Grouping by CASE function column alias

    I don't know if your Grouping is realy needed (all selected columns are involved), but here's me shot :

    -- @U_Untagged_T_Tagged_PctSign_All  = '%' for ALL rows

    --                                                        'U' for Untagged

    --                                                        'T' for Tagged

     

    Alter...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 16, 2004 at 12:06 am

    #503074

  • RE: DTS and/or job autorization, anyone?

    "However, when I schedule a job on SQL1 with the statement 'select * from SQL2.northwind.dbo.categories' the job runs fine; dito for SQL3. And when I execute the package directly, it...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 15, 2004 at 7:45 am

    #502930

  • RE: DTS and/or job autorization, anyone?

    No, when you open the dts-package and run it, it uses your client-stuff.

    I didn't notify in your previous post that you ran it OK with...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 15, 2004 at 7:32 am

    #502925

  • RE: DTS and/or job autorization, anyone?

    does the sqlserver-service account or the sqlagent-service-account have network authorities to make the connection ?

    When you run it using EM, it also uses the rights you - as a windows...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 15, 2004 at 6:36 am

    #502906

  • RE: Best data type for storing "Hours"

    as long as no one  will use your "hours"-column for timecalculations, all workarounds may be fine.

    If you want to perform timecalculations, be more strict...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 15, 2004 at 4:50 am

    #502876

  • RE: Joining on and Grouping by CASE function column alias

    or use a nested table expression :

    SELECT T1.NewColumn, Table2.SelectCol2, count(*) as Counter

    from ( select *

    CASE WHEN Table1.Name LIKE '%FOO%' THEN 'FOO TOO'

    else Table1.Name

    END as NewColumn

     FROM Table1) T1

    inner JOIN...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 15, 2004 at 4:17 am

    #502871

  • RE: To Default or not to Default

    my Ying  says its basicaly the same, but with usage-constraints

    my Yang says "use the defaults because some...

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data and code to get the best help

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Who am I ? Sometimes this is me but most of the time this is me

    April 15, 2004 at 1:11 am

    #502850

    • Viewing 15 posts - 7,066 through 7,080 (of 7,498 total)