Most of the query cost seems to be in the Key Lookup for DocDataField.FieldValueDateTime in the last outer join in the view.

Try adding a covering index to avoid the lookup.

I...

Some of your variables are set to null along the way. Try to catch it with ISNULL.

BTW, your code is prone to sql injection, I suggest that you revise it...

Try with:

SELECT *

INTO [Server-B].[DB_Name].dbo.NewTable

FROM #temp_table

WHERE FILE_NAME = 'DBName..NewTable'

The reason your OPENQUERY fails is that #temp_table is a temporary table, visible only on Server-A in the session that created it. No...

Let's see what BOL states:

This means that OPENQUERY can be used to execute a query on a remote linked server...

Paul White (2/11/2010)

---

The 'sigh' is a link to today's featured article. I'm away from home an unable to reply as...

Why so sad, Paul?

It's interesting to note that your original syntax doesn't fail in SQL 2005.

Very strange.

Try this way:

select 'Year ending '+ job_date

+' revenue was '+ job_cost

from (

select cast(year(job_date) as varchar(4)) as job_date,

cast(sum(job_cost) as varchar(20)) as job_cost

from job

group by cast(year(job_date) as varchar(4))

) AS data

You can get the jobs scheduled in the time window you like with something similar to this:

;WITH schedules AS (

SELECT *, sTime = REPLACE(STR(next_run_time,6),' ','0')

FROM msdb..sysjobschedules

WHERE next_run_date > 0

),

dt_schedules...

Yes: a database full backup is suitable for that purpose.

Do you have any?

What do you mean exactly with "flags"?

Is any of you willing to help this OP with the correct syntax to get his DB back? I don't remember all the parameters right now...

No, I'm sorry. You should have a backup.

Roy Ernest (2/9/2010)

---

Steve, There is no need for any apology...:-) You cannot control what others write or how others behave. Thanks for removing the comment though. It wont look good...

Is Jeff in that universe writing...