change track in sql server 2008
HI,
use Northwind
Alter database [db_track]
set change_tracking=on
(change_retention=3 days,Auto_cleanup=on)
i m running the above command i m geting the ERROR AS
Msg 5011, Level 14, State 5, Line 3
User does not have permission to alter database 'db_track', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 3
ALTER DATABASE statement failed.
how do i check that which user is logged in.
Regards,
RINO
Software/Hardware used:
sql server 2008
Software/Hardware used:
sql server 2008
ASKED:
May 21, 2010 7:16 AM
UPDATED:
May 25, 2010 4:16 AM
Answer Wiki:
If you look at the bar at the bottom of SQL Management Studio it'll tell you the user account which you are connected with.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
