Martin Reid
mwp.reid at qub.ac.uk
Thu Aug 10 08:12:19 CDT 2006
John Look up Insert Commit Size re DTS Soorry my server is down at the moment so cant check it for you. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 ________________________________ From: dba-sqlserver-bounces at databaseadvisors.com on behalf of JWColby Sent: Thu 10/08/2006 13:42 To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL Server hanging >using DTS, you can adjust the "commit after # rows" level. Is this possible using the DTS wizard? I am not able to find this property anywhere and of course the help doesn't. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of artful at rogers.com Sent: Wednesday, August 09, 2006 5:19 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] SQL Server hanging Assuming that you are importing the data using DTS, you can adjust the "commit after # rows" level. Cut it back to say 100 or 1000 rows and then see what is happening. ----- Original Message ---- From: Martin Reid <mwp.reid at qub.ac.uk> To: dba-sqlserver at databaseadvisors.com Sent: Wednesday, August 9, 2006 4:04:10 PM Subject: Re: [dba-SQLServer] SQL Server hanging John Try and run a trace on the server and database your importing to. Open SQL Proflier -> File -> New->Trace See what that shows you. Martin Martin WP Reid Training and Assessment Unit Riddle Hall Belfast tel: 02890 974477 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com <http://www.databaseadvisors.com/> _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com <http://www.databaseadvisors.com/> _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com <http://www.databaseadvisors.com/>