Error While Enabling Tracking For Master Database

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Error While Enabling Tracking For Master Database

Author

Topic

kbsudhir
Starting Member

3 Posts

Posted - 2009-04-05 : 10:38:20

Hi
I am using SQL 2008.

I want to change Tracking property of Master Database to True.

But once I click "Ok" I get the following Error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Alter failed for Database 'master'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Database 'master' is a system database. Change tracking settings cannot be modified for system databases.
ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 5090)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=5090&LinkId=20476

------------------------------

In fact I am getting the same error while enabling all the default databases i.e master, model, msdb & tempdb.

But when configured ASP.Net it created a database "aspnetdb". And for this database I was able enable the tracking without any error.

Am using Vista Home Basic.

Please guide me on how to enable tracking.

Regards
Sudhir

Sudhir K.B

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources