Best Project Template & "The View of the event class could not be materialized"

Can someone explain this statement to me. "The View of the event class could not be materialized". I get it when I try to do a build of my Instance.

Also, yesterday I used CopySample to prepare an instance for my project. I'm not sure if this is the right way to go.

Is there a better template to use or process to follow to create a complete project (including Visual Studio Build Scripts, etc...)

Thanks

...Ray

Ray,
"The View of the event class could not be materialized" is a runtime error, not a build-time error. Are you sure you saw this while building your instance?

Here's what the error means:
Before SQL-NS executes the rules in your application (match rules or chronicle rules) it first builds views of the events and subscriptions tables. These views provide the input data for the rules: they contain only the events and subscriptions against which the rule should operate in any given firing. The error means that something when wrong during the process of setting up these views. Usually the rest of the error message provides more detail on the problem. If you could include the complete message, we'd be able to diagnose the problem better. The most common cause of this is a timeout, which can happen if the event batch is huge.

Also, please tell us what version of SQL-NS you're using - is it SQL 2000 (NS2.0) or SQL 2005? If 2005, which build are you using?

Regarding your question about the best template, you can certainly use the ones provided with the samples. However, this does involve starting from a pre-existing application and changing/removing things to make it do what you want. In my book (http://www.amazon.com/exec/obidos/tg/detail/-/0672326647/) I describe how to set up a "minimal" instance and application (with just the elements required to get it to build) and then add the code you want piece by piece. The book's CD-ROM provides all the necessary files and instructions on setting this up.

Hope this helps.
-shyam

Best Damn Clustering Class...Period!

I had the opportunity to attend a Windows 2003 Clustering Class offered by
Rod (and Russ) in NYC. In my eleven years of IT, I have attended 8 or so
classes. This was the best class I have ever attended - period! The way
that Rod and Russ have designed this course, I wish MSL (Microsoft Learning)
would adopt that format. It just flowed perfectly. It also gave you the
choice of which order you wanted to do the labs in, without affecting the
desired outcomes. They have put a lot of work into making the one of the
best classes ever.
My only regret is that I could never deliver this courseware to students to
allow them to have the same experience I had since it is not for resale. You
can only take it with Rod or Russ, but that is so worth it. The only other
courseware to come close to this level of completeness was the 827 and 828
kits. I love those classes, too!
Anyway, if you need a vacation and want to take the best damn class you will
ever take, you must take Rod and Russ' class.
(Now let me tell you how much I really liked it!)
Jim Thyne - MCT
Thanks Jim,
It was a pleasure to have you in class. ClusterHelp.com thanks you!
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Jim Thyne" <jthyne@.thlee.com> wrote in message
news:OD7kQBi6GHA.940@.TK2MSFTNGP03.phx.gbl...
>I had the opportunity to attend a Windows 2003 Clustering Class offered by
>Rod (and Russ) in NYC. In my eleven years of IT, I have attended 8 or so
>classes. This was the best class I have ever attended - period! The way
>that Rod and Russ have designed this course, I wish MSL (Microsoft
>Learning) would adopt that format. It just flowed perfectly. It also gave
>you the choice of which order you wanted to do the labs in, without
>affecting the desired outcomes. They have put a lot of work into making
>the one of the best classes ever.
> My only regret is that I could never deliver this courseware to students
> to allow them to have the same experience I had since it is not for
> resale. You can only take it with Rod or Russ, but that is so worth it.
> The only other courseware to come close to this level of completeness was
> the 827 and 828 kits. I love those classes, too!
> Anyway, if you need a vacation and want to take the best damn class you
> will ever take, you must take Rod and Russ' class.
> (Now let me tell you how much I really liked it!)
>
> Jim Thyne - MCT
>
|||Can't wait till you come to London :-)
Mark Fugatt
Premier Field Engineering
Microsoft
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:e8ypAzj6GHA.2384@.TK2MSFTNGP04.phx.gbl...
> Thanks Jim,
> It was a pleasure to have you in class. ClusterHelp.com thanks you!
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Jim Thyne" <jthyne@.thlee.com> wrote in message
> news:OD7kQBi6GHA.940@.TK2MSFTNGP03.phx.gbl...
>
|||"Mark Fugatt [MSFT]" <markfu@.online.microsoft.com> wrote in message
news:eTjC5Qm6GHA.4404@.TK2MSFTNGP04.phx.gbl...
> Can't wait till you come to London :-)
> --
> Mark Fugatt
> Premier Field Engineering
> Microsoft
Tentative date is set of March 6-9th. Details to follow.
|||how about in Asia-Pacific Region?
"Russ Kaufmann (MVP)" <russ@.clusterhelp.com> wrote in message
news:OqWuxaq6GHA.1560@.TK2MSFTNGP04.phx.gbl...
> "Mark Fugatt [MSFT]" <markfu@.online.microsoft.com> wrote in message
> news:eTjC5Qm6GHA.4404@.TK2MSFTNGP04.phx.gbl...
> Tentative date is set of March 6-9th. Details to follow.
>
|||"Louie Lubangco" <llubangco@.iti-consulting.com> wrote in message
news:ex%23VgB36GHA.3760@.TK2MSFTNGP02.phx.gbl...
> how about in Asia-Pacific Region?
>
Sorry, but we have no plans at this time for the year 2006 or 2007.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Denver starting Nov 14th
NYC starting Dec 4th.
|||Find at least 9 more people, and I will come to Japan or Singapore in a
heartbeat.
Cheers,
Rodney R. Fournier
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner
"Louie Lubangco" <llubangco@.iti-consulting.com> wrote in message
news:ex%23VgB36GHA.3760@.TK2MSFTNGP02.phx.gbl...
> how about in Asia-Pacific Region?
> "Russ Kaufmann (MVP)" <russ@.clusterhelp.com> wrote in message
> news:OqWuxaq6GHA.1560@.TK2MSFTNGP04.phx.gbl...
>
|||how about PF?
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:%23OeoZy86GHA.4996@.TK2MSFTNGP04.phx.gbl...
> Find at least 9 more people, and I will come to Japan or Singapore in a
> heartbeat.
> Cheers,
> Rodney R. Fournier
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering Website
> http://www.msmvps.com/clustering - Blog
> http://www.clusterhelp.com - Cluster Training
> ClusterHelp.com is a Microsoft Certified Gold Partner
>
> "Louie Lubangco" <llubangco@.iti-consulting.com> wrote in message
> news:ex%23VgB36GHA.3760@.TK2MSFTNGP02.phx.gbl...
>
|||MABUHAY Louie
Congratulations to ClusterHelp.com. - Rod and Russ. Maybe you can come up
with a business plan to have partners to deliver the training for you in Asia
Pacific ;) ... or franchise, maybe
MCP MCDBA MCAD MCSD MCT MCTS:SQL Server 2005
"Helping people grow and develop their full potential as God has plan for
them"
"Louie Lubangco" wrote:

