Also try sp_databases

You could create view of the table table [Person] with all first names = 'John' , and then use the BCP program to bulk copy the data out of that...

James, tried it again and that bug is fixed. Thanks.

Thanks, Good site but noticed one minor bug....if you have a database collate statement in a select statement it will format it but not correctly, and give an error message...

Try this sql.....

use master

BACKUP LOG "your database" WITH TRUNCATE_ONLY

use "your database"

dbcc shrinkfile ("your database log file name", 0)

Try this command from QA, with the correct path for your error log location, and look for the keywords you want such as warning , log full etc...

EXEC sp_readerrorlog 1,...