Sorry ... I haven't dealt with those scenarios.

I have 2 ways I know of to search SPs

1) Script all the SPs at once into 1 huge script, then use "find"

2) query syscomments table in the DB..   ...

Thanks, but the only units of time are:   Days, weeks, months & years.   Hours should be there though

Sorry ... my typo ....  I meant Enterprise EDITION, not EM ....  d'oh  !

Thanks for the other suggestions ....  I 'll be trying it later today.

We're using enterprise manager, actual build # is 9.00.1399.06

SSIS works if I log on to the server directly, but I get an access denied error if I try it from my...

Maybe I can script the process into a job, running under an account that has permission, and just let him start the job ?

We're on Veritas BE 9.0 and  have done restores here & there without any problems.  In our case, we're only putting the databases on tape. For those few DBs that...

" .. Also, I have gathered this much that if I want to create groups, I need Active directory. Can any one please elaborate on this. I am looking to...

Thanks.  I went into the surface area config tool, and I see that Database Engine and Analysis Services both expand and have a sub tabs to enable Services and Remote...

One area I consider lacking in SQL ........   One of the things I miss about our AS400 is the depth of information like "Last Used" data .....

I'm about to install 2005 on my desktop, and notice that it wants to install into the same folder that 2000 is in ( C:\Program Files\Microsoft SQL Server ).  Should...

And if you have a whole lot that need changing, run this in Query Analyzer, outputting to text (not grid), then paste the results into another window to run them...

Could you give some specifics of your situation, such as your DB & T-Log backup scripts,  recovery model and how "important" your DB is.

Are transaction logs "worth it"  ?  It...

The job needs to be enabled AND the schedule needs to be enabled.  Perhaps the job had an end date that has now passed.

And some data is so troublesome that it's just best to delete it all and start fresh.