Hello,
I have a person in my IT dept. that I suspect is using the SA account for
a
SQL server that holds employee information(salary, etc.) that she should
not
be accessing it. Is there a way that I can track where the Actual SA
account
is coming from by IP address or machine name? I know I could change the SA
password, but we are not at a stage right now to do this.
Please advise?
Re: How to populate a list box based on user input? ... associated with that account pop up in a list box. ... click "View" and a query come up showing all those orders on separate ... I get stuck on what the SQL should look like in the Control Source ...Private Sub txtAccountNo_AfterUpdate ... (microsoft.public.access.modulesdaovba)
Re: Warning: cannot write logfile ... And what version of SQL Server?... If the account is not a sysadmin, then the SQL Agent Proxy account will be ... I am scheduling a simple job to run a query.... (microsoft.public.sqlserver.mseq)
Re: Help with Cartesian or cross joins ... in your SQL on the basis that it grossly clutters the SQL and requires you to keep editing it whenever the set of numbers changes. ... More maintainable is putting those numbers into a Table (or computing them via a Query), so you can leave all your SQL alone once you have it working. ... And we have the Table of existing, and thus unavailable, account numbers at each Branch. ... This Query lists account numbers up to 998 for Branch "01" and up to 997 for Branch "02", omitting the other numbers and Branches. ... (microsoft.public.access.queries)
Re: BCP, Bulk Insert ... If the user is a sql admin then the account used to start sqlserver ... > OSQL Query:... (microsoft.public.sqlserver.programming)
Re: Discussing 3 different strategies for deleting from multiple tables ... I will be using SQL Server but I am riding on top of a third party OLE DB Provider. ... I will only use 3 tables for brevity - Account, Contact, Opportunity - and assume the following relationship. ... This results in one parameterized query followed by two more trips to the database to delete any orphaned records. ... (microsoft.public.data.ado)
