Post reply

hi

  • December 2, 2008 at 7:51 am

    #216027

    In Sql2000 Transaction replication i am getting this error

    Timeout expired

    (Source: ODBC SQL Server Driver (ODBC); Error number: S1T00)

  • December 4, 2008 at 12:57 pm

    #907878

    I had this problem, I solved it by placing the "QueryTimeout" in my SnapShot agent...

    -QueryTimeout 1600

    try looking

    http://www.devx.com/codemag/Article/21112/0/page/4

    its Figure 7 (press EDIT)

    than add the "-QueryTimeout 1600" in the Figure 8

    You will need the "-" symbol...

    The parametre is optional with a 300 default,

    I had a table with over 3mil row, so I needed more than 300 seconds to replicate it.

    I hope it will work for you...

    BTW, after solving this problem I had an other one...

    The process could not bulk copy out of table TABLENAME

    I don't remember how I fix it (I changed some value in some property of the replication), cuz after fixing it I ran into a HD free space error so I said "F... it" and don't made any other test yet.

    I have this link in my I.E. history

    http://qa.sqlservercentral.com/Forums/Topic537506-7-1.aspx#bm603216

    maybe is you got the same error it will help you out.

    John

  • December 4, 2008 at 12:59 pm

    #907881

    Oh yeah!

    Maybe the subject "Hi" is not enough to get other response... try placing better subject... 😀

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply