Viewing 15 posts - 4,996 through 5,010 (of 6,216 total)
Was digging around MSDN found this:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23ld.asp
Basically says the error happens because underlying data page moves. Do you have a link to where MS says they fixed the bug?
Andy
February 5, 2002 at 12:44 pm
Try setting your compatibility level back to 70 to see if that makes a difference.
Andy
February 5, 2002 at 12:35 pm
Wouldnt be too hard to write a VB loop that would open each package and then save it on the new server. Dont know about the web assistance stuff, there...
February 5, 2002 at 10:57 am
I typically change the db to dbo only, then run sp_who to check for connections and kill them as needed. That gets rid of current connections and prevents new ones.
Andy
February 5, 2002 at 10:55 am
DMO (or SQL-DMO) is an object framework that gives a programmer access to SQL Server and its objects (and to some extent the data).
John - interesting. Brian K is out...
February 5, 2002 at 10:53 am
Are you sure nothing got changed after the sp got applied? Might be worth re-applying just to make sure
Andy
February 5, 2002 at 10:42 am
Especially if its a one time or off peak job I'll usually break the deletes up into chunks. Its one transaction and 2 mil rows is a BIG transaction!
Andy
February 5, 2002 at 6:19 am
Are you dynamically constructing the insert? Merge will have added a rowguid col to the table, this is probably causing the error.
Andy
February 5, 2002 at 5:29 am
Sounds like a connectivity issue. You can change the amount of logging SQL does, take a look at the verbose switch for the agent, might help you track it down....
February 4, 2002 at 5:55 pm
John, I have to question your comment that running DTS via VB runs all the data through the client. Not impossible mind you, just haven't ever tested to see yes...
February 4, 2002 at 5:51 pm
Access 97 was like that, but Access2K enforces the limit at design time. Not sure which method I like better!
Andy
February 4, 2002 at 5:48 pm
Not sure why running in one place or the other would make a difference. I'd bet its the data dropping out of cache that's hurting you rather than the query...
February 4, 2002 at 5:47 pm
Cool - I'll try to experiment tonight if I can get everythign working at home so I have a tape to test with.
Andy
February 4, 2002 at 1:41 pm
Didnt that bug finally get fixed in a service pack?
Andy
February 4, 2002 at 1:40 pm
Viewing 15 posts - 4,996 through 5,010 (of 6,216 total)