What Info Should A SQL Server Audit Contain?
May 13, 2006
That is to say, from a management perspective? I've been asked to provide one, as I'm the first DBA there ever, but I'm not sure what depth of info they want. And, does anyoe have scripts that can perform the audit, or an actual example audit?
I'd imagine an audit should encompass the following:
Database names;
Database sizes;
Location and size of data/temp/log etc. files;
Hardware specs (cpu/memory/disk sizes);
Number of logins;
User applications.
I'm sure that's only the tip of the iceberg, I'd be grateful for your input!
Thanks in advance,
Jaybee.
View 4 Replies
ADVERTISEMENT
Apr 10, 2008
Hi all
I have a stored procedures with few DML stmts inside.
I need to log the success/failure of each DML statment into seperate audit table as follows
Begin
DML Stmt1
Log sucess/failure (Insert stmt to audit table)
DML Stm2
Log sucess/failure (Insert stmt to audit table)
end
when any of the above DML stmt fails, the entire transaction is getting rolled back including the audit information.
How can i keep the audit info intact when the transaction is rolled back.
Thanks.
View 1 Replies
View Related
Nov 1, 2014
I have made a server security audit and specify from database audit specification to audit "select" on a certain user and on a certain table. I logged in by this user and made the select statement..when i run this query
"select * from sys.fn_get_audit_file('d:Auditaudit1*',null,null)"
It return a value at which time the query has done
after 15 minutes i repeated the same action, i run the audit query and the same result is showed off on the panel.is it suppose to return a list of values by how many times this user has made the select statement on that table ? for example at 5:00 pm then 6:00 pm and so on
View 1 Replies
View Related
Jan 18, 2006
I need help...here is the problem.Last weekend, the servers in our datacenter where moved around. After thismove, and maybe coincidental, 1 server is performing very poor. Afterrunning a trace with SQL Profiler, I saw the problem which was laterconfirmed with another tool for SQL server performance monitoring. It seemsthat all connections to the SQL server (between 200 - 400) are doing a login/ logout for each command that they process. For example, the user'sconnection will login, perform a SELECT, and then logout. This is not a..NET application. The client software was not changed, it is still thesame. The vendor has said that it is not supposed to do that, it issupposed to use 1 connection that log's on in the morning and logs off atthe end of the day or whenever the user exits. 1 user may have severalconnections to the database.At times, the server is processing over 250 login / logouts (avgeraged for30 second period). Has anyone seen this problem? I have the server inAUDIT FAILUREs only. The server has become very unresponsive, things thattook 3 seconds now take over 15 seconds.Any ideas???
View 6 Replies
View Related
May 7, 2007
I want to be able to see when records have been added to a table. The issue is we have a DTS job scheduled to run every night. The developer who wrote it password protected it and doesn't work here anymore. I want to add a step to this series of DTS jobs and want to run it just prior to his job. Is there a way to see when the records are being added or when this job is being run? Thanks again, you guys are the best.
ddave
View 3 Replies
View Related
Aug 12, 2014
I restarted the sql server after c2 audit was enabled and now i can not start the instance getting this error below. how do i bring the sql server up?
Cannot start C2 audit trace. SQL Server is shutting down. Error = 0x80070003(The system cannot find the path specified.)
View 2 Replies
View Related
Mar 6, 2015
I have been tasked with auditing all DDL and selected DML events on a production server and logging them to a table. My solution is to use CDC for the DML and a Server-Level trigger for the DDL. Because there should never but much DDL activity on the server (except when performing update tasks) I don't need to worry about the trigger consuming too many resources.
My question is this: Is there any single specification such as DDL_LEVEL_EVENTS that can capture all DDL activity or do I need to specify each and every DDL action in the trigger?
View 1 Replies
View Related
May 15, 2007
Does anyone know if there is any type of audit trail mechanism used in SQl Server 2000 or 20005?
In our production environment, some of our stored procedures, views and data in our tables has changed. It would be nice to have a footprint of what was changed by whom and one.
For our code we use source safe but for SQL Server I am not aware of any type of auditing mechanism.
View 1 Replies
View Related
Apr 21, 2008
Hi ,
I wanna setup audit in SQL SERVER 2000,can i know..How to setup audit?
How to filter from audit files for particular object?/
Thanks,
View 4 Replies
View Related
May 8, 2008
Hi ,
Recently i enabled audit by selecting properties of the server and enabling audit-all.
Now i disabled audit by select audit level=NONE.Still i get trace files.
Can anyone help me,how to stop this?
I also rebooted the server??
View 2 Replies
View Related
May 15, 2008
Hi,
I disabled audit by right-clicking the server->security->and disabled audit->none..But also we seeing audit files.
Can anyone help me??
View 8 Replies
View Related
Jan 27, 2006
Is there a way to audit the login on SQL Server 2000? I'm looking for away to get a report login/logout events with the name of the database.Thanks in advance.
View 3 Replies
View Related
Mar 21, 2014
Somehow someone turned on a audit on the sql server and it is filling up our hard drive and shutting down sql server eventually. Been trying to google how to shut this audit off but coming up with no via soolution yet. how can I turn this trace off. Each fiel says AuditTrace and date and they happen every other minute. I went into the sql profiler and can pull up the files but how to shut the trace off, it does not say.
View 9 Replies
View Related
Jun 20, 2015
I should audit all access by dba (italian privacy law) in my sql server , what is the best way?
Using the build in audit i can't achieve this goal, do i miss something?
My sqlserver use windows auth.
View 9 Replies
View Related
May 7, 1999
Respected Sir,
I am from India. My office has 15 location all over India. I am in corporate office.We have Ms Sql server 6.5. Also all other centers have
have same Ms Sql Server 6.5. We develop a Intranet based application.
In which Ms Sql Server 6.5 is the back end and Netscape browser is the front end.
The centers have their independent database. all also have different data structurre.
But the Head Office needs data from them. How the replication technology help us. and How we we will conect through internet or we haveto have seprate dedicated
leased lines back to centers.
What will be data structure .
Himansu
View 1 Replies
View Related
Mar 3, 2005
Hi All,
What is similar to "Schema" and "Table space" in SQL Server?
What is the physical organization/structure of SQL Server?
Thanks in advance,
Jai
View 7 Replies
View Related
Mar 1, 2006
I have developed a great intrest in the MS SQL Server recently. I was just wondering if it was worth putting my time into learning this system. In the members opinion would SQL server be technically fit? Does it have a good campacity and flexibility? These areas are quite important to me. I would also like to know how web friendly the server is and its ability to handle complex data.
Any help would be much appriciated.
View 2 Replies
View Related
Sep 25, 2006
Is there any way to maintain audit trail of access to my SQL server 2000 database by any user ?? I need to log the timestamp of any insert/update/delete to any record in a table within the database by the user.
Alex
View 3 Replies
View Related
Sep 29, 2004
I am building an intranet application for my company .. similar to code generator
I am developing ASP.NET Application for this
1) How do I display list of SQL Server on the Network
2) Once I have list of SQL Server, I asked user to select once of the Server, provide credential for that server and obtain list of Database for that Server
3) Once I have list of Database, I need list of table under particular database
How do I do this in ASP.NET Application ?
View 2 Replies
View Related
Apr 17, 2002
Hello,
There is Production server with different Unicode Id and its standard edition, I need to build the server with same configuration of production server, Can anyone help me as to how to get all the info of the server
Thanks
Ekta
View 1 Replies
View Related
Feb 25, 2004
Hi
The system tables syslocks,syslockinfo give information on locked resources, spid, object_id,lock mode, lock status etc.
How will i get object_name
for example if a table is being locked above sys tables give object id, how can i get the actual table name ( object_name)
Please let me know
Best Regards
THNQdigital
View 4 Replies
View Related
Jul 20, 2005
Where can I find any materials about models of distriubution of data in sqlserver ?Any help will be appreciableGawel
View 2 Replies
View Related
Nov 10, 2000
I'm wanting to start to understand SQL Server. I've got the Beta Version of MS SQL Server 2000 and was wondering whether I could install this on my Windows Me box and start developing? Is this wise, or should i not use the Beta version? Is there a time when the Beta version "runs out"?
Are there any good basic SQL web sites out there? I know all about Access developement and i know some SQL, but i know nothing about SQL server. Which is the best site for me?
Thanks.
View 1 Replies
View Related
Jul 20, 2005
I was looking thru the mas90 info site ofhttp://www.accountingsoftwareconsul...ng_software.htmfor detailed info on MAS 200 SQL server.There's some info on that page, but I need more.Is there any more detailed info anywhere else on that site, or anywhere else?
View 1 Replies
View Related
Oct 18, 2007
Can someone help me with the following... My SQL server disk says standard edition on it, my invoice for the license says standard edition (granted it's expired according the license site) but when I go to the machine and right click on the local DB properties it says it's personal edition...
I am confused how this can be.. Any thoughts ?
The only way I figured this out was because we kept getting the you have exceeded your limit of 8 concurent queries...
Thanks
View 3 Replies
View Related
Jul 31, 2006
Hi ,
I must to realize a database application for an Automation system consisting of a Industrial PC with Operative System microsoft windows embedded.
1° question: Is Microsoft sql server 2005 everywere compatible for Microsoft windows embedded?
(I ask this because in specific of its is not clear)
2° question: In the case that it's compatible, if I instal it in a industrial Pc can it to act by database server or necessity of a remote server?
Tanks
View 1 Replies
View Related
Jul 20, 2005
Hi All:I am getting an error when trying to open a recordset in SQL Server 2000.The error states that the transaction log is full. Is there any way I canclear out or empty the transaction log, or get rid of it alltogether as itis not really needed?Any help would be appreciated.Thanks and regards,RyanThe error msg is: tempdb transaction log is full. B/U transaction log tofree up space..."
View 2 Replies
View Related
Jul 20, 2005
Hi,I'm in need of detailed information on how data replication works on thesql server 2000. If someone knows about a book or articles thatdescribes how data replication works with transactions, storedprocedures and/or merging databases I would like to be pointed in theright direction./Zero_Addiction.
View 1 Replies
View Related
Apr 16, 2008
Hi all,
I need some help to known more about basics of SQL Server 2005 failover cluster . pls provide me link to
known the concept.
Thanks,
Nav
View 6 Replies
View Related
Sep 30, 2004
Hello all,
I am trying to change values of two tables in my sql server 2000 database. When one of the tables is modified in some way like adding/updating a record, I need a trigger procedure to copy this new data from the first table to the second. Problem is, how do I get the newly inserted or updated data from the first table? How do I specify that I only want the data which caused the trigger to execute? Anyone know?
Thanks,
Bob
View 1 Replies
View Related
Aug 30, 2006
Where can I find info about how to backup Sql Server 2005 using a .bat file?
Is it possible doing it this way?
If so, can anyone direct me to some links how how to do this?
If not possible using a bat file... then how can I make schedueled backups? What tool to use and hopefully free.
View 2 Replies
View Related
Mar 19, 2008
I use MSSQL Server to store the configure info and create deploymentutility to deploy the package on remote server,
If the configure info could be created automatically while deploying?
or I have to create the Table on remote server to record the configure info in manully?
Thanks a lot
View 1 Replies
View Related
Jul 23, 2005
Dear AllI have problem with my database server which running SQL server 2000.The server running very slow. The worst case, to save a record requiredmore than 20-30 seconds.Since this problem, I usually monitoring Process Info from EnterpriseManager (Management - Current Activity), and I found a misteriousprocess as follow :1. User: SystemAccessTo: MasterStatus: BackgroundCommon: Task ManagerWaiting: >438 Million2. User: SystemAccessTo: MasterStatus: BackgroundCommon: Task ManagerPhysical IO: > 510003. User: Administrator (Join domain)Database: MSDBStatus: SleepingCommon: Awaiting CommandApp: SQL Agent Alert EngineCPU Usage: > 16 MillionAnybody know about these condition? Does it normal?ThanksMichael
View 3 Replies
View Related