[AccessD] SQL - Copy * to another table

Bobby Heid bheid at sc.rr.com
Fri Feb 27 23:18:49 CST 2009


John,

I'd look at @@ERROR and see what all information you can get from that.
There may be related items.  I use SQL from .Net and just catch any
exceptions.

Thanks,
Bobby

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Friday, February 27, 2009 7:57 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] SQL - Copy * to another table

Is there a way to get the SQL error statement back from a stored procedure
into Access?  Or even 
better is there a way to log the error statement inside of SQL Server?  I
could read that table from 
Access if I can log the errors.  ATM I am just catching them in a catch
statement and PRINGing them 
to a window in the query window.

-- 
John W. Colby
www.ColbyConsulting.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list