SQL Server Logs

Nov 9, 2006

Is there any way we can log in the info like this in SQL Server

Who logged in
What date
OS Name
Ipaddress
SQL Login Name

View 2 Replies


ADVERTISEMENT

SQL Server Logs (error Logs)

Aug 28, 2001

When looking at SQL Server error logs, I noticed that the current error
log had grown to 1MB whereas most of the files are only a few KB.

QUESTION 1: Can I set the max size for an error log file? If so, how?

QUESTION 2: If not, is there a workaround?

Thanks

View 1 Replies View Related

DB Engine :: Write Logs To Windows Event Logs?

Aug 6, 2015

OS: Windows 2012 Enterprise

SQL Server: 2012 Enterprise

I was wondering if there is any way all SQL Server error log entries could be automatically written to Windows Event Log. 

View 3 Replies View Related

SSIS Logs Vs Custom Logs Components

Feb 12, 2007

Hi,

In my case I have to log the errors raised by any task in a package to either windows event log, text file or SQL server. Also I need to send an email notifications to a group of people telling them about the error.

Now can I use SSIS package logging for logging the errors into the required destinations. I mean right clicking on the package and selecting Logging, then adding the required log providers and enabling the events for logging into those. I think I have to upfront select the log providers to log the error, I will not have the liberty to log the error to the destination, the name of which is passed as a variable to the package. This is okay with me though.

Now what will a custom log provider help me to do in this case. Also can I somehow configure my package to call the send mail task everytime an error is raised.

Also, one more option can be developing a package that only does the error handling. It will take in the paramters or the error codes and descriptions, the destination to write to and a flag to send mail or not for that particular type of error.

What do you think? Kindly advise.

Thanks in advance for your help and time.

Regards,

$wapnil

View 3 Replies View Related

SQL Server Logs

Jan 3, 2001

In Enterprise Manager, Management and then SQL Server Logs, when I clicked on Current or Archive#1 or 2 etc, nothing happens. This has been going on for the past 3 weeks does any one knows what is causing such problems?

View 1 Replies View Related

SQL Server Logs

Jun 12, 2007

Hi

I'm very novice when it comes to SQL Server Administration.

I have been asked if the SQL Server Log can trace information on whether data supplied to an individual has been tampered with, or if it is the full data set provided.

Apologies for this vague description, but that is what I have to go on also.

I am trying to find an article which details what the purpose of SQL Server logs are and if I can extract this sort of information from them.

Any idea if the SQL server log can provide tracing/editing/exporting information?

Thanks!!

View 6 Replies View Related

Sql Server Logs Help

Mar 4, 2008

We are using sql server 2000. I checked the sql server logs and noticed that everytime a user logs into sql an error log gets created stating, "starting up database 'CORT'". This db has nothing to do with users logging in as far as I can tell. What can check to find out what's causing this error log?

View 3 Replies View Related

Exporting IIS Server Logs For Use By DTS

Nov 8, 2001

I have a question that I hope someone can help with. I am attempting to load my IIS logs into SQL Server using DTS. I have done this sucessfully by manually specifying the source file. I would like to automate this process but, I have been unable to figure out how to do this. The IIS logs changes daily and the file name changes. How do I configure DTS to grab the log for the previous day?

I believe that the solution is to first copy the log to an alternate location then let DTS do it's thing. How do I programatically accomplish this ?

Thanks
kevin

View 2 Replies View Related

Querying SQL Server Logs

Feb 17, 2005

I've been digging for a while to try to find something, even had a consultant looking for me, but came up empty haned.

What I want to do is this:

I activated the Security Audit level for all logins. I want to be able to report last login date for every user from the log, and all login events for SA or any other defined super users.

Is it possible to Query the SQL Server Logs to report this information?

This is for proposed Sarbox Database Security settings.

View 1 Replies View Related

Sql Server Logs, No Views?

Feb 27, 2006

not sure if this is by default or restricted,
but I can't view the sql server logs using ctp

an error is generated saying the tsql could not be retrieved or something, very long message to post here

is this normal?

TIA

--------------------
keeping it simple...

View 5 Replies View Related

SQ: Server Logs Are Blank

Jan 10, 2007

