How can i restrict the SA user

hi,
Is there any way to restrict the SA access. The problem is that all my
client machine users knows the sa password, and also right now i don't want
to change the password. So i just want to know is there any way to restrict
their access ? thanking in advance
ARHi
SA is not restrictable as it is the highest built in security account.
If security is so important, you have to change the password. Remember, if
you are using integrated security, domain and local admins are by default,
mapped to SA.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
>|||"Aneesh" <aneesh.r@.eostek.com> wrote in message
news:u4iPss30EHA.2608@.TK2MSFTNGP10.phx.gbl...
> hi,
> Is there any way to restrict the SA access. The problem is that all my
> client machine users knows the sa password, and also right now i don't
want
> to change the password. So i just want to know is there any way to
restrict
> their access ? thanking in advance
> AR
Make a new user and give him an appropriate permissions.
regards,
Dra

How can I have a log of all SQL Server transactions ?

Hi guys !
Any body knows that how can i have a log of all SQL Server transactions ?
Thank's
SQL Server is writing every transaction in its own transaction log. There
are couple of 3rd party log readers around. Also, you can use Profiler, a
tool that ships with SQL Server, to catch all T-SQL commands.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions ?
> Thank's
|||Hi
You do have a LOG . Lookup Transaction Log file in the BOL for more details
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions ?
> Thank's

How can I have a log of all SQL Server transactions ?

Hi guys !
Any body knows that how can i have a log of all SQL Server transactions '
Thank'sSQL Server is writing every transaction in its own transaction log. There
are couple of 3rd party log readers around. Also, you can use Profiler, a
tool that ships with SQL Server, to catch all T-SQL commands.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions '
> Thank's|||Hi
You do have a LOG . Lookup Transaction Log file in the BOL for more details
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions '
> Thank's

How can I have a log of all SQL Server transactions ?

Hi guys !
Any body knows that how can i have a log of all SQL Server transactions '
Thank'sSQL Server is writing every transaction in its own transaction log. There
are couple of 3rd party log readers around. Also, you can use Profiler, a
tool that ships with SQL Server, to catch all T-SQL commands.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions '
> Thank's|||Hi
You do have a LOG . Lookup Transaction Log file in the BOL for more details
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions '
> Thank's