SQL Server 2000: .NET and the Death and Re-Birth o

In this month's article I will cover an aspect of SQL Server that always generates a great deal of, well, shall we say "discussion"—triggers. Love them or hate them, SQL Server 2000 will change they way you think about triggers and will probably alter the way you design your applications. Specifically, this month I will dive into cascading referential integrity (RI) and the new INSTEAD OF and AFTER trigger concepts in SQL Server 2000.

Blogs

Adding a License to GitHub

By

I’ve rarely thought about licensing my code, but it’s something to be aware of...

Weekly reading #29

By

The Data Breach Game: The 9 Worst IT Security Practices Joey D’Antoni shows bad...

#PowershellBasics: Get-Help -Online

By

One of the other things I learned from the Powershell class I’m taking this...

Read the latest Blogs

Forums

NULL(DT_DATE Variable in SSIS

By mcfarlandparkway

i have a variable in my SSIS package called Name                 datatype          value                       expression lastupdated     ...

Minor code change will it make a difference.

By sizal0234

  Please let me know your thoughts on the below. Updated a small portion...

Newbie Q: Restore fails with "Database in use"

By kranitz

I'm apparently very late to the game here - I intermittently (reluctantly) end up...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers