怎样执行一个大于3m的事务？

fsxzh

我用osql.exe执行一个3M文件的脚本，报错内存不足，有没有办法？我的脚本是一个事务，为了保证数据的完整性不能把它分开，麻烦，麻烦。

seapen

不知你的事务里都做些什么?能说具体点吗?
看看能否在你的事务里,每几步后面跟个go语句试试?

Yuqin

Hi, Fsxzh:  There are two reasons will cost the no space error message. One is in your PC (if you login remoted) don\'t have more free space to oprate the command. or the SQL Server data file drive or log drive don\'t have free space.  For the first reason, you need clear your PC drive to delete some no-user files to make more free space. For the second reason, you either add another data file or log file in another drive which has free space or shirk database or truncact log to see if it will save more space for you.
Hope it helps.

chinesestar

如果事务不太复杂，影响的东西不多，可以尝试多次提交，自己保障事务完整性(出错自已完成回滚)。