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?
My company has upgraded some of the database systems to SQL 2005 while other have a fresh install.
The problem we're seeing is that the view button located in the Advanced section of the steps in the Job properties windows is greyed out. The path is valid as we can copy the path and paste it at the run command and view the log.
Does anyone know how this problem can be resolved? If we select to log the results to a table; we have access to the corresponding view button but not the one for the file system logging.
We rely heavily on this feature since we used it often under SQL 2K. Can anyone provide any helpful details to resolve this or has anyone seen this problem before???
Hi guys, just wanna ask about the backup and restore database method. What's the best way for database and restore which able to view all the transaction logs after the database being restored. Currently I backup my database daily for recovery purposes. However, if I restore the backup file at another server and use SQL log application for viewing the prefer database's transaction log, it shows all the previous log had been truncated.
Therefore, I want to know is there any way that able to get the transaction logs after restore from a database backup file? Hope able to get any assistance here as soon as possible. Thank you.
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.
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?
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?
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?
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 ?
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.
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.
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.
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.
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.
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.
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.
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.
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?
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?
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.
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?
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.
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
