Hi,

Great suggestions ... and I totaly agree. I'm using legacy SQL scripts that included this in the create table definition.

What is also interesting is that I noticed if I let...

No. It's my "pet project", if you like. My goal is to test on our dev'm't servers and if satisfied, will lobby it with our engineers and role it out...

Hi Brian,

In a recent arcticle of SQL Server Magazine "Best Practices for Mixed Authentication" August 2003, the author suggests using an IDS (snort) to log dates, time and IP info...

Many thanks to all.

Jeff

Great. Thanks.

Is there in TSQL to display all the objects (tables, views) for a given schema/user ie: in Oracle, SELECT * FROM CAT/CATALOGUE will only display all the objects...