Tag Archives: SQLNewBlogger

Modifying a Trigger to Capture More Info: #SQLNewBlogger

I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to detect more changes and using that information. Another post for me … Continue reading

Posted in Blog | Tagged , , | Comments Off on Modifying a Trigger to Capture More Info: #SQLNewBlogger

A Basic Update Trigger: #SQLNewBlogger

I had someone ask me about using triggers to detect changes in their tables. As I explained a few things, I thought this would make a nice series, so I’ve written a few posts on triggers that can be useful. … Continue reading

Posted in Blog | Tagged , , | 6 Comments

Create a Linked Server: #SQLNewBlogger

I had a customer recently that was asking about Linked Servers and some development advice. I was going to show them a few things and realized I hadn’t created a linked server in my demo environment, so I did it … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Create a Linked Server: #SQLNewBlogger

Can I Change a Primary Key Value? #SQLNewBlogger

I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of that. Another post for me that is simple and hopefully serves … Continue reading

Posted in Blog | Tagged , , | 1 Comment