porwal.naveen (11/9/2009)

---

Thanks for the response.

I have one more question here.

If I create trigger on update of some column, does it lock that row till the trigger finishes updation of the...

Company MSDN subscription or get your own TechNet subscription. Either one will allow you to do what you're doing.

If they won't go for that, then get them to get...

If you have the driver correctly installed, then the error is most likey to be from not having the correct filename and/or path in the openrowset command.

Triggers are not the right tool to use to prevent SQL injection. By the time the code has fired off a trigger, it's WAY too late to be preventing...

SQL 2005 has a default trace running that tracks that kind of change (and other DDL commands). You might find what you're looking for in there.

kkapferer (11/6/2009)

---

I think you both raise very interesting points. My situation is unique in that this person is an R&D engineer, not in IT at all. They prefer...

J-F Bergeron (11/6/2009)

---

I have to admit you're right, in a real big environment with a lot of important data, that could be really important. Where I work, I'm the only...

I think RedGate has a product for that. ApexSQL, too.

Whichever machine the job was scheduled on.

Absolutely. I take a very strong stand on questions of ethics and legality. Always.

If I were the manager, and I found out that a DBA had given himself...

It's a valid point that many businesses still have SQL 2000 servers, and will continue to have them for some time yet. Could be a niche market in the...

There are several third party tools for debugging T-SQL.

Management Studio for SQL 2008 includes some debugging tools built in.

I generally just use raiserror, select, print, etc., at various points throughout...

Denormalization is deliberately breaking normal forms, usually for report performance.

The usual process is to take normalized data from multiple tables and eliminate the joins between them by putting the data...

Right-click the job and select History.

That's your best bet.

If I'm not mistaken, PASS was Mon-Thu, right? So what's traditional for people to do on Friday? Fly home? Ad hoc activities? Or is there something...