Forum Replies Created

Viewing 15 posts - 6,646 through 6,660 (of 7,499 total)

  • RE: While Inserting record through trigger on remote server through linked servers, SQL Server gets hanged.

    there can be tons of reasons why it gets stuck

    - how is your linked server defined

    - problems with the network ?

    - is the...

    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 14, 2005 at 12:32 am

    #552600

  • RE: How to know if row was updated or deleted?

    Rowversion is a sysnonym for timestamp datatype.

    This timestamp-column is (automaticaly) altered every time the row is updated.

    What can it do ? Just indicate if the row has been changed since...

    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 14, 2005 at 12:24 am

    #552597

  • RE: Reading Files From A Directory

    maybe http://www.sqldts.com has the answer.

    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 13, 2005 at 11:36 am

    #552504

  • RE: Unable to Edit/Delete Job

    Is this job origination from another server ? (check the "target server(s)" pane when you edit the job)

    You could try to alter the job so it only runs local, or...

    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 13, 2005 at 11:34 am

    #552502

  • RE: This is a hard week to me

    If you have sqk2k, script the dts-package as visual basic and then search for the DTSStep_DTSExecuteSQLTask_3.

    This way you may find your way using the gui to repair/intervene the issue....

    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 13, 2005 at 6:27 am

    #552383

  • RE: How to Configure Reporting Services

    search this site for "reporting service" and you'll find enough to start 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 6, 2005 at 5:43 am

    #550740

  • RE: How can I pick mid month?

    my 2ct (not knowing the exact buisiness rrule)

    select  case when day(getdate()) > 14 then

       DATEADD(d, -1, DATEADD(m, 1 + DATEDIFF(m, 0, getdate()), 0))

    else

      convert(datetime,cast(year(getdate()) as char(4)) + '-' + cast(month(dateadd(m,1,getdate())) as char(2))...

    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 6, 2005 at 1:27 am

    #550705

  • RE: connection problem

    "server=localhot;uid=sa;pwd=;database=Northwind" 

    I guess you want to connect local.

    Try server=.

    or server=localhoSt

    btw : even on dev/test server it is not wize to have sa-password...

    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 6, 2005 at 1:07 am

    #550698

    • Viewing 15 posts - 6,646 through 6,660 (of 7,499 total)