the join hint, I do know exactly the situation, since table1 is a small size, and view is a really big size, I tried in real-time query and had this...

Great thanks everyone!!!

I know it's hard to determine the actual problem without actual definition, even I have them on my hand but still can't tell why.

Yes, I just pasted the...

Definition of view1:

"SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[view1]

AS

Select *

From table1 t1

Left hash Join view v on t1.id = v.id"

Definition of "view":

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

create VIEW dbo.view2

AS

SELECT t2.id,...

HowardW (5/8/2012)

---

I'm pretty sure a truncate will always result in a TABLOCK until the transaction is committed. Rather than using a partitioned view (even if you somehow got around the...

Good question, it's actually the same scenario I am facing right now!!!

But I still have some questions:

#1 - I am using a partitioned view to union two tables, one is...

I have the same problem.

While I am not updating a single row but instead I need to truncate the whole table and re-insert from a view, so in this case,...

princa (6/16/2011)

---

Lowell (6/16/2011)

---

yes, opc.three's comment is the key; i testest it to make sure...for me i created a suite of tables and then 4 different functions and procs, all with...

Lowell (6/16/2011)

---

yes, opc.three's comment is the key; i testest it to make sure...for me i created a suite of tables and then 4 different functions and procs, all with GO...

Lowell (6/16/2011)

---

yes, opc.three's comment is the key; i testest it to make sure...for me i created a suite of tables and then 4 different functions and procs, all with GO...

Brandie Tarvin (6/16/2011)

---

princa (6/16/2011)

---

Lowell (6/16/2011)

---

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and...

Lowell (6/16/2011)

---

see opc.three's post from the thread below;

i learned something here, since i was used to think that GO + BEGIN TRANS were not compatible, and now i know...

I tried everything I could to make sure the permission issue, still got the error message that I couldn't load the package!

Then I tried to use comdexe to execute the...

WillyWonka (12/21/2007)

---

This is a common problem. The SQL Agent needs to have ownership of the package before it can run it as a job. Since you created it...

I searched a lot online, and followed the procedures...even though I still get this when I try to schedule a job in agent job:

===================================

The package failed to load due to...

I checked the SQL Agent Server account, it uses local system as log on account. So need to modify local system's permission on directory and SQL Server?

Thanks