I would add "Professional SQL Server 2008 Internals and Troubleshooting" to the list alongside Kalens book, I've been reading through it over the last few weeks and it is excellent.

If you are looking for a defrag script then I would recommend Michelle Ufford's at [/url] it does anything you could ever need.

Definitely follow Toby's advice in the first instance, if this does not work then can you tell us a little bit more about the installation process please?

Is this a named...

There are lot of differences between the two, but to help I need to better understand what replication topology were you thinking of and how were you thinking of using...

Hi Arif,

You're correct in that xp_Sendmail does have quite a few dependencies, I've not used CDOSYS before and thought that xp_Sendmail might be a viable alternative for you.

Rich

Are these DTS packages stored in the file system or in SQL Server itself?

If it's in SQL Server it might be worth running DBCC CHECKDB on the MSDB database.

Do you...

Have you tried using xp_Sendmail?

Shouldn't you be trying to extract the code from your source control system rather than the database?

I think you need to change the AddressNo attribute from FLOAT to VARCHAR .

This should fix your problem.

Did you type this in, or was this generated by the "Set values" tab in the step of the job?

This sounds like your error to me: kb 307288

hth

Rich

Look into setting up a proxy account for SSIS this should help fix your problem. It will allow you to run the SSIS package under a different credential. A 5...

I believe it will be one implicit transaction. To be honest I would consider using SSIS for this kind of work for the kinds of voulme you are talking about.

It looks like you want to sum the results of your unioned query try something like this:

SELECT [State], SUM(Field1) [Field1], SUM(Total) [Total]

FROM

(select

state,

count(*) [Field1],

0 as total

from tAccount

AND datestamp >=...

Maybe not in the article itself, but having a...