<2017 July>
SunMonTueWedThuFriSat
2526272829301
2345678
9101112131415
16171819202122
23242526272829
303112345

On this page...

SSIS Error of the Day - "Expected the TEXT token in data stream for bulk copy of text or image data."
Useless Error Messages - SQL Server 2008 Setup
Moving the SQL Server ERRORLOG
Microsoft Synchronization Services for ADO.NET CTP
Whitepaper: Working with tempdb in SQL Server 2005
Partitioned Tables and Indexes in SQL Server 2005
Instant File Initialization For SQL Server EE / Developer
SQL Server Developer Edition - Finally A Good Use-Case
The Yearly MSDN Magazine Security Issue Has Landed
Ready to Rock the Launch
Data-mining with SQL Injection and Inference
SQLUGA: SQL Server 2005 - Database Mirroring
Community-driven Security Conference in Vienna, Austria
SQL Server 2005 April CTP
SQLRecon 1.0
December SQL Server 2005 Webcasts
SQL Server 2000 Full-Text Search Deployment White Paper
SSUGA Summer Academy: Microsoft SQL Server 2005 Hands-On Lab
An Overview of SQL Server 2005 for the Database Developer
Introducing SQL Server 2005
Search

Links

Member of...


ASP Insiders

MVP Visual Developer ASP/ASP.NET

Enter CodeZone

Blog Categories

Microsoft

Blogroll

Deutsche Resourcen

Management

Sign In
 

#  Friday, 13 March 2009

Importing table data is an easy enough task in SQL Server 2005 - but this week we stumbled across this error message:

Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Expected the TEXT token in data stream for bulk copy of text or image data.".
 (SQL Server Import and Export Wizard)

Funny thing is, there were only nvarchar(max) columns on the table, and no binary columns whatsoever. A bit of searching and more staring at the table definition finally pointed out us in the right direction - the target table has a computed field in it, like so:

[MyComputedColumn] AS
 (
  [dbo].[MyFunction](OtherColumnAsParameter)
 ),

Although we had told SSIS to <ignore> it, this error came up. The only work around for SSIS: remove the computed field before doing the import.

References:

http://www.eggheadcafe.com/conversation.aspx?messageid=30015415&threadid=30015404
http://sqlug.be/forums/thread/821.aspx

Categories: SQL Server
Friday, 13 March 2009 11:47:18 (W. Europe Standard Time, UTC+01:00)  #    Comments [1]

 



#  Saturday, 23 August 2008

Today I wanted to install SQL Server 2008 Developer Edition. Easy enough, at least so I thought. Started setup for a new instance, chose a different directory from where SQL 2005 lives (my c: drive is nearly full), selected a few components, clicked Next>:

I have no idea what SQL Server tries to tell me. This is sick.

Categories: SQL Server
Saturday, 23 August 2008 11:07:40 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Monday, 02 April 2007

Tonight, SQL Server decided to write a 14GB error log to disk - filling it up neatly, which of course had a couple of "side effects". Drat! All log file directories (HTTPERR, IIS, MailEnable, you name it) - everything except the SQL error log is on a separate partition for exactly one purpose: that no application log can stop the server dead in its tracks.

After clearing up the mess I thought "let's move the logs for SQL Server". Thanks to Alex I finally figured out where to do that - in the Configuration Manager:

Go to the Properties dialog, and modify the Startup Parameters (-eC):

Details can be found in the article Moving System Databases, section Moving the master and Resource Databases. Someone from Microsoft care to enlighten me as to why this log directoy has been hidden so far away from sight?

Categories: Administration | SQL Server
Monday, 02 April 2007 13:57:03 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Thursday, 15 February 2007

At long last at least a CTP is available. Definitely worthwhile to check out.

Categories: .NET | SQL Server
Thursday, 15 February 2007 10:46:14 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 



#  Monday, 13 November 2006

The final SQL Server-related post for today: Working with tempdb in SQL Server 2005.

Categories: SQL Server
Monday, 13 November 2006 18:37:37 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 

