2010-10-14
2,939 reads
Tom Brown
2010-05-07
3,601 reads
Using Triggers for Detective Work
When a value is changed that causes an error, finding what caused the error can be tricky. Here an application was truncating a column. The trigger helped to identify the culprit.
2008-09-25 (first published: 2008-07-17)
1,381 reads
Blogs
Daily Coping 5 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Daily Coping 4 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
pivot multiple columns and transpose to same row sql server
I have a table like below: CREATE TABLE #Test (Category_ID INT, [Type] VARCHAR(2),Student_ID INT,...
GRANT CREATE SEQUENCE syntax error
Hello experts, I am getting this error Msg 102, Level 15, State 1, Line...
Missing Integration Services Catalogs folder in SSMS
I've developed an SSIS Package that I need to deploy to a remote server,...
Ask SSC