CTAS

Technical Article

RE: SA Password

  • Reply

Jon McMullin - You need to read the rulles before posting unhelpful comments.People need to know that they can post their problem here without people sneering at them - we've all done silly things, but hopefully we learn by them. 

2005-02-25

Technical Article

RE: SQL SERVER 2000 trigger for Audit trail

  • Reply

Something like this should get you most of the way: create TRIGGER [name] ON FOR INSERT AS update set created_by = SUSER_SNAME(), last_modified_by = SUSER_SNAME(), date_created = GETDATE(), date_last_modified = GETDATE() from inserted where .Seqno = inserted.seqno; create TRIGGER [name] ON FOR UPDATE AS update set last_modified_by = SUSER_SNAME(), date_last_modified = GETDATE() from inserted where […]

2004-07-29

Blogs

Types of data consulting engagements and what you can expect from them

By

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Daily Coping 6 Dec 2022

By

Today’s coping tip is to find a new way to tell someone you appreciate...

What’s next: Job search burnout

By

I was given 4.5 months notice this past June and was fortunate to find...

Read the latest Blogs

Forums

Stairways to ScriptDOM Level 4 – Finding Nuanced Patterns

By Diligentdba 46159

Comments posted to this topic are about the item Stairways to ScriptDOM Level 4...

The Availability Group Secondary Connection

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Availability Group Secondary Connection

SSRS Expression Error

By Jeffs1977

I am getting the following error when I try to use the Expression below....

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers