anynone seen this error

Hello,
Does anyone seen this error before?
I've searched through the web, books online, and googles groups. NOTHING.
Event ID 17052, Category 2
Error 50501, severity 16
State 1
DBE_add_event: Invalid taskbinder (taskbinder id=0, rows=0)
This event occurs very often, like each 4-5 minutes....
ThanksIs this error from SQL Server as source? If so, then it is a user-defined error (as it has > 50000
as error number). I suggest you check this with your application vendor.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Dany" <dany_langlois@.yahoo.com> wrote in message
news:4080a045.0312160725.2f6df8db@.posting.google.com...
> Hello,
> Does anyone seen this error before?
> I've searched through the web, books online, and googles groups. NOTHING.
>
> Event ID 17052, Category 2
> Error 50501, severity 16
> State 1
> DBE_add_event: Invalid taskbinder (taskbinder id=0, rows=0)
>
> This event occurs very often, like each 4-5 minutes....
> Thankssql

any good books on SQL queries?

can anyone recommend a good book to teach myself SQL queries? I have a basic understanding but want to improve

You might start out with Bob Beauchemin's excellent book: A Developer's Guide to SQL Server 2005.

Eventually, you will graduate to Itzik Ben-Gan's (and others) two excellent books: T-SQL Programming and T-SQL Querying.

There are several other excellent books, those come to the top of my list.

|||

Mandy1,

I suggest to add this book to Arnie's list.

Pro SQL Server 2005 Database Design and Optimization

http://www.amazon.com/Server-2005-Database-Design-Optimization/dp/1590595297/ref=sr_1_1/105-0322821-1919616?ie=UTF8&s=books&qid=1180705710&sr=1-1

AMB

|||

Ken Henderson is also worth to read...

The Guru's Guide to Transact-SQL

ISBN 0-201-61576-2

regards

Andreas

any good books on SQL queries?

can anyone recommend a good book to teach myself SQL queries? I have a basic understanding but want to improve

You might start out with Bob Beauchemin's excellent book: A Developer's Guide to SQL Server 2005.

Eventually, you will graduate to Itzik Ben-Gan's (and others) two excellent books: T-SQL Programming and T-SQL Querying.

There are several other excellent books, those come to the top of my list.

|||

Mandy1,

I suggest to add this book to Arnie's list.

Pro SQL Server 2005 Database Design and Optimization

http://www.amazon.com/Server-2005-Database-Design-Optimization/dp/1590595297/ref=sr_1_1/105-0322821-1919616?ie=UTF8&s=books&qid=1180705710&sr=1-1

AMB

|||

Ken Henderson is also worth to read...

The Guru's Guide to Transact-SQL

ISBN 0-201-61576-2

regards

Andreas

Any good books on Microsoft Reporting Services for a Visual Studio developer?

I'm starting to useMicrosoft Reporting Services and coming from a Crystal background. I'm wondering if anyone is aware of a good book that addresses development of Microsoft reports within the Visual Studio context.

Thanks!

BCB

I just ordered Microsoft SQL Server 2005 Reporting Services 2005 by Brian Larson through amazon this morning. It is supposed to be here tomorrow sometime. I can let you know if it is any good. It did get good reviews on the amazon site and I also found amazon to be the cheapest.

I am having problems with my reporting deployment to the server. It keeps telling me that the ASPNET account does not have sufficient privileges to perform the operation.

|||I have been using Brian Larson's book (SQL Server 2005 Reporting Services) for several months and it is wonderful. It reminds me of a good Wrox book in the sense that it uses cumulative examples where a report that was developed earlier may be used as the basis for demonstrating a new feature. (Don't get me wrong - there are a bunch of report types in the book including Web Services.) You can work through the examples yourself or there is downloadable source code. The book covers both the design and administration side of Reporting Services. The book is less than 600 pages (not counting the appendices) and it has many screen shots that make explicit what the author has just described in words. I like that. The examples really work and files that he references are present in the folders where he states they will be found. I like that even more. Larson isn't just a technical guy who knows a lot about this product; he's an accomplished writer as well. I found that the book was a fairly quick read that managed to leave a lot of knowledge behind after I put it down for the final time. Did I mention that I recommend it?|||Hey guyin kalamazoo,

I just recently went through this learning curve. You have to add permissions for ASPNET to the database that the datasource is trying to access. Unless you store the credentials in the datasource, then it will use those credentials to access the database.

Anyway, look into the permissions for ASPNET on the machine with the database, and make sure you have the proper roles setup on the reporting server.

I hope this helps, as I am still relatively new to SSRS2005.

Anthony

Any books that explain how to setup Windows 2003 Server + SQL Server 2000?

My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.

So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.

Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.

Thanks in advance,
John1. install windows 2003.
2. install sql 2000. ignor warning.
3. install sql 2000 sp3.

your done.|||double post delete|||Thanks for the reply!

The service pack (3a is most recent I believe) gets a little confusing because there are three parts:

Sql2ksp3.exe. Updates for database components.
Sql2kasp3.exe. Updates for Analysis Services components.
Sql2kdesksp3.exe. Updates for Microsoft SQL Server 2000 Desktop Engine (MSDE 2000).

Do I need to install all three parts of the service pack?

Anything else I need to do?

Thanks,
John|||You just need to update the database components. I usually get rid of the sample data (northwind and pubs) when I do a new install but since you're testing you might as well play with those.