2005: SIMPLE QUESTION: error log

Hello,
When I received a message "... See the SQL Server errorlog for details
..." I opened Management / SQL Server Logs where I see:
Current - 2006-05-30 12:19:00
Archive #1 - 2006-05-30 09:49:00
Archive #2 - 2006-05-30 08:27:00
etc.
But each of these logs contains "0 Item(s)". How to see log entries?
Thank you very much
/RAM/R.A.M. (r_ahimsa_m@.poczta.onet.pl) writes:
> Hello,
> When I received a message "... See the SQL Server errorlog for details
> ..." I opened Management / SQL Server Logs where I see:
> Current - 2006-05-30 12:19:00
> Archive #1 - 2006-05-30 09:49:00
> Archive #2 - 2006-05-30 08:27:00
> etc.
> But each of these logs contains "0 Item(s)". How to see log entries?

You did double-click on the error log in the list, did you?

You should be able to see log entries this way, but it could be some
permissions issue.

Also make sure that you have no filter active.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Tue, 30 May 2006 12:27:57 +0200, R.A.M. wrote:

>Hello,
>When I received a message "... See the SQL Server errorlog for details
>..." I opened Management / SQL Server Logs where I see:
> Current - 2006-05-30 12:19:00
> Archive #1 - 2006-05-30 09:49:00
> Archive #2 - 2006-05-30 08:27:00
>etc.
>But each of these logs contains "0 Item(s)". How to see log entries?
>Thank you very much
>/RAM/

Hi RAM,

Have you tried right-clicking the log and selecting "View SQL Server
Log"?

(Double-clicking the title works too)

--
Hugo Kornelis, SQL Server MVP

2005 Management Studio: Jobs Details (summary page)

I'm missing the info I got from EM on jobs, in the summary page, e.g. when a
job was last run, success/failure, scheduled, enabled, etc.
I don't see any way to add these columns on the summary page in Managment
Studio, am I missing something, or is this info not available there?
Thanks
Tom
TomT wrote:
> I'm missing the info I got from EM on jobs, in the summary page, e.g. when a
> job was last run, success/failure, scheduled, enabled, etc.
> I don't see any way to add these columns on the summary page in Managment
> Studio, am I missing something, or is this info not available there?
> Thanks
> Tom
Tom,
Go to Object Explorer - SQL Server Agent - Jobs. Here you can right
click on the job and get the job history, properties etc. Pretty much
the same as you're used to on EM but it looks a bit different.
HTH
Regards
Steen
|||Hi Tom,
In SQL Server 2005, we use Job Activity Monitor to see following items
Name - Name of the job.
Enabled - Whether the job is enabled (yes) or not enabled (no).
Status - Current status of the job.
Last Run Outcome - Job status when last run.
Last Run - Date and time job was last run.
Next Run - Date and time the job is next scheduled to run.
Category - The job category assigned to the job.
Runnable - Yes if the job can be run; No if the job cannot be run.
Scheduled - Yes if the job is assigned to a job schedule; No if the job has
no schedule.
For more detailed information, check BOL or MSDN topic
Job Activity Monitor
http://msdn2.microsoft.com/en-us/library/ms188272.aspx
How to: View Job Activity (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms187449.aspx
Monitoring Job Activity
http://msdn2.microsoft.com/en-us/library/ms188272.aspx
How to: Set Up the Job History Log (SQL Server Management Studio)
http://msdn2.microsoft.com/en-us/library/ms175072.aspx
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

2005 Directory Tree

I am look to maintain a directory tree table in SQL Server 2005. The table
will contain details of file and folder paths, titles, size and a few other
additional fields not related to the file system.
Before I begin, and start writing code to maintain the table is there
anything in 2005 which could do most of the work for me? For example, the
file system be watched for changes and update the table automatically, i.e.
files or folders added, changed or deleted.
I keep hearing about all the fantastic new features in 2005, I would be
really impressed if it means I don't need to do any work for this.
Any help would be greatly appreciated.
DavidHi
There are no new functions in SQL 2k5 that can do this. Unfortunately SQL
Server is not build for file handling. I guess thats the only functionality
that Microsoft has missed out from that :)
--
"Davie" wrote:

> I am look to maintain a directory tree table in SQL Server 2005. The tabl
e
> will contain details of file and folder paths, titles, size and a few othe
r
> additional fields not related to the file system.
> Before I begin, and start writing code to maintain the table is there
> anything in 2005 which could do most of the work for me? For example, the
> file system be watched for changes and update the table automatically, i.e
.
> files or folders added, changed or deleted.
> I keep hearing about all the fantastic new features in 2005, I would be
> really impressed if it means I don't need to do any work for this.
> Any help would be greatly appreciated.
> David
>
>|||I am sure I read a while ago, think it was prior to release, Notification
Services can have a file system watch event?
"Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
news:7EDC42CB-A6C5-4B25-960F-9065284E6C8E@.microsoft.com...
> Hi
> There are no new functions in SQL 2k5 that can do this. Unfortunately
> SQL
> Server is not build for file handling. I guess thats the only
> functionality
> that Microsoft has missed out from that :)
> --
>
>
> "Davie" wrote:
>|||I am not sure about that. Sorry about the wrong info if one exists.
--
"Davie" wrote:

> I am sure I read a while ago, think it was prior to release, Notification
> Services can have a file system watch event?
>
> "Omnibuzz" <Omnibuzz@.discussions.microsoft.com> wrote in message
> news:7EDC42CB-A6C5-4B25-960F-9065284E6C8E@.microsoft.com...
>
>