Another noteable tidbit from the "Achieving High Availability with SQL Server 2005" preconference session: the whitepaper Partitioned Tables and Indexes in SQL Server 2005.

Monday, 13 November 2006 16:44:36 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 

Currently listening to the half-day preconference session "Achieving High Availability with SQL Server 2005" by Kimberly Tripp. Interesting tidbit for decreasing downtime for operational tasks (like create database or restore): Instant File Initialization. The figures really point to huge time savings! Quite a selling point for Enterprise Edition of SQL Server.

Monday, 13 November 2006 16:22:15 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 

Namely Visual Studio Team Edition for Database Professionals. This needs either SQL Server Enterprise or Developer Edition. Of course I had Standard and Express on my machine only...

Categories: SQL Server | Team System | Visual Studio
Monday, 13 November 2006 13:51:59 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 



#  Wednesday, 01 November 2006

The November 2006 issue has lots of good security articles, which are available online too. Check out Security Habits, Threat Modeling (STRIDE approach), Extending SDL or SQL Security to name a few.

Categories: .NET | Security | SQL Server
Wednesday, 01 November 2006 13:56:55 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 



#  Monday, 06 February 2006

Will be there Wednesday & Thursday as ATE (Ask the Experts), so drop by in the experts zone and say hello!

Monday, 06 February 2006 14:56:39 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 



#  Wednesday, 05 October 2005

David Litchfield published the paper Data-mining with SQL Injection and Inference (more NISR papers). From the abstract: When drilling for data via SQL injection there are three classes of attack – inband, out-of-band and the relatively unknown inference attack. Inband attacks extract data over the same channel between the client and the web server, for example, results are embedded in a web page via a union select. Out-of-band attacks employ a different communications channel to drill for data by using database mail or HTTP functions for example. Inference attacks stand alone in the fact that no actual data is transferred – rather, a difference in the way an application behaves can allow an attacker to infer the value of the data.

Categories: Security | SQL Server
Wednesday, 05 October 2005 23:36:51 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Tuesday, 06 September 2005

Yesterday, I attended Kevin Cox' talk about database mirroring in SQL Server 2005. The event was organized by the SQL Server User Group Austria in Vienna, with Peter Koen (old UG lead) inviting Kevin, and Jaser Elmorsy (new UG lead) organizing it. Session description for the records: Database mirroring is a new SQL 2005 feature for high availability. What happens if you combine mirroring with other features, like snapshot and clustering? This presentation will teach you the basics of database mirroring, then will discuss some advanced topics for common solutions.

Kevin also pointed us to the SQLCAT blog - CAT being shorthand for Microsoft SQL Server Development Customer Advisory Team. The description as well as Kevin promised that they will be posting demanding scenarios and solutions to those in that very blog.

Categories: Community | SQL Server
Tuesday, 06 September 2005 07:33:57 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Tuesday, 02 August 2005

On 12th of August, the Austrian .NET community is hosting a one-day conference on security, targeted at developers (no surprise here). The topics for NCC 2005 A include:

  • Threat Modeling
  • What's new in .NET 2.0 Security
  • What's new in SQL Server 2005 Security
  • What's new in Windows Vista Security

Quite a nice line-up I'd say. This event is supported by Microsoft Austria, so attending this event is free, except for your time, but I am sure security does warrant a day of your time! Sign up here

Tuesday, 02 August 2005 15:27:45 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Monday, 18 April 2005

Two more important downloads in addition to all the other B2 craze:

The # of VPC images starts skyrocketing (now that's a stupid word combination) on my dev machine...

Categories: 2 Ohhhh | Cool Download | SQL Server
Monday, 18 April 2005 21:07:02 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Tuesday, 12 April 2005

Just seen on NTBugtraq, quote from the Web site: SQLRecon performs both active and passive scans of your network in order to identify all of the SQL Server/MSDE installations in your enterprise. Due to the proliferation of personal firewalls, inconsistent network library configurations, and multiple-instance support, SQL Server installations are becoming increasingly difficult to discover, assess, and maintain.

