Clint (3/9/2009)

---

Hello. First time poster here. I'm a developer turned DBA, and I've never set up replication.

--A description of our setup:

We have a production SQL Server 2005 instance...

No, You can automate it. If you just search for setting up trace in this site itself, I am sure you will get some articles about it.

Hey Hey Hey... Lets not get pessimistic... 🙂

Atleast there is a place where you can take out your frustration.. 😀 This place.

If you want to see who is executing what Stored Proc or SQL statements, you can just grab the info that you get on the profiler and dump it into...

How about just categorizing it as Plain Old Laziness?? 😀

Man o Man... Lynn, That must have been tough not to throw your key board out of the window...:hehe:

You can actually use Default trace from SQL 2005 to capture the info you are looking for. Alternately, You can write Alter triggers. I got this info from GSquared. 🙂

With...

Kerry,

Are you going to use only Stored Procs from your App? If so then you can give permission to execute to each seperate sp.

Grant execute on STOREDPROCNAME to USERYOUCREATED

Flash Gordon...Brings back old memories. I have never seen the series but I used to read the comics back then. Flash with the Doc. Mandrake with Luthor nd Phantom with...

Nor would I get invited. 😛

I am no were near the standard to be invited...

Maybe you cn have a thread and once the discussion is over, open it for...

Amit Lohia (3/6/2009)

---

Good Article but you need a followup article to cover the issue raised in discussion. As how this is different from nolock and other isolation level. A real...

Huonglien Nguyen (3/6/2009)

---

I followed through the steps but eventhough after I executed "Commit tran a" the select * on dbo.test still showed me the old data: 1212121 and if I...

You are welcome and I am glad you sorted it out.

It has become a war now....

No and yes. let us say it depends on the index. If it is a normal index, No it will not have any effect. But if it is a Clustered...