I have had several DTS job failures at various sites.

They normally fall into the following categories,

The SQL agent does not have write permissions to a drive, path or file.

There is...

Thanks for your speedy reply.

There is only one step beyond that of starting the job.

Just a single call to DTSRUN.

I have reset the time schedule and waited to see if...

Some from 2000, some 2005 and some fresh installs with the same schema onto 2008. We have notice the clients are not hotfixed up, so we're starting there. There appears...

This is a server issue. The assembly has installed correctly and worked on many other servers, both 32bit and 64bit.

Its just this particular server. What I am after is why...

Paul White NZ (3/26/2010)

---

First things first. Run the following to see the status of the CLR hosting:

SELECT *

FROM sys.dm_clr_properties;

You will see something like the following...

Gift Peddie (3/19/2010)

---

rich-521822 (3/19/2010)

---

Hi guys

A new email CLR dll, which is tested and fine on a similar system causes a clients SQL server query window to hang when trying to...

I agree with you there performance wise. I have benchmarked queries and it's swings and roundabouts. We have had more memory issues with cursors in 2005 than in 2000 though.

--> the first way I was shown which reminds me of looping with a modulus in c

DECLARE @CatName VARCHAR(20)

DECLARE @Kitty TABLE (CatName VARCHAR(20),Processed INT)

INSERT INTO @Kitty(CatName,Processed)

SELECT 'Pete',0

INSERT INTO @Kitty(CatName,Processed)

SELECT 'Brian',0

INSERT...

--> This can be quite efficient in an old linear style way of getting things done.

--> But its always better to understand your set theory

DECLARE @Kitty TABLE (RowID INT Identity(1,1),...

SELECT CAST(FLOOR(CAST(GETDATE() as FLOAT)) AS DateTime)