Thanks for your reply

rbarryyoung - What I want to do is toi snag the first few lines of each deadlock graph to see if there's a common pattern among...

Might be irrelevant here, but have you considered whether it is possible to split the 300GB database over multiple files\filegroups and then do piecemeal restores?

I have had issues with maintenance plans for backups on Sql Server 2005.

I have since fallen back to executing the backup via T-SQL as a step within the Maintenance plan...

Got a reply on Google groups that solved my issue.

The problem was that the only command controlled by the "if update(amount)" is the "set

nocount on"

I took the set nocount statements...

The trigger is of the form : ( Include a state_code column in byCounty)

CREATE trigger [dbo].[tr_cty_st]

 on [dbo].[byCty]

 after insert,update

as if update(amount)

set nocount on

 update bys

 set bys.amount=

    (select sum(byc.amount)

   from byCounty byc...

Consider a table like

create table example(

tx_id int,

product_id int,

fiscal_yr_id int,

amount decimal

)

According to business rules, the uniqueness constraint is defined as (tx_id,product_id,fiscal_yr_id) ; so naturally they are candidates for the composite...

Resolved it by installing SP1 for WinXP Pro- that gave me the Report Server optins for installation

~Rohit

Peter ,

W.r.t. your post above - does it mean that I will not be able to configure SQL Mail/Notifications to run from a Local Administrator account on my laptop ?...

Resolved it by installing MDAC 2.8.

Actually we had reinstalled Win Xp Pro on the laptop and thne it had crashed. Looks like the problem was there right after the...