Search results for query: *

Hmmm....it seems your replication is internally mess-up. Do you have the luxury to rebuild everything? If I were you I would uninstall everything, including distributor and start everything all over. How long you have been sucked in the condition like this? Consulting with MS support would...

I believe someone accidentally click "Initialization" or the SQL Agent service was restarted. It happened to me before as well, Distribution agent only work when you ask it for, it wont automatically choose to reinitialize subscription. Fix, control security and make sure only few people have...

Remove "BUILTIN\Administrators" from Security. -Claire

:confused: I granted myself read and write access for DATA_PUMP_DIR and also logged into super user. I then executed below statement to extract data from oraclr into a dump file $ORACLE_HOME/bin/expdp claire/claire@orafin1 schemas=finance directory=DATA_PUMP_DIR dumpfile=claire_finance.dmp...

here is my recommandation. You can make linked server to user some designated login that only you know. Then go to server where linked server connects to, turn the security audit login to log both failure and success login attempt. Later on check out event viewer for login history for the...

Right click on the server Group then select import, navigate down to the export file then click ok. Make sure you have all password and users name exported from the original server group.

Check out how many unused space available on the database, then issue DBCC SHRINKFILE or DBCC SHRINKDATABASE to see how much space you can reclaim. Then try to rebuild index to remove fragmentation. Also check out the size of table/index to see which object is really occuplying space on the...

The SQL Agent service was never restarted during the period. Moreover, rest of the scheduled SQL jobs are running normally except this one.

Hi, We have a database maintenance plan runs on SQL 2000 SP4 environment. One of the step: "Optimizations Job for DB Maintenance Plan 'DB Maintenance for MyDB'" had hung for 1 hours while normally it took less than 1 minute to complete. I could not be able to find any error message (not...