Thanks.  Its one of those 'it should work this way'.

No matter the parameters I use (tried I think all combinations), I basically get this

2005-07-19 08:32:49.15 spid5     udopen: Operating system...

I agree with Journeyman.  I would be looking for a requrements document.  What access is required and when.  Specailly with SOX these days.

Joseph

Thanks,

  I have a function working that produces a list of orphaned users.   I used VB then to check box the ones I needed resloved and the ones I needed...

Thanks for the info.  I have it cleaned up now.  I put together a script to take care of those issues when we do refreshes.

Joseph

What I am looking for is a way to clean up the system tables so the represent the GUI Security--> logins list of SQL Server logins.  If I can't make...

One of the tables is sysusers in the user databases.  I have not traced the id's to other tables for permissions, roles ect.

Thanks,

Joseph

Thanks for the tip, but we have been using TDP for a over a year now.  We have done hundreds of restores and restores for DR.  Different servers, different disk...

Thank you.  The article and related articles did help.  Not as easy and clean as I would like, but the process works.

Joseph

Full recovery mode means  you can do "full" backups and then add log backups and incremental backups.

Full backup will backup your database and enough of the log file to recover...

Yes, if you run it interactivally you get all the rows.

I am using MSX to push this script down to 16 instances running on 10 servers.  I have created the...

Yes, there can be many performance issues that will need to be looked at and resolved.  The top top three are Memory, CPU and Disk.  Each one has to be...

I am using sql 2000.  I have already checked the event log and sql logs, it does not tell me where it is coming from.  I did find out that...

A copy/paste of the master works.

But this does not work for the restore.  When Tivoli does a restore, it tries to connect to the database.  If the instance is not...

Yes, I need to test a restore of the master/model/msdb databases.

We use a product called Tivoli (by IBM) to do all our backups (oracle, sql, adabase, nt, ect.) to the...

Thanks.  That did the trick.

Joseph