Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0
This is the forum to discuss the Wrox book ASP.NET 2.0 Website Programming: Problem - Design - Solution by Marco Bellinaso; ISBN: 9780764584640
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
 
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old April 19th, 2007, 06:07 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default 2nd Question...

I was deleting the entries in the WebEvents_Events table, but, it won't let me delete a number of them. The error I get says that "string or binary data would be truncated" therefor the operation was canceled. In looking at the file, all of the entries that can't be deleted are the same... Error code 3005, a System.Data.SqlClient.SqlException error. I'm guessing that the problem is due to the data in the "Details" field... it seems there is more data than can be displayed\handled appropriately?

Anyone have a solution for this one?

Thanx,
Wolven

  #2 (permalink)  
Old April 19th, 2007, 07:20 PM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

Hmm. I have never had this problem trying to DELETE data, only INSERTING it. If you are trying to clear all of the data from the table, you can use this command: TRUNCATE TABLE WebEvents_Events

WARNING TRUNCATE will delete ALL rows in your table and it also will reset the any auto increment fields back to the default values.

Not sure why you are getting this error, but it is worth a try.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========
  #3 (permalink)  
Old April 19th, 2007, 11:06 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanx for the suggestion. I was able to get rid of them by using Delete where EventCode = 3005. Still, there's something wrong with the MS SQL Server Management software when it "can't" delete "some" records.

Wolven


  #4 (permalink)  
Old April 21st, 2007, 10:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Were you originally trying to delete with SQL, or from the SSMS? I've found a number of issues with SSMS in general :-( Oddly, MS doesn't see to put much emphasis on fixing them, but they are quick to respond to issues in the back-end DBMS.

Eric

  #5 (permalink)  
Old April 21st, 2007, 03:25 PM
Registered User
 
Join Date: Apr 2007
Location: , , .
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was doing it from the SSMS. It worked for all of the records except the error code 3005 entries. I also ran the Delete SQL statement that finally got rid of them from within the SSMS. Actually, I ran the Delete and then "shrank" the DB to actually remove the records.

Yeah, like all MS products, the SSMS is a bit flaky.

 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What do you want to see for 2nd edition??? nzakas BOOK: Professional JavaScript for Web Developers ISBN: 978-0-7645-7908-0 10 November 26th, 2007 10:54 PM
New in 2nd edition bender81 BOOK Programming Interviews Exposed: Secrets to Landing Your Next Job 2nd Ed ISBN: 978-0-470-12167-2 0 June 9th, 2007 08:29 AM
2nd chapter session question infernon BOOK: Beginning PHP5, Apache, and MySQL Web Development ISBN: 978-0-7645-7966-0 1 March 14th, 2007 12:07 PM
Newbie question on the 2nd ed: Class inheritance elde BOOK: Professional C#, 2nd and 3rd Editions 0 December 9th, 2004 03:00 AM
Upgrade to 2nd Edition HuhOiC BOOK: Professional C#, 2nd and 3rd Editions 1 June 4th, 2003 01:46 PM



All times are GMT -4. The time now is 05:35 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.