I just installed the SSMS for 2005 Express and cannot view any SQL Server Logs. I see Current and Archive #1,#2 etc but the right pane is blank.

View 7 Replies View Related

Sql Server Transaction Logs

Jul 20, 2005

I recently performed an SQL server 2000 installation. Other thanplacing the program files on C: and data on D:, I saw no option toinstall transaction logs in an alternate location.What is the best practice with SQL server 2000 for location oftransaction logs? I remember that Microsoft used to take the positionthat transaction logs should be placed on their own FAT partition.

View 3 Replies View Related

Cannot View Server Logs

Jun 12, 2007

I have SQL Server 2005 Express on a Windows XP SP2 machine. Everything works fine and I have several dbs running. How ever I was wanting to optimize some programs and needed to watch the server and see what it is processing. I log into SQL Management Studio Express and when I go to Management->Server Logs I see the logs and the Activity Monitor. If I right click on the log all I see is Refresh. If I doule click nothing happens. I can view the Activity Monitor and the processes going.



I am sure it is a permission thing or something along those lines. I can not for the life of me figure it and have spent a couple days on google and these forums. I have tried with the SA, my defined users, and the local windows administrator. Is log viewing not allowed in SQL Server Express?



Thanks!

Michael

View 6 Replies View Related

Query For The Sql Server Logs?

Apr 28, 2008

Hi,

I understand that there is a SQL Server Logs section in Enterprise Manager 2000 where we can view SQL Server activity. Is it possible that we can get those logs by using query? I had been searching over the Internet, system databases, system SP and still have no idea how to achieve it.

Thanks in advance.

Regards,
maxChin

View 6 Replies View Related

Clear SQl Server Logs By Run Xp_cmdshell

Nov 3, 2004

how i can clear sql server logs by run xp_cmdshell stored procedure.
(my user in sql server is a admin).
i don't want use enterprise manager . i want write a query and use at xp_cmdshell .
befor thx.

View 1 Replies View Related

Help: Logs Not Found When SQL Server Agent Down

May 30, 2001

Hi,
Can any one suggest me how to find a error log when SQL Server Agent is down. I did not find it in NT error log when my SQL Server Agent was shut down. Is it known problem and pls also suggest me for the remedy to this problem.
thanks in advance.
regards,
Narayanan.

View 1 Replies View Related

Not Seeing Any Sql Server Logs In Enterprise Manager

Aug 2, 2001

Unable to view the server logs via EM. sp_cycle_errorlog tried, no help. The physical errorlog file is in c:mssql7log. A server reboot doesn't help either.

View 1 Replies View Related

[SQL Server 2000]Read The Logs .ldf

Aug 1, 2006

Hi,
I have an issue with an application, and i want to know what sql queries are done by this application. So i need to read the .ldf file, i have do some search on google, but i find nothing thant can be relevant.

View 3 Replies View Related

Loading Transaction Logs From One Server To Another

May 14, 1999

I am trying to setup 2 SQL servers (ver 6.5) - A live server and a standby server. The plan is to have regular transaction logs dumps from the Live server databases to the standby server and then have these logs automatically applied.

I have managed to get the logs dumping automatically but when I tried to apply them I keep getting synchronisation/sequence errors.

Has anyone done/tried anything similar. Any advice on this would be very useful.

Thanks
Samir

P.S I can't do this via replications as most tables in the database do not have primary keys.

View 5 Replies View Related

Checking NT Logs From SQL Server Client

May 1, 2001

Dear All,
We have recently moved our NT boxes with SQL Server to
a new computer room 10 minutes walk away.
Is it possible to examine the NT error logs from a SQL
Server client using perhaps an xp command?

Many Thanks in Advance,
Andrew

View 1 Replies View Related

How To Archive Current Sql Server Logs

Nov 28, 2005

Hi Guru's,

It takes me a long time to view in EM under Mangement/SQL Server Logs/current file. Is there a way I can shorten that file so it won't take so long to view the current file?

Thanks in advance. :eek:

View 2 Replies View Related

How To Truncate Transaction Logs In Sql Server 7.0

Mar 6, 2007

friend can i ask something like this

what query that can i truncate the transaction logs or shrink it into
2mb.

