using the sa password. Keeping in mind these are old applications that may
have the uid and pwd hardcoded in them. They are old apps with no
documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.exec sp_who2
Shows a wealth of good information.
Rick Sawtell
MCT, MCSD, MCDBA
Shou
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message
news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
> How can I find out what appications ( if any ) are connecting to the
database
> using the sa password. Keeping in mind these are old applications that
may
> have the uid and pwd hardcoded in them. They are old apps with no
> documentation and we, the DBA's are seperate from developers.
> Any ideas would be welcome.|||This is a multi-part message in MIME format.
--=_NextPart_000_008B_01C4ABE7.E14691B0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN" <MANCPOLYMAN@.discussions.microsoft.com> wrote in message =news:8074B1F2-C889-4A83-852B-F4BAC5C5CD85@.microsoft.com...
How can I find out what appications ( if any ) are connecting to the =database using the sa password. Keeping in mind these are old applications =that may have the uid and pwd hardcoded in them. They are old apps with no documentation and we, the DBA's are seperate from developers.
Any ideas would be welcome.
--=_NextPart_000_008B_01C4ABE7.E14691B0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
You can also use profiler to filter this.
Tunji O
"MANCPOLYMAN"
--=_NextPart_000_008B_01C4ABE7.E14691B0--
No comments:
Post a Comment