Thanks every1 for valuable suggestions. I went with the idea of changing default database along with creation of a DDL trigger on master database.

Thanks every1 for valuable suggestions. I went with the idea of changing default database along with creation of a DDL trigger on master database.

Thanks every1 for valuable suggestions. I went with the idea of changing default database along with creation of a DDL trigger on master database.

SQL prompt is really good and u can get it as said above or search in google.

You can also try SQL Assistant. Its a third party tool and works well.

Isn't there any way to create DDL triggers in system databases.

The idea of changing the default database is good but there are lots of logins and it will...

oops.. got doubt again.

If this is the case why this tables are defined as system tables for sql server 2000.:hehe:

http://msdn.microsoft.com/en-us/library/aa260604(SQL.80).aspx

dbobackupfile ...

hey thanks. Yup I got it.

thanks for the information.

I think allow update work for SQL Server 2005 as well.

But still are you sure that they are not system tables as they get created automatically.