Thank you all, now I got it.. 🙂

Gianluca Sartori (7/6/2010)

---

BEGIN / END delimits a block of code, without controlling a transaction. If not already inside a transaction, each statement will execute in an autonomous transaction. Typically BEGIN/END...

In...

COldCoffee (1/29/2010)

---

I guess u did not look up at the "Messages" tab in the Results Pane..

For those intending to...

jshailendra (1/27/2010)

---

Know everything about replication links below:

http://msdn.microsoft.com/en-us/library/ms151314.aspx

Look at Replication Wizard...

You can very well setup/delete replication using scripts. Easiest way to get this script is setup replication using wizard...

Output answer should be

1

2

4

5

why this option was not there??

Thanks all for your answers,

I am able to log these message into eventlog, but my requirement is that I need my custom eventid and may be custom datasource,

Is this...

Thanks Marks,

I am facing the problem as this 5001 is written into message not in the eventid,

is this 5001 will be written as event id in your case?

Today I am...

The code you are using is confusing us. Please calrify the code like A001B1 -> what the second 1 means here?? id 001

Thanks An

Cant do anything on...

Thanks a lot!!!

GilaMonster (6/30/2008)

---

You can use the sys.dm_exec_sessions and sys.dm_exec_requests to see what's currently running on the server.

You can use the server-side trace procedures (sp_trace_*) to inplement a trace. They're the same...

kas (3/4/2008)

---

Points taken, absolutely Shaun.

However, NULLs cannot be excluded from the results of queries. Suppose for instance, looking again at my example, we have some kind of accounting database,...

Thanks for the update,

Yes it is good practice to avoid painfull bug and screaming your head later on.