try the localadmin username and password .. this is the only option.

-----Original Message-----
From: Shrikant S. Patil
[mailto:mssqldba-ezmlmshield-x3634191.[Email address protected]
Sent: Monday, May 31, 2004 1:37 PM
To: LazyDBA.com Discussion
Subject: RE: unable to shrink log file


In order to shrink the data files, you must be member of SYSADMIN server
role , or DBOWNER database role.

Regds,
Shrikant Patil
MCDBA

-----Original Message-----
From: murali prasad k [mailto:mssqldba-ezmlmshield-x6820811.[Email address
protected]
Sent: Monday, May 31, 2004 7:56 AM
To: LazyDBA.com Discussion
Subject: unable to shrink log file


hi,
my problem is regarding shrinking of log file on the main server(MS SQL
200) to which 50000 records will be added every day. previously we had a
user say xx which has all the properties of sysadmin.. with this user i was
able to shrink log file using dbcc shrink log file command,, but now the
properties has been changed for that user by somebody,, now if i try to
shrink log file its giving error msg like to shrink a log file the user need
to member of sysadmin.. from sql enterprise manager also i am unable to do
it...when i right click on database shrinkdatabase option in invisible.
so can anyone guide me to solve this problem thanks, regards murali.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]

MS Sql Server LazyDBA home page