I mean the source code

Hi I have done the export succesfully as I utilized Microsoft OLE DB provider for SQL Server(source with the Oracle Provider for OLE DB(destination). One more thing though. I noticed...

I am now using the Microsoft OLEDB Provider for Oracle as fromnaija ) suggested and it is working just fine. It is taking it's time though. Has been running...

Thanks Franco. You are right the options were either simple (SQL2000 )or "truncate log on checkpoint" is ticked on the SQL Server7. My next question is is it better to...

Thanks for replying. I am actually installing it as Administrator on the local machine. So yes I do have the correct priviledges.

Hi,

are you sure you have the appropriate rights to...

Thanks for your reply. It is very well appreciated. Can you kindly let me know the easiest and safest to way to detach and attach a database. I have never...

Thanks alot Andy and Greg. I did use EXEC sp_change_users_login ‘report’ to identify the orphaned users and

EXEC sp_change_users_login ‘Update_One’, ‘<db_user_name>’, ‘<sql_server_login_name>’ to put things right. I got the step...

Thanks alot Andy and Greg. I did use EXEC sp_change_users_login ‘report’ to identify the orphaned users and

EXEC sp_change_users_login ‘Update_One’, ‘<db_user_name>’, ‘<sql_server_login_name>’ to put things right. I got the step...

Thanks so much Andy warren and Antares686 for your contribution. It is well appreciated.

Hi Antares686 and others

Would the following maintainance plan cover your list?

DATABASES

Test

SERVERS

(local)

OPTIMIZATIONS

Occurs every 1 week(s) on Sunday, at 01:00:00.

Perform the following actions:

Reorganize data and index pages, changing the free space...

I like mpeterson's reply so much. I would like to know what exams you did for the SQL Server. I am also an Oracle DBA and SQL server DBA. I...

I agree mostly with lua. I also believe that most people that look down on certifications are not certified (for whatever reason). Certifications will no you or your CV no...