> how about PF?
> "Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
> message news:%23OeoZy86GHA.4996@.TK2MSFTNGP04.phx.gbl...
>
>
|||"bass_player" <bassplayer@.discussions.microsoft.com> wrote in message
news:B9DEB1FE-0E7D-4A76-A616-589C4BFB707D@.microsoft.com...
> MABUHAY Louie
> Congratulations to ClusterHelp.com. - Rod and Russ. Maybe you can come
> up
> with a business plan to have partners to deliver the training for you in
> Asia
> Pacific ;) ... or franchise, maybe
Actually, we are talking about that. Our UK class will be a Train the
Trainer class for anyone that wants to train in Europe using our materials
and meets our standards.
We would love to do the same thing in Sinapore for Asia-Pacific market.
However, we don't have any contacts there to arrange a class and market in
the area.
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp
The next ClusterHelp classes are:
Denver starting Nov 14th
NYC starting Dec 4th.

beginning SQL

I purchased SQL Server 2005 and intend to take a class this month. I have installed it. How do I get started trying it out? I took an online tutorial, but I don't understand the mechanics of accessing the db to start with or if I even have a db to work with. Any suggestions?

Book on line > SQL Server 2005 Tutorials >SQL Server Tools Tutorial

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqltut9/html/655e709b-346b-469c-bddc-a5a0238d07e0.htm

HTH

Beginners question to coding

ok this is for a class assignment so if anyone doesnt want to help thats cool, but its just a small extra credit assignment and we havent gone over it in class and and the book, well is confusing to say the least so here are my questions:

What is the total weight of different colored parts?

ok so i have a parts table, with pcolor and pweight in it but i am unsure how to code that, here is kinda what i think it might be, i have no real way to check to see if it is correct though:

Select sum pweight
from parts
where distinct pcolor

looks horribly wrong so any help is appreciated. here is another one:

What colored part has total weight greater than 8 units?

select pcolor
from parts
where sum pweight > 8

?
i dunno lol.

there is a hint that says to use "GROUP BY" and "HAVING" but i dont see how that fits in... any ideas?I'll put the keywords in the proper order; you figure out the rest:

SELECT
FROM
WHERE
GROUP BY
HAVING

Notes:
1. I don't think you need the WHERE clause in this particular exercise at all.
2. You won't need HAVING in the first part

HAVING was just so totally cool when I first learned how to use it. It is enormously useful at times.

Regards,

hmscott|||This is a super intro to SQL - you will figure out your answers in no time:
http://www.w3schools.com/sql/sql_intro.asp

I'll give you another hint - no need for distinct.

beginner student PL/SQL to T-SQL

This summary is not available. Please click here to view the post.