Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rams_spl2002
Starting Member
9 Posts |
 Posted - 2007-09-12 : 07:13:28
|
| how do i know when sp is modifiedrams |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-12 : 07:26:40
|
| select * from information_schema.routinestake a look at the last modified columnPS: If anyone is interested in a high paying SQL position in CT send me your resume to ValterBorges@msn.com. |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-09-12 : 07:29:16
|
| what are the expectations from the company? i mean the type of job.....VinodEven you learn 1%, Learn it with 100% confidence. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-12 : 07:45:32
|
| I sent you an email. |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-12 : 08:24:00
|
| If you have more than one person that has sysadmin rights you should not use this for auditing or change control enforcement. It's possible that someone could change the timestamp in the system database to cover some tracks.Use an external tool that monitors the sql logs and stores the data in a separate audit repository.PS: If anyone is interested in a SQL position in CT with excellent pay please send me a resume to ValterBorges@msn.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-12 : 22:20:46
|
| If you are in sql2k, you don't have that info. |
|
|
|
|
|
|
sp