SQL Agent Roles will not work. Only an owner or a sys-admin can change someone else's job.

Restarting SQL Server Agent did not resolve the issue. In reallity the restart should not even occur because the setting does not depend on the restart

The easier way is to run the update statement against syscolumns table.

select 'update syscolumns set name = upper(name) where object_name(id) like ' + '''' + name...

The problem you are experiencing is that with MDAC 2.6 Microsoft has changed the entire structure of MDAC and how it operates. Also, they have installed stand-alone version of Client...

The best approach for this would be to use DTS. You can even use DTS import wizard. This will do several things for you. First of all, you will be...

Brian thank for your response. The migration is side-by-side. We have performed the test and it did not work. The user was able to login to the server based on...

Andy,

Thanks a lot for the reply. The solution we are looking is to resolve issues with ownership in user databases (sysusers) and updating sysprotects. I found an sp sp_sidmap, but...