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 Eval

Hi All,

I've just downloaded and installed the evaluation version of msql2005, it all seemed to go ok apart from a message towards the end of the install saying the event log was full. I cleared it an the install finished. Problem is I don't have the server manager on my menu, nor kind I find any way to run it

Hope someone can help

Regards

There is no such thing as Server Manager as there was in SQL2K. Instead, we have the SQL Configuration Manager which allows you to stop and start the services and other things besides eg as a replacement for the SQL Server Network Utility.

HTH!

|||

Hi many thanks for the reply but I am confused.

How do I create a new database or set permissions, view the tables etc etc?

http://msdn2.microsoft.com/en-us/library/ms174173.aspx

This link details Introducing SQL Server Management Studio as being new in SQL Server 2005. It also states that:-

By default, SQL Server Management Studio is installed in C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.

I've looked there and the folder is empty.

best Regards

|||

Ah, sorry- my mistake.

There is no such thing as Query Analyzer or Enterprise Manager in SQL2005 - as you've discovered, the new GUI is SQL Server Management Studio.

When you ran through the install, you should have had an option to select workstation components. Do know if this was selected?

If not, have a look at this article to install them.

http://support.microsoft.com/kb/913967

HTH!

|||

Many thanks for pointing me in the right direction, I now have it installed. Just one more question you may be kind enough to answer. I installed everything on the c: drive of my server, thinking that would be safest. However, I really want to keep my .MDF files etc on the local D: Drive of the server. Is that possible?

Best Regards

|||

Yes it is possible you have to detach all the databases and move the mdf or ldf files as per your desire and reattach it.......for user dbs its quite simple but for system databases you need to use Trace flag 3608 (- T3608) and then perform detach\attach dbs ...you can refer these links for moving the dbs,

http://www.sql-articles.com/articles/msysdb.htm

http://deepakinsql.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html

http://support.microsoft.com/?id=224071

|||

Mmany thanks DeePak those links were very helpfull. I'll give it a try

Best Regards

2005 Eval

Hi All,

I've just downloaded and installed the evaluation version of msql2005, it all seemed to go ok apart from a message towards the end of the install saying the event log was full. I cleared it an the install finished. Problem is I don't have the server manager on my menu, nor kind I find any way to run it

Hope someone can help

Regards

There is no such thing as Server Manager as there was in SQL2K. Instead, we have the SQL Configuration Manager which allows you to stop and start the services and other things besides eg as a replacement for the SQL Server Network Utility.

HTH!

|||

Hi many thanks for the reply but I am confused.

How do I create a new database or set permissions, view the tables etc etc?

http://msdn2.microsoft.com/en-us/library/ms174173.aspx

This link details Introducing SQL Server Management Studio as being new in SQL Server 2005. It also states that:-

By default, SQL Server Management Studio is installed in C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.

I've looked there and the folder is empty.

best Regards

|||

Ah, sorry- my mistake.

There is no such thing as Query Analyzer or Enterprise Manager in SQL2005 - as you've discovered, the new GUI is SQL Server Management Studio.

When you ran through the install, you should have had an option to select workstation components. Do know if this was selected?

If not, have a look at this article to install them.

http://support.microsoft.com/kb/913967

HTH!

|||

Many thanks for pointing me in the right direction, I now have it installed. Just one more question you may be kind enough to answer. I installed everything on the c: drive of my server, thinking that would be safest. However, I really want to keep my .MDF files etc on the local D: Drive of the server. Is that possible?

Best Regards

|||

Yes it is possible you have to detach all the databases and move the mdf or ldf files as per your desire and reattach it.......for user dbs its quite simple but for system databases you need to use Trace flag 3608 (- T3608) and then perform detach\attach dbs ...you can refer these links for moving the dbs,

http://www.sql-articles.com/articles/msysdb.htm

http://deepakinsql.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html

http://support.microsoft.com/?id=224071

|||

Mmany thanks DeePak those links were very helpfull. I'll give it a try

Best Regards

2005 Developer - Perf Monitor Counter Check Failed message

Trying to install 2005 Dev edition in xp pro, sp2.

Performance Monitor Counter Check Failed Error.
Had to stop the install twice at the point it verified what components were to be included as
the docs were not going to be installed. Resolved the issue.

Now it won't pass the system config test because the registry is not the way it wants it.
I look up the messages and the only solution is to hack the registry and risk my system.

This is nuts.

Isn't there some way to restart cleanly without hacking registry keys ?

Help.

I know it isn't a nice solution, but this thread sums up the registry changes to fix this problem. Sorry for the hassle. The thread discusses the released article to solve this, as well as some gotchas that aren't covered in the doc.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=356308&SiteID=1

Thanks,
Sam Lester (MSFT)

|||Thanks,
I was able to complete the installation and thought all was well.
I was wrong.

No data base tools or docs were installed, so I ran the install again
and it says they are already there.. They are not.

I installed 2005 dev on my laptop with no issues and the installed dirs and products are
not the same.

I tried to uninstall 2005 on the problem desktop but it errors out during uninstall and no
I am trapped in do mans land.

Why can't the install program function correctly?

How can I start from scratch without rebuilding my machine?

2005 Beta 2 install problems

