In a recent project, I need to record audit trail for some tables (for Insert, Update and Delete).Using SQL 2005's XML datatype and the XML support it is very covenienet to use triggers to perform the audit trail requirement. I create one table (Table_Audit) to hold all audit trial data. One stored procedure is created […]
2007-09-20
3,312 reads
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
As a data & AI strategist who’s seen countless projects succeed and fail, I...
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Experts, I am hoping to get some help and feedback. I have a server...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers