Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need help on a query
Run this query to generate your alter table statements: select 'ALTER TABLE ' + o.name + ' DROP COLUMN OBJID' from sysobjects o where o.name like 'ADP%' Then run the output.- BradJones
- Post #2
- Forum: Microsoft SQL Server: Programming
-
Saving Error Message to Variable (ala @@ERROR)
Jnicho2, Thanks for the info and your help. However, I was not having a problem storing the @@error (which is the numeric error code): "208" Nor was I having a problem selecting the generic error from the sysmessages table (which your query would return): "Invalid...- BradJones
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Saving Error Message to Variable (ala @@ERROR)
I would like to save the error message that SQL-Server generates when an error occurs. I am able to select @@ERROR to get the the error number and I am then able to look up the generic error message from the sysmessages table. However, the sysmessages is generic and does not have, for example...- BradJones
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
