dbTalk Databases Forums  

SQL 2000 Optimize Maint Step locks up server

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools SQL 2000 Optimize Maint Step locks up server

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL 2000 Optimize Maint Step locks up server in the microsoft.public.sqlserver.tools forum.



Reply
Page 6 of 6 < 1 2 3 4 5 6
 
Thread Tools Display Modes
  #51  
Old   
TMurnion
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-24-2008 , 03:33 PM





Same thing, different way to access. I went in through Enterprise
Managerunder the SQL Server Logs. I misnamed it "Activity log". sorry
about that. That's what I get for writing the email from memory. ;-)

Thanks

Tony


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
TMurnion (tmurnion (AT) azworld (DOT) com) writes:
I've checked both the Event Logs via Adminstrative Tools and the Activity
Logs within SQL. Is there another place to check.

C:\Program Files\Microsoft SQL Server\MSSQL\LOG, files ERRORLOG to
ERRORLOG.6, given that you have SQL Server installed in the default
location. I don't if this what you refer to as the "Activity logs",
but these are the files I'm curious about.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #52  
Old   
TMurnion
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-24-2008 , 03:33 PM





Same thing, different way to access. I went in through Enterprise
Managerunder the SQL Server Logs. I misnamed it "Activity log". sorry
about that. That's what I get for writing the email from memory. ;-)

Thanks

Tony


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
TMurnion (tmurnion (AT) azworld (DOT) com) writes:
I've checked both the Event Logs via Adminstrative Tools and the Activity
Logs within SQL. Is there another place to check.

C:\Program Files\Microsoft SQL Server\MSSQL\LOG, files ERRORLOG to
ERRORLOG.6, given that you have SQL Server installed in the default
location. I don't if this what you refer to as the "Activity logs",
but these are the files I'm curious about.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #53  
Old   
TMurnion
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-24-2008 , 03:33 PM


Same thing, different way to access. I went in through Enterprise
Managerunder the SQL Server Logs. I misnamed it "Activity log". sorry
about that. That's what I get for writing the email from memory. ;-)

Thanks

Tony


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
TMurnion (tmurnion (AT) azworld (DOT) com) writes:
I've checked both the Event Logs via Adminstrative Tools and the Activity
Logs within SQL. Is there another place to check.

C:\Program Files\Microsoft SQL Server\MSSQL\LOG, files ERRORLOG to
ERRORLOG.6, given that you have SQL Server installed in the default
location. I don't if this what you refer to as the "Activity logs",
but these are the files I'm curious about.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #54  
Old   
TMurnion
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-24-2008 , 03:33 PM


Same thing, different way to access. I went in through Enterprise
Managerunder the SQL Server Logs. I misnamed it "Activity log". sorry
about that. That's what I get for writing the email from memory. ;-)

Thanks

Tony


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
TMurnion (tmurnion (AT) azworld (DOT) com) writes:
I've checked both the Event Logs via Adminstrative Tools and the Activity
Logs within SQL. Is there another place to check.

C:\Program Files\Microsoft SQL Server\MSSQL\LOG, files ERRORLOG to
ERRORLOG.6, given that you have SQL Server installed in the default
location. I don't if this what you refer to as the "Activity logs",
but these are the files I'm curious about.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
  #55  
Old   
TMurnion
 
Posts: n/a

Default Re: SQL 2000 Optimize Maint Step locks up server - 07-24-2008 , 03:33 PM


Same thing, different way to access. I went in through Enterprise
Managerunder the SQL Server Logs. I misnamed it "Activity log". sorry
about that. That's what I get for writing the email from memory. ;-)

Thanks

Tony


"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
TMurnion (tmurnion (AT) azworld (DOT) com) writes:
I've checked both the Event Logs via Adminstrative Tools and the Activity
Logs within SQL. Is there another place to check.

C:\Program Files\Microsoft SQL Server\MSSQL\LOG, files ERRORLOG to
ERRORLOG.6, given that you have SQL Server installed in the default
location. I don't if this what you refer to as the "Activity logs",
but these are the files I'm curious about.



--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx



Reply With Quote
Reply
Page 6 of 6 < 1 2 3 4 5 6

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top