December 2, 2008 at 7:51 am
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
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://www.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
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