Yes, you would use a Foreach loop. You would use the Foreach ADO Enumerator.

2. How do I get hold...

Hey Brandie,

I don't think there are any issues with running Developer and Express side by side.

Full-Text search comes with the Express with Advanced Services download both in 2005 and 2008....

Other than the fact that the 3 instances will be contending for the same resources you can install 2008 alongside 2005.

If you are new to SQL and triggers I would recommend you read this article so you avoid some common mistakes made in triggers: http://www.sqlservercentral.com/articles/Triggers/64214/

jacopasto (10/29/2008)

---

Many thanks Jack.

The sql retrieve the two notes. How i can design the query to retrieve more than two the notes (the text is different as the call result's...

Correct there is a lack of a start time so you would need to continue to start the trace the same way you are doing it now, but you could...

Duplicate post. Please answer here: http://www.sqlservercentral.com/Forums/Topic593709-1063-1.aspx

sp_trace_create has the @stoptime parameter that you can set. When you start a trace that has the stop time set the trace is stopped and removed when the stop...

Ahhh, thanks for letting me know. I wonder if they have looked at changing (reducing) the recovery interval on the SQL Server so the DB Engine issues CHECKPOINTS more...

So you want a generic query that returns the data from 1/1 to 3/31 of the current year?

If so here's one way to do it:

Declare @start_date datetime, @end_date datetime

Set...

Glad I could be of help. As for recommending the "IN", I'm glad you were using it in the real trigger, most of the time people who post about...

No they are not logged. May I ask why you are manually setting checkpoints? The Database Engine does this automatically to reduce the recovery time needed on restart.

I recommend:

Expert SQL Server 2005 Integration Services (Programmer to Programmer) by Brian Knight and Erik Veerman (Paperback - May 29, 2007)

Professional SQL Server 2005 Integration Services (Programmer to Programmer) by...

Since you are using SQL Server Express you will need to install it, if it does not already exist on each PC your application is installed to. If you want...

The first query is eliminating all rows based on the table BEFORE running the view so there will be fewer rows touched because the filter is on the TABLE. ...