chethan.cn (8/4/2009)

---

I have to create a trigger for all the insert ,update and delete

Can we have only one trigger for the entire database to monitor the insert ,update and delete...

Paul White (8/4/2009)

---

So...today's SSC newsletter - entitled {title} - features Gain Space Using XML Data

You can all relax in the knowledge that everything will be smaller and faster if we...

Glad we could help. 🙂

Glad I could help!

In that case, as someone who has already...

jqd2001 (8/2/2009)

---

Barry,

For big...

Hmm, I missed this point before,...

sql server developer (8/2/2009)

---

Hi,

Before setting up the service broker objects I have seen in many forums that they create Master key Encryption as below.

CREATE MASTER KEY...

Well, DB Mirroring, DB Mail and Event Notifications all use Service Broker, so if you're using any of them, then you've got Service Broker running.

I'll try to lookup how you...

bitbucket (8/2/2009)

---

For all the trials and tribulations there is occassionally a few that express appreciation for what help has been given, for example:

http://www.sqlservercentral.com/Forums/Topic763622-149-1.aspx.

Not to forget those who feed back knowledge...

You are so...

Oh Jeff, ... You might want to take this one ... 😀

Man! I've had about all I can take of this guy.

Grrrr... :angry:

Thats because you've got an END statement without corresponding BEGIN in there:

Try it like this:

DECLARE @ConvHdl uniqueidentifier

, @msg_body nvarchar(MAX)

...

Have you tried what I suggested yet?