Tag Archives: Error

Oracle: Error ORA-00955 name is already used by an existing object

Sometimes things just won’t work as expected. You know, programming has its quirks and the like. Normally this error alone would mean you are creating some object with a name that is already in use. But what if you just … Continue reading

Posted in Oracle | Tagged , , , , , | Leave a comment

SQL: Management Studio not saving changes to table

Having a blog about something you like is a great way to learn more things about it. If you keep an eye open for the other bloggers the term “community” really makes sense. This week while checking the recent activity┬áI … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

SQL – Database in Emergency Mode

Who never experienced a critical failure of some server that resulted in database corruption? There are times that the unthinkable happens, be it with physical or virtual servers, and there will always be a weaker link somewhere in the service … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

SQL – Determine which user deleted a SQL Server database

This is not too common, but usefull to know anyway. While searching for some answers to this question, I came to realize that the SQL default trace should be enough to find this information. If you are trying to find … Continue reading

Posted in SQLServer | Tagged , , , | Leave a comment

SQL Job with Maintenance Plan misteriously failing

This post is to group details about one possible cause of failure on SQL Agent Jobs that have Maintenance Plans inside. Because the Job engine is not very clever when storing the messages returned from the SSIS Package (that is … Continue reading

Posted in SQLServer | Tagged , , , , | Leave a comment

Unable to open Job Activity Monitor in SQL 2008 SSMS Express

If you have some sql2008r2 servers on your network and want to manage them from your desktop, then you probably want to install only the SSMS client. If you did that then you probably used the Management Studio Express, available … Continue reading

Posted in SQLServer | Tagged , , , , , | 1 Comment