[dba-SQLServer] SQL Server hanging

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








More information about the dba-SQLServer mailing list