I am trying to create an alert. I get the following error message,
and am asking for on figuring out how to fix this. TIA.

=======

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot create new alert. (SqlManagerUI)

------------------------------
ADDITIONAL INFORMATION:

Create failed for Alert 'LogSize'. (Microsoft.SqlServer.Smo)

For , click:
http://go.microsoft.com/fwlink?ProdN...t&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The specified object_name ('SQLServeratabases') does not exist.
(Microsoft SQL Server, Error: 14262)

For , click:
http://go.microsoft.com/fwlink?ProdN...2&LinkId=20476

Are Performance Monitor objects installed? Can you start a performance
monitor session and add any SQL Server counters?




"JOH" <JOHolloway@gmail.com> wrote in message
news:cdc7f5e1-3b12-445c-ae69-c95eda930673@34g2000hsh.googlegroups.com...
>I am trying to create an alert. I get the following error message,
> and am asking for on figuring out how to fix this. TIA.
>
> =======
>
> TITLE: Microsoft SQL Server Management Studio
> ------------------------------
>
> Cannot create new alert. (SqlManagerUI)
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Create failed for Alert 'LogSize'. (Microsoft.SqlServer.Smo)
>
> For , click:
> http://go.microsoft.com/fwlink?ProdN...t&LinkId=20476
>
> ------------------------------
>
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.ConnectionInfo)
>
> ------------------------------
>
> The specified object_name ('SQLServeratabases') does not exist.
> (Microsoft SQL Server, Error: 14262)
>
> For , click:
> http://go.microsoft.com/fwlink?ProdN...2&LinkId=20476
>

On May 15, 7:04am, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> Are Performance Monitor objects installed? Can you start a performance
> monitor session and add any SQL Server counters?
>
> "JOH" <JOHollo...@gmail.com> wrote in message
>
> news:cdc7f5e1-3b12-445c-ae69-c95eda930673@34g2000hsh.googlegroups.com...
>
>
>
> >I am trying to create an alert. I get the following error message,
> > and am asking for on figuring out how to fix this. TIA.
>
> > =======
>
> > TITLE: Microsoft SQL Server Management Studio
> > ------------------------------
>
> > Cannot create new alert. (SqlManagerUI)
>
> > ------------------------------
> > ADDITIONAL INFORMATION:
>
> > Create failed for Alert 'LogSize'. (Microsoft.SqlServer.Smo)
>
> > For , click:
> >http://go.microsoft.com/fwlink?ProdN...erver&ProdVer=....
>
> > ------------------------------
>
> > An exception occurred while executing a Transact-SQL statement or
> > batch. (Microsoft.SqlServer.ConnectionInfo)
>
> > ------------------------------
>
> > The specified object_name ('SQLServeratabases') does not exist.
> > (Microsoft SQL Server, Error: 14262)
>
> > For , click:
> >http://go.microsoft.com/fwlink?ProdN...&ProdVer=....- Hide quoted text -
>
> - Show quoted text -

That's the problem. I opened Performance Monitor and there are no SQL
Server objects listed in the Performance object dropdown. I am
taking a class, 2780B, and this virtual instance installation seems to
be missing those objects. How would I install them? Is that done
from the SQL Server 2005 installation CD?

You could try from a command prompt:

lodctr sqlctr.ini

If the SQL binn directory is not in your path environment variable then you
will need to navigate to the path where sqlctr.ini is located (I would tell
you where but this varies depending on where you installed SQL Server).

A



On 5/15/08 10:17 AM, in article
66a232cd-40b4-4e92-bd99-67ba2cf688de...oglegroups.com, "JOH"
<JOHolloway@gmail.com> wrote:

