what is the query is coming from another server (query is on sql 2008 server to a linked servr that has the indexed view)

that worked, thanks

Sorry hit the enter key to fast.

What I wanted to say is I have a SQL 2005 box attached to an older SAN device. They have just...

Can't change config file. Long story short, trying to disprove that Virtual SQL Server is not issue. TO make life easier needed a physcial box with a different...

whEN i DID THE INSTALL i TOLD IT TO USE NAMED INSTANCE, SQL SERVER CAN'T HAVE SAME NAME AS COMPUTER

One of the developers reminded me there were 2 issues that fixed this. One was the code break, the other was the shared resource that was used by this...

Any chance the sql agent service account does not have rights to a file share/folder necessary for the package to execute?

Odd solution, the issue was the developer had put a code break in a script. It runs in BIDS not as a job, removed the code break and it...

Thanks this is a VM box, I have been getting the error below (not sure if related)

Date2/6/2012 10:30:40 AM

LogSQL Server (Current - 2/6/2012 8:05:00 AM)

Sourcespid91

Message

The client was unable to reuse...

Preaching to the choir,

Use became orphaned, first time I have seen a Windows login do this. They had a few sp's that had an execute as statement that the developer's brought in,...

problem is this is a windows account

Sorry probably confused this, each row of data will look like this

id value

100 'Merged Facility Id:0286- Patient Id:999000 PHPatId:28488...

each column will have data like below

'Merged Facility Id:0286- Patient Id:999000 PHPatId:28488 with Facility Id:0286-C Patient Id:124013 PHPatId:678839'

'Merged Facility Id:0232-C Patient Id:849000 PHPatId:28409 with Facility Id:0282-C Patient Id:189893 PHPatId:478839'

I needed...

Not fixed, the patient id chan be from 3-12 characters long