Was this *urgent* ? :hehe:

selvin_allsmiles (8/14/2008)

---

thanx..grasshoper , but that didnt help, what i actually need is an alert , whenever the deadlock exceeds 5 min, call it a deadlock or server hang up, but..in...

"Merge" and "peer-to-peer" are your two options.

Matt Slocum (8/15/2008)

---

Thanks Noel.

That's exactly what I thought. The odd thing though is that the BCP files...

Totally agree with Gail. Don't shrink, you just need to back the log up "regularly" ( meaning as often as needed )

-Cheers!

This is DB2 syntax. Not MS SQL Server and a Gail pointed above there is no "exact" equivalent in TSQL.

In addition sending email from a trigger is a very bad...

in addition to following the recomendations from Grant ( which nail the problem right at its core) I would suggest you to check if "cross apply" or outer apply...

Nick123 (8/15/2008)

---

Why we get different out here.

select 2,null union all

select null,'XYZ'

insert @t2

select 1,'MNO' union all

select null,'JKL' union all

select 3,'XYZ1'

--Querr1

select *

from @t1 a

left join @t2 b

on isnull(a.ids,'')=isnull(b.ids,'')

and...

Yes! that should solve your problem.

When databases are replicated...

It is the "distributor" who does not have access to the File.

Like posted earlier you should consider building the query dynamically...

First a word of caution:

Transactional replication with horizontal partitions can cause severe performance problems. Test, test and then test more befor you go into production.

So to get around the limitation...

The Best way is to use a calendar table

then simply:

select month, max(day_of_month)

from calendar_table

where date_col >= 'date a' and date_col <='date b'

Cheers

It takes PAGE-level blocking locks.