sql server logs, no views? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

sql server logs, no views?

Author

Topic

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-02-27 : 00:40:58

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...

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-02-27 : 12:03:06

How are you trying to view the error logs?

SQL Express was released last November, you should really download the release version rather than using the CTP. Or are you talking about the Management Studio Express CTP?

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-02-27 : 20:07:51

Hi Mike,

It's the Management Studio Express CTP

I tried all (I think...) actions..

i tried on single click
i tried on double click
i tried refresh
and even right click

and so i tried to expand
but the thing won't budge
so i gave up
and created a post

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

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-03-01 : 23:19:14

Hey Jen,

Management Studio Express doesn't have a log viewer, so you can't actually open the logs directly from the UI. I wouldn't expect it to give an error, I'd expect it to do nothing, which is what it does for me. I have a newer version of the tool so it's possible we've corrected the error since the CTP was released.

So how do you get the log? If you just want to take a look at it to find an error for troubleshooting, just go to the error log directory and open them in Notepad.

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2006-03-02 : 01:47:57

i'll try the new CTP Mike

I'm actually evaluating this product for some poor guy who I am not sure if he is that resourceful nor patient to search for the logs

thanks a bunch... you'll be hearing a lot from me eh?

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

mikewa
Microsoft SQL Server Product Team

84 Posts

Posted - 2006-03-03 : 22:40:58

Sounds good Jen, you'll have to wait a bit for the new CTP as it's not public yet. I expect you should see something this month, keep your eye on the SQL Developer Center on MSDN for an announcement. http://msdn.microsoft.com/sql

Regards,
Mike Wachal
SQL Express

This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources