Hi Bose,

I would imagine that connwizr20.dll is not a COM dll so that is probably nothing to worry about - what is the return value of hr now? Is it the...

On way of doing this would be to create a temp table with every date in your date range in it - so in your case:

RefTable:

1 Jan 2004

2 Jan 2004

3...

Somthing like

SELECT

[InvoiceData].* ,

CASE WHEN [InvoicePayment].[Amount Paid] IS NULL THEN 0.0 ELSE [InvoicePayment].[Amount Paid] END AS [Amount Paid]

FROM [InvoiceData] LEFT JOIN [InvoicePayment] ON [InvoiceData].[Invoice no] = [InvoicePayment].[Invoice No]

Should do...

Bose,

CoCreateInstance returning  0x80040154 (which is the same as -2147221164 signifies Class not registered so I would suggest finding the SQL CE dll and running...

If mem usage is high then I would check page file usage during these slow downs - page reads - writes etc and see if this is higher than when...

Another thought if you can do this safely:

Why not do the following:

1. drop the previous days purged table
2. alter the main table and rename it to be the purged table
3. create a new...

IIRC it is also worth noting that when changing from simple to full recovery the actual change only occurs after taking a full backup so you should schedule one as...

You cant restore 2005 backups to SQL Server 2000, you would have to use BCP or some similar mechanism to move the data.

- James

Hi there,

It sounds like you need a cross tab query (rows become columns and vice versa). The article here: http://www.sqlservercentral.com/columnists/plarsson/pivottableformicrosoftsqlserver.asp gives good coverage of how to achieve this in the various versions...

A few more ideas on stuff to check..

Is anything strange happing in the output of sp_who2 during the slow down? Is there anything/body who is always there during a slow...

Have a look here: http://msdn2.microsoft.com/en-us/library/ms141701.aspx 

Basically you can set the type of the step to SQL Server Integration Services package execution which will do what you want.

- James

Have a look at:

http://msdn2.microsoft.com/en-us/library/ms162810.aspx

- James

Whats the value of hr returned?

- James

Robert,

That query is never going to run that nicely you are better off rewriting it slightly. I persume you want all of the users in users (primary key name, age) who have...

You can do this pretty quickly in C# if you are using windows authentication:

The following C# will take two parameters - the first is the name of a script...