we have just told our users to export as pdf, and print from that, in the meantime.

We also ran into this problem in a managed environment, it works on the dev machines where the user has full rights, but not on the workstations in a managed...

Its definately memory related, and the fact that restarting the Agent suggests that its the agent that is leaking the memory.

If anybody can reproduce it easily, perhaps we can send something to...

I too am receiving a similiar error on a couple of my dts schedules out of 1,000.

When I restart the agent service the errors go away for a few days.

Executed...

I have used all the tools in SQL server 2005 beta2 and no its not sluggish when you understand the processes that are going on.

Its about the same speed as...

What a boring article, has no useful content, except to say you successfully installed the beta2.

Please explain...

"DO NOT Cast datetime to any type of int !!! "

I am a developer and I make live adhoc changes all the time. the syntax checker on sql server catches typos, normally its to fix things that aren't working correctly...

My experience is that the case statement is slow when the optional parameter is NULL, I converted all my sp's to use the dynamic sql EXEC, turned out to be...

How would I get the following example of selecting fields from a stored procedure to work?

CREATE PROC usp_Test_SPExec

As

SELECT 1 As Field1, 2 As Field2, 3 As Field3

GO

SELECT Field1, Field3

INTO #Temp

FROM...

Yukon boosts that they have now fixed this problem of runaway processes

quote:

---

temp table is written to tempdb and that IO will be very slow

---

Dont forget that...

I agree with hanslindgren, if you look at the Execution Plan of both the "NOT EXISTS" and "NOT IN" you'll find it is exactly the same! sometimes on complex queries...