Reasons for log file size increase? One would be that you are in the Full Recovery model, and the transaction log will grow without a log backup because the...

Robert Davis (6/2/2012)

---

Are nested triggers disabled?

Select value_in_use

from sys.configurations

where name = 'nested triggers';

Instead of triggers are executed before an after trigger, and if nesting is disabled, the insert from the instead...

Here's another question for you. What security context is the 2nd trigger executing under? I'm guessing you do, but a check would be if you have permissions on...

Hmmm...that is really odd. I'd dumb down the AFTER INSERT trigger to do something as simple as an INSERT into a tempdb table just to see if it is...

Which statement completed?? Try SP:StmtCompleted. I can't seem to recreate your problem in my personal environment. Your code works for me.

I'm thinking it may actually be firing...

Have you enabled TCP/IP for your SQLEXPRESS named instance? This can be done through the SQL Server Configuration Manager (Start -> Run -> sqlservermanager10.msc). By default, a SQL...

Out of curiousity, in your production (not working environment), does your INSERT statement have col3 set with a value of either 73 or 199? If it doesn't, then you...

Jeff Moden (6/2/2012)

---

Thomas Stringer (6/2/2012)

---

Ok, I'm not saying it is going to outperform T-SQL 100% of the time. Making a broad generalization like that would be foolhardy.

But sometimes it...

Ok, I'm not saying it is going to outperform T-SQL 100% of the time. Making a broad generalization like that would be foolhardy.

But sometimes it may be more efficient...

opc.three (6/2/2012)

---

Thomas Stringer (6/2/2012)

---

SQLCLR is an excellent tool, and there are just some things that can't be accomplished with pure T-SQL. Mostly the Windows environment, and aspects outside of...

SQLCLR is an excellent tool, and there are just some things that can't be accomplished with pure T-SQL. Mostly the Windows environment, and aspects outside of the instance. ...

A few options are linked servers, PowerShell (executing desired code across multiple servers), and CMS (Central Management Server). How often do you want to do this and what's the surrounding...

Steve Jones - SSC Editor (5/30/2012)

---

Powershell can work outside of SQL Server and is less cumbersome than stringing scripts through SQLCMD. That provides a good way to handle administrative tasks,...

Shared locks are compatible with other shared locks, so you shouldn't be experiencing any blocking from your explained scenario. It is also worth noting that read committed transaction isolation level...

No, you won't need to do this. It is typical practice, that if you have SQL Server that is running on a box that may have memory pressure and...