When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
Beta 2 Setup has detected incompatible beta components from Visual Studio or
SQL Server. To proceed, use Windows add or Remove Programs to remove
previous.." etc etc.
I have tried to remove almost everything that has anything to do with .NET.
and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
helps. Can anyone help me?
Thore Berntsen.
NorwayYou might want to post in the SQL Server 2005 setup newsgroup.
For information on access to those groups:
url]
[url]http://www.aspfaq.com/" target="_blank">http://communities.microsoft.com/ne...www.aspfaq.com/
(Reverse address to reply.)
"Thore Berntsen" <notrashmail@.please.zz> wrote in message
news:OFRRUEaiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
> Beta 2 Setup has detected incompatible beta components from Visual Studio
or
> SQL Server. To proceed, use Windows add or Remove Programs to remove
> previous.." etc etc.
> I have tried to remove almost everything that has anything to do with
.NET.
> and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
> helps. Can anyone help me?
> Thore Berntsen.
> Norway
>
>|||I receive the same messages as you received and followed the same processes
you followed but nothing helped me at all. I ,too , am looking for someone t
o help me sort this problem out...
Barkın nulu
Turkey
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...|||There will be more people able to help you sort the problem out if you post
in the SQL Server 2005 newsgroups.
For information on access to those groups:
url]
[url]http://www.aspfaq.com/" target="_blank">http://communities.microsoft.com/ne...www.aspfaq.com/
(Reverse address to reply.)
"BARKIN NULU" <barkin.unuulu@.huk.gov.tr> wrote in message
news:uvlvrrjlEHA.2864@.TK2MSFTNGP14.phx.gbl...
> I receive the same messages as you received and followed the same
processes you followed but nothing helped me at all. I ,too , am looking for
someone to help me sort this problem out...
> Barkın nulu
> Turkey
> ****************************************
******************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

2005 Beta 2 install problems

When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
Beta 2 Setup has detected incompatible beta components from Visual Studio or
SQL Server. To proceed, use Windows add or Remove Programs to remove
previous.." etc etc.
I have tried to remove almost everything that has anything to do with .NET.
and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
helps. Can anyone help me?
Thore Berntsen.
Norway
You might want to post in the SQL Server 2005 setup newsgroup.
For information on access to those groups:
http://communities.microsoft.com/new...elcomePage.htm
http://www.aspfaq.com/
(Reverse address to reply.)
"Thore Berntsen" <notrashmail@.please.zz> wrote in message
news:OFRRUEaiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
> Beta 2 Setup has detected incompatible beta components from Visual Studio
or
> SQL Server. To proceed, use Windows add or Remove Programs to remove
> previous.." etc etc.
> I have tried to remove almost everything that has anything to do with
..NET.
> and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
> helps. Can anyone help me?
> Thore Berntsen.
> Norway
>
>
|||I receive the same messages as you received and followed the same processes you followed but nothing helped me at all. I ,too , am looking for someone to help me sort this problem out...
Barkın nulu
Turkey
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
|||There will be more people able to help you sort the problem out if you post
in the SQL Server 2005 newsgroups.
For information on access to those groups:
http://communities.microsoft.com/new...elcomePage.htm
http://www.aspfaq.com/
(Reverse address to reply.)
"BARKIN NULU" <barkin.unuulu@.huk.gov.tr> wrote in message
news:uvlvrrjlEHA.2864@.TK2MSFTNGP14.phx.gbl...
> I receive the same messages as you received and followed the same
processes you followed but nothing helped me at all. I ,too , am looking for
someone to help me sort this problem out...
> Barkın nulu
> Turkey
> ************************************************** ********************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...

2005 Beta 2 install problems

When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
Beta 2 Setup has detected incompatible beta components from Visual Studio or
SQL Server. To proceed, use Windows add or Remove Programs to remove
previous.." etc etc.
I have tried to remove almost everything that has anything to do with .NET.
and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
helps. Can anyone help me?
Thore Berntsen.
NorwayYou might want to post in the SQL Server 2005 setup newsgroup.
For information on access to those groups:
http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Thore Berntsen" <notrashmail@.please.zz> wrote in message
news:OFRRUEaiEHA.3608@.TK2MSFTNGP09.phx.gbl...
> When I try to install SQL Server 2005 Beta 2 I get the message "SQL Server
> Beta 2 Setup has detected incompatible beta components from Visual Studio
or
> SQL Server. To proceed, use Windows add or Remove Programs to remove
> previous.." etc etc.
> I have tried to remove almost everything that has anything to do with
.NET.
> and SQL server Including the VS studio, .NET Framework 2.0 etc. Nothing
> helps. Can anyone help me?
> Thore Berntsen.
> Norway
>
>|||I receive the same messages as you received and followed the same processes you followed but nothing helped me at all. I ,too , am looking for someone to help me sort this problem out...
Barkın Ünüulu
Turkey
**********************************************************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...|||There will be more people able to help you sort the problem out if you post
in the SQL Server 2005 newsgroups.
For information on access to those groups:
http://communities.microsoft.com/newsgroups/ICP/sqlserver2005/us/welcomePage.htm
--
http://www.aspfaq.com/
(Reverse address to reply.)
"BARKIN ÜNÜULU" <barkin.unuulu@.huk.gov.tr> wrote in message
news:uvlvrrjlEHA.2864@.TK2MSFTNGP14.phx.gbl...
> I receive the same messages as you received and followed the same
processes you followed but nothing helped me at all. I ,too , am looking for
someone to help me sort this problem out...
> Barkın Ünüulu
> Turkey
> **********************************************************************
> Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
> Comprehensive, categorised, searchable collection of links to ASP &
ASP.NET resources...