Is this what you are after ?

select LOCGRPNAME AS 'location', COUNT(empid) AS 'num_employees',

SUM(

CASE WHEN [dbo].[ufn_GetAge] ( [DOB], GETDATE() ) >= 60 THEN 1 ELSE 0 END

) AS AGE

from LOCATION...

Just watch out for orphaned transactions when rolling back from a trigger!! It KILLS the entire "batch".

You should implament an SQL Trace to determine which are your most frequent deadlocks and SOLVE them.

litu deb (8/11/2008)

---

Thanks for the query.

But sp_helparticle @publication = 'publication' , @article = '%'

this query show about all the article,From here how can I identify which article...

Ah ... that's different.

Yes, you could use mirroring as high availability; an independent distributor server and a separated subscriber for reporting that will stay working even with mirroring failover.

systems databases are NOT compatible between editions. backup/restore from/to editions does not work.

you should consider binary_checksum()

there are also sp_OA* procedures...

dogers (7/24/2008)

---

Well, SQL1 & 2 need to be kept up to date, back and forth, but yes, SQL3 looks best to receive it's (one way) data via transactional.

However I've had...

yup republishing has that problem. You should try to avoid it if at all possible.

b_boy (7/24/2008)

---

Its a live database been used by an e-commerce application, in other words there is only one user logged in at a time.

The recovery model is set to...

Not only you won't cause any harm by querying master you can't change system tables directly.

keymoo (7/22/2008)

---

Hi Michael, thanks for your response.

I set up the transactional publication using stored procedures like this (I declared some variables higher in the script - this is a snippet):

--...

After Switching recovery model you *must* take Tlog Backup if you want to recover to any point in time. While the DB was in Bulk_logged you lost point in time...

Bulent Gucuk (7/18/2008)

---

thanks for the reply, no matter how the jobs started disappearing the process must be using sp_delete_job proc. I will run a trace for watching the proc...