Please response to this. I need help


Thanks

View 7 Replies View Related

SQL Server Logs Under Management Menu

Mar 9, 2006

Hey Geeks,



I have found in the SQL Server Logs under Management Menu that says something like this :

Login failed for user 'sa'. [CLIENT: 59.144.69.233], Time : 3/9/2006 3:41:53 PM

And for every second there is addition in the messages.

Why is it happening? Can anyone tell me?

Thanks in Advance.

Snehal

View 1 Replies View Related

Read Logs In Sql Server 20005

Jan 14, 2008



I was wondering how can I read log file in a sql sever 2k5 database??
I mean, I want to check out every query since the selects until those that change server configuration, How can I do it without needing install a third-party software??
Keep in mynd that I need to know: the query (e.g.elect * from table_name) , source , date , application.

Best Regards

Joseph

View 4 Replies View Related

Access To SQL Server System Logs

Jul 6, 2006

I'm a developer and mostly develop Service Broker applications for my company. I do have logging for my application but unforseen errors will normally show up in the SQL Server System Logs. What would be a good way to give a developer access to read the SQL Server logs without giving away the keys to kingdom. Would that be through xp_readerrorlog or is there a better way of accomplishing this?

View 1 Replies View Related

Any SP , XP Or UPS To Read Contents Of All OS And SQl Server Logs (plz Urgent)

Jun 11, 2002

Hello,
I am working on some maintenance work. I need a Stored procedure to read all contents of OS and SQL server log. It has to accept filename as IN parameter.
Please help me to solve this problem.

regards,
vnk.

View 3 Replies View Related

Backing Up Trans Logs To Win2000 Server

Jul 31, 2002

I have my SQL7 server running on NT4 server. Currently the transaction log backups are on the same server but I want to back these up to a Win2000
server in another building. When creating a Backup Device in Enterprise Manager on the NT server it cannot see the drive but not the folder I have created on the Win2000 server, even though I have shared this folder out and set the permissions. Any help would be appreciated.. Thanks

View 3 Replies View Related

SQL Server - Warm Standby Using Transaction Logs

Aug 3, 1999

I have been asked to implement a Warm Standby using Transaction Logs on our main SQL Database - Version 6.5.

Can anyone give assistance regarding scripts, etc., which control the process.

Any assistance is much appreciated.

Regards,

Ian

View 1 Replies View Related

Is There A Way To Fire A Trigger When A Particular User Logs Into Sql Server?

Nov 15, 2005

Is there a way to fire a trigger when a particular user
(with sql login) logs into sql server?
We are planning to use the above trigger to start a job which inturn records some inf.

Thanks.

View 1 Replies View Related

Need A SP, XP Or USP To Read The Contents Of A File (i.e. Any OS Or SQL Server Logs )

Jun 11, 2002

hello,
I am working on some maintenance process. I need a Stored Procedure to reda the contents of a file. (i.e. OS or SQL server log files). plz help me in sort out this problem.

regards,
venkat.

View 2 Replies View Related

Securing A Database When The User Logs Onto The SQL Server.

Oct 4, 2007

Hello.

Not an SQL admin. We have an SQL 2005 server that has about 5 DB's on it. One database is maintained primarily by a third party. Often when they need to do upgrades they login remotely to the desktop of our SQL server. Is there a way to apply permissions to specific databases like you would for NTFS? That way they can only backup their database and not do anything to any other databases? Thanks.

View 3 Replies View Related

Unable To Open Current Flg From SQL Server Logs

Apr 15, 2008



Hi all

Just now a BCK job failed I have only one way to find out the cause of failure fromLOG,but log file is not opening
what is the cause may be?

View 5 Replies View Related

Standby Server - Applying Transaction Logs Automatically

Jun 21, 2001

Can anyone direct me to a code that would automatically apply transaction logs to a DB in the standby server? We have a process that dumps the transaction log backup from the primary server into the backup server every hour on the hour, but I need to apply that transaction log as soon as it is in the standby server.

I am sure someone will ask, why not do transactional replication or log shipping? My answer to that is I have yet to learn how to setup replication between servers. I need to get our backup server up and running in the next few days.

Thanks in advance for your help.

Helen

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved