artful at rogers.com
artful at rogers.com
Thu Aug 10 09:34:16 CDT 2006
For future reference, it's in the wizard on the last page, Options. Arthur ----- Original Message ---- From: JWColby <jwcolby at colbyconsulting.com> To: dba-sqlserver at databaseadvisors.com Sent: Thursday, August 10, 2006 9:15:47 AM Subject: Re: [dba-SQLServer] SQL Server hanging Never mind, I just found the DTS editor, which is exactly what I needed. 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 JWColby Sent: Thursday, August 10, 2006 8:43 AM 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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com