> On May 15, 7:04am, "Aaron Bertrand [SQL Server MVP]"
> <ten....@dnartreb.noraa> wrote:
>> Are Performance Monitor objects installed? Can you start a performance
>> monitor session and add any SQL Server counters?
>>
>> "JOH" <JOHollo...@gmail.com> wrote in message
>>
>> news:cdc7f5e1-3b12-445c-ae69-c95eda930673@34g2000hsh.googlegroups.com...
>>
>>
>>
>>> I am trying to create an alert. I get the following error message,
>>> and am asking for on figuring out how to fix this. TIA.
>>
>>> =======
>>
>>> TITLE: Microsoft SQL Server Management Studio
>>> ------------------------------
>>
>>> Cannot create new alert. (SqlManagerUI)
>>
>>> ------------------------------
>>> ADDITIONAL INFORMATION:
>>
>>> Create failed for Alert 'LogSize'. (Microsoft.SqlServer.Smo)
>>
>>> For , click:
>>> http://go.microsoft.com/fwlink?ProdN...erver&ProdVer=...
>
>>
>>> ------------------------------
>>
>>> An exception occurred while executing a Transact-SQL statement or
>>> batch. (Microsoft.SqlServer.ConnectionInfo)
>>
>>> ------------------------------
>>
>>> The specified object_name ('SQLServeratabases') does not exist.
>>> (Microsoft SQL Server, Error: 14262)
>>
>>> For , click:
>>> http://go.microsoft.com/fwlink?ProdN...r&ProdVer=...-
>>> Hide quoted text -
>
>>
>> - Show quoted text -
>
> That's the problem. I opened Performance Monitor and there are no SQL
> Server objects listed in the Performance object dropdown. I am
> taking a class, 2780B, and this virtual instance installation seems to
> be missing those objects. How would I install them? Is that done
> from the SQL Server 2005 installation CD?

On May 15, 7:32am, "Aaron Bertrand [SQL Server MVP]"
<ten....@dnartreb.noraa> wrote:
> You could try from a command prompt:
>
> lodctr sqlctr.ini
>
> If the SQL binn directory is not in your path environment variable then you
> will need to navigate to the path where sqlctr.ini is located (I would tell
> you where but this varies depending on where you installed SQL Server).
>
> A
>
> On 5/15/08 10:17 AM, in article
> 66a232cd-40b4-4e92-bd99-67ba2cf68...@s50g2000hsb.googlegroups.com, "JOH"
>
>
>
> <JOHollo...@gmail.com> wrote:
> > On May 15, 7:04am, "Aaron Bertrand [SQL Server MVP]"
> > <ten....@dnartreb.noraa> wrote:
> >> Are Performance Monitor objects installed? Can you start a performance
> >> monitor session and add any SQL Server counters?
>
> >> "JOH" <JOHollo...@gmail.com> wrote in message
>
> >>news:cdc7f5e1-3b12-445c-ae69-c95eda930673@34g2000hsh.googlegroups.com...
>
> >>> I am trying to create an alert. I get the following error message,
> >>> and am asking for on figuring out how to fix this. TIA.
>
> >>> =======
>
> >>> TITLE: Microsoft SQL Server Management Studio
> >>> ------------------------------
>
> >>> Cannot create new alert. (SqlManagerUI)
>
> >>> ------------------------------
> >>> ADDITIONAL INFORMATION:
>
> >>> Create failed for Alert 'LogSize'. (Microsoft.SqlServer.Smo)
>
> >>> For , click:
> >>>http://go.microsoft.com/fwlink?ProdN...erver&ProdVer=...
>
> >>> ------------------------------
>
> >>> An exception occurred while executing a Transact-SQL statement or
> >>> batch. (Microsoft.SqlServer.ConnectionInfo)
>
> >>> ------------------------------
>
> >>> The specified object_name ('SQLServeratabases') does not exist.
> >>> (Microsoft SQL Server, Error: 14262)
>
> >>> For , click:
> >>>http://go.microsoft.com/fwlink?ProdN...erver&ProdVer=...
> >>> Hide quoted text -
>
> >> - Show quoted text -
>
> > That's the problem. I opened Performance Monitor and there are no SQL
> > Server objects listed in the Performance object dropdown. I am
> > taking a class, 2780B, and this virtual instance installation seems to
> > be missing those objects. How would I install them? Is that done
> > from the SQL Server 2005 installation CD?- Hide quoted text -
>
> - Show quoted text -

OK, I did that, and a message returned saying:
Counters for MSSQLServer are already installed.
Yet, when I go into PerfMon, no counters.

This class is being taught on a virtualized server .. rather, each
student's PC set up so that the student opens a virtual environment to
do the practices and labs. Supposedly (according to the instructor)
the counters were in PerfMon as of last week, but of course, this is
the same guy who tried to tell us yesterday that DDL triggers can't
stop a table drop. Hello, rollback? Anyway, thanks Aaron, I think
this isn't going to happen in this situation, but when I get back to
the office I'll practice it there.