Very much agree on caution. That was the reason I was installing in DEV.

thanks

I was actually on the 2008 install screen in our DEV environment, and decided a search and SQLServerCentral question for any known issues would be worth a day delay.

W/o a ddl trigger (which this is a good fit) it could be a simple SqlAgent job.

** note this assumes the where is removed, not commented out

if exists(

select * from...

A clustered index does not create a primary key on a table. However on the right column it accomplishes the same tasks.

A clustered index does not have to be...

Couple softballs you may have already tried.

What database is the T-Sql set to run in?

Can you put a table insert (testDatabases) with the values for the backups statement. Confirm...

Paul,

Slick bit of sql.

Specifically the range table with only the relevant ranges and the Outer Apply. Thanks for the couple new tools in the tool belt.

Daryl

There are a myriad of assumptions and the result is not cleaned for combining like ranges for result.

: script uses numbers table used to create date range from beg/end-date

;WITH cteMonths...

A method needs to be found to identify which row to update. This method has an ID field that uses MIN. A more common strategy would use a...

Would it be possible to split the work?

Server A calls a proc on Server B that gets/creates a smaller subset of data in an actual table for this data only....

I am also looking into a common job failure step (error message, server, jobname) for Sql jobs.

I am unclear on $(ESCAPE_NONE(JOBID)).

?

thanks

IwantRoot,

Did you ever discover the culprit for this issue?

I am having a similar issue with a 2005 sp3 box.

The performance starts to hang on a fairly common screen query. ...

I did not spot the location, however idea.

Select * instead of list (for debugging) if the syntax error still exists you know to look in your join/where sections.

Couple of things to try.

Composite index on alias MT table.

Derived table

inner join ( tableMT inner join table CA) as MTCA on MT.categoryType = MS.MatchCategory

Are there any triggers on the table?

I addressed this issue with a batch replication process put in place for a third party app's database.

Create a backup sproc that uses a naming standard (and dates). Schedule...