SQLRecon is designed to remedy this problem by combining all known means of SQL Server/MSDE discovery into a single tool which can be used to ferret-out servers you never knew existed on your network so you can properly secure them.

Didn't yet have time to try SQLRecon myself, but sure will.

Categories: Cool Download | Security | SQL Server
Tuesday, 12 April 2005 17:08:54 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Thursday, 04 November 2004

The schedule for SQL Server 2005 Web casts is quite packed in December:

  • Webcast 12/6: Overview of the new Developer features in SQL Server 2005—Level 200
  • Webcast 12/6: Introducing the New SQL Server Management Studio—Level 100
  • Webcast 12/6: SQL Server 2005 as a .NET Runtime Host—Level 100
  • Webcast 12/7: T-SQL Enhancements in SQL Server 2005—Level 200
  • Webcast 12/7: Introducing XML in SQL Server 2005—Level 200
  • Webcast 12/7: Introducing ADO.NET 2.0 for SQL Server 2005—Level 200
  • Webcast 12/8:The New Security Model in SQL Server 2005—Level 200
  • Webcast 12/8: Introducing Web Services in SQL Server 2005—Level 200
  • Webcast 12/8: Introducing Service Broker in SQL Server 2005—Level 200
  • Webcast 12/9: Introducing Reporting Services for SQL Server 2005—Level 200
  • Webcast 12/9: Introducing SQL Server Integration Services for SQL Server 2005—Level 200
  • Webcast 12/9: Introducing SQL Server 2005 Analysis Services for Developers—Level 200
  • Webcast 12/10: Introducing Full-Text Search in SQL Server 2005—Level 200
  • Webcast 12/10: Introducing Replication in SQL Server 2005—Level 200
  • Webcast 12/10: Introducing Notification Services in SQL Server 2005—Level 200
Categories: SQL Server
Thursday, 04 November 2004 17:25:13 (W. Europe Standard Time, UTC+01:00)  #    Comments [0]

 



#  Sunday, 03 October 2004

With all the hoopla about VS.NET 2005 and SQL Server 2005, people sometimes forget that we still have to solve problems using today's technologies. The SQL Server 2000 Full-Text Search Deployment White Paper is a document that helps you better understand a technology that is already out there, focusing on the following areas:

  • The hardware and operating system requirements for efficient full-text
    search performance.
  • Full-text search architecture.
  • Full-text search administration.
  • How to monitor full-text search performance.
Categories: SQL Server
Sunday, 03 October 2004 18:22:28 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Friday, 10 September 2004

On Thursday, Peter did his SQL Server 2005 HOL for members of the SQL Server User Group Austria:

His workshop encompassed a tour of the new Studio management tool and for example TSQL enhancements (CTE's shown on the following photo):

Aside from just watching, I did the workshop part for SQLCLR features - writing functions, stored procedures, UDTs (user-defined datatypes), aggregates and triggers in .NET code. One cool sample is a function for email verification - try to do this in TSQL!

Friday, 10 September 2004 17:23:34 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Tuesday, 03 August 2004

This overview article at the SQL Server Developer Center provides a nice & quick rundown of new features for database development in Microsoft SQL Server 2005.

Categories: Newsbites | SQL Server
Tuesday, 03 August 2004 11:42:35 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



#  Tuesday, 27 July 2004

Microsoft has a new site dedicated to SQL Server 2005 (including the Express edition). Note though that only the Express Beta 2 can be downloaded freely.

Categories: SQL Server
Tuesday, 27 July 2004 13:22:02 (W. Europe Daylight Time, UTC+02:00)  #    Comments [0]

 



© Copyright 2017 Christoph Wille

newtelligence dasBlog 2.3.9074.18820
Subscribe to this weblog's RSS feed with SharpReader, Radio Userland, NewsGator or any other aggregator listening on port 5335 by clicking this button.   RSS 2.0|Atom 1.0  Send mail to the author(s)

 
Don't contact us via this (fleischfalle@alphasierrapapa.com) email address.