Never heard of such a thing happening.

How long does the delete take?

What are the indexes?

What is the locks taken by the delete?

The Trigger fires AFTER any insert or update to table XYZ. The trigger code executes in order it is written in. So your example the order would be:

1....

If you are doing this in a stored procedure I'd probably do an IF statement like this:

IF @regionId IS NOT NULL

BEGIN;

...

Guras (3/6/2012)

---

DB - SQL SERVER 2008 R2

The size of the log file is 24G and the database is internally fragmented. The total number of the VLFs is more than 300....

Shouldn't be privileges as the SQL Agent Service Account is granted sysadmin rights on the SQL Server. You'd only have permissions issues if you were trying to access something...

Koen Verbeeck (3/6/2012)

---

cvyc06 (3/6/2012)

---

You are right. Not just here but in almost every forum I see an increasing number of questions on very basic concepts. Perhaps RTFM should...

Can you try running one of the DBCC CHECKDB commands listed in the T-SQL window by itself and see if you get a better error message?

You can also run this...

Sounds to me like you will need to use a script component in your data flow. In the script component you can use the Split function on that specific...

One tool I don't see on your list is SQLSentry PerformanceAdvisor which is a very good tool for performance monitoring. It does have email alerting, but I don't think...

I ahve to agree with Joe and Jason here. There are some inconsistencies in where you can and should put the terminator. In fact you BEGIN and END...

By default all users created are added to the PUBLIC role. This is because there is a need for some access to metadata for all users. There are...

I'm going to make a couple of comments.

1. Concatenating text to create a SQL Statement in the application leaves your application vulnerable to SQL Injection. You should search...

I agree with Gianluca. There really doesn't seem to be a reason that this won't perform well with more rows, since this is still a set-based operation.

I agree that you should identify a natural key in each table, but I'm not sure you have one in either table structure you have defined.

I'm assuming that this is...

I think this, https://connect.microsoft.com/SQLServer/feedback/details/587897/connecting-via-a-linked-server-to-an-access-2010-database-file, might address your issue. Be sure to read all the comments and workarounds.