Answer Questions

• rowdyy Moving ntext to nvarchar(max)

  I just move our SQL server to version 2005. In new version ntext field is deprecated and documentation says that ntext(max) should be used. If I have table Table1 and ntext column Column1. When I execute following SQL statements: alter table Table1 alter column Column1 nvarchar(max) go 1.) Are out of row data automatically move to in row 2.) Or should I also execute something like this update Tab ...Show All

• bobwilmes Where can I find a How to on SQL Server Express?

  Lost as a goose.... Hi, http://www.google.de/search hl=de&q=%22getting+started%22+sql+server+express&meta = HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SeaFire SQL Express with the WDK DTM?

  With MSDE 2000 you are limited to 8 machines and it is recommended to use SQL Server if you are planning on have more than 8 machines in a machine pool.  Since SQL 2005 Express does not have the workload governor, would it be a valid substitution for the SQL Server 2005 for the purpose of logo testing I am following up on this to see if I can get you some more information.  Thanks< MJ Can ...Show All

• psychokiller Error handling in SSIS

  Hi! I guess this is an easy one, but I haven't found a (nice) way to handle "error"-rows. In my application I load a lot of data, in earlier version I used the Transformation task, which did deliver log and error-files. How do I make the same in SSIS In the best of worlds I would like to log when a package/task i starting, ending and how many rows are OK and how many rows are errors. For the errors I want a Description what is wr ...Show All

• wei kiat lam web query

  Actually, I use Excel web query to pull data from the web into MS Excel. For a better management of my data, I want to use MS SQL-Server 2005. My question: is there a possibility to query websites with the SQL Server Integration Services in this way Thank you for your answers! Jonas Does this answer your question: http://blogs.conchango.com/jamiethomson/archive/2006/05/31/4009.aspx -Jamie thank y ...Show All

• outcast1881 Problems adding MS access datasource in VB studios 2005 enterprise

  I am running Visual Studios 2005 enterprise edition and I am creating a mobile application to keep track of some receipts. The problem I'm currently having is that even though I can connect to the MS Access Database with Server Explorer that I'll be aquiring data from; Everytime I attempt to use the Data Configuration Wizard to add a new data source that namely the database I get this error message: The new connection uses a data provider tha ...Show All

• serpentine Is SSIS slower than DTS????!!!!!!

  I am new to SSIS and probably doing some mistake while transferring data from oracle source to oracle destination.   Please guide me..   In our project we need to transfer nearly 80 GB data from old system (Oracle 9i) to new system (Oracle 10 G Release 2). To do this exercise we are testing and comparing performance and cost effectiveness between different tools like SSIS, DTS and SQL * Loader (oracle built in tool).   ...Show All

• hiddenTiger How Do I Start New SQL Server 2005 Database?

  I just installed SQl Server 2005 on my Windows XP Pro system. But I can't figure out how to start the Database Engine. In the MS SQL Server Management Studio I see one Database Engine, but not SQL Servers. If I do "Update Local Server Registration" nothing happens. If I do right-click "New Server Registration" I get a databse icon with a white open circle. If I the try "right-click, Connect, Object Explorer" I get & ...Show All

• Waleedead Error when create a Server object using SMO

  Please help: I got this error and can't figure out what went wrong. The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. on the line that create Server object. This is the code  (Visual C# 2005 - SQL Server 2000 - Windows Active Directory) using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; ...Show All

• Peter Vanpoucke Converting 2000 Reporting Services Reports to 2005!

  Hi There, just wondering if anyone knows how to convert 2000 reports to 2005   any hints or resources would be greatly appreciated, having trouble finding it out  on the web Thanks! As far as my experiences, all RS 2000 reports will normally work on RS 2005 without any problem, you don't need to do too much unless you want to use the cool features of RS 2005. ...Show All

• Juliano Horta Is there a as400/db2 native provider to extract data?

  Is there a as400/db2 native provider to extract data Currently, it's part of the Host Integration Server product. We're working on making it available to SQL Server users, but this hasn't been finalized as yet. The AS/400 driver in even the latest version of Host Integration Services (2004) is buggy and should not be used. What you want is to get your hands on the IBM Client Access V5R3 CD. Run through the setup program on this di ...Show All

• oldguy1166 Creating new connection manager types

  Hi, Wanted to know how one can write new connection manager types, and, additionally, if there exist any code samples that show how this can be done. I searched through BOL but could not locate any. I basically work with C++ and was curiuos if code samples exist in it I have worked with a couple of ETL tools (or 'platforms' should I say) before, but never with SSIS.  Would really appreciate it if someone could help me out here. ...Show All

• Alains Using Package Configurations with SQL Table

  Using package configurations, How can I use the configuration Type Sql Server and migrate the configuration from one database and server to another ...Show All

• agustinas Image handling with SQL

  I am using SQL Express and I do not know how to add images to my database.  I've created a dataset and linked it to datalists so everything is perking along except I'm just clueless on the image handling.  I create a resx file thinking that work except I don't know how to coordinate it with the data.  In Access it is an easy thing to add an image OLE object to my database which gives me a load of options in reports so you would th ...Show All

• MIxsynth Increasing the row or page size

  Hi, Can anyone tell me the step by step procedure of increasing the page/row/primary data file size in MS SQL Server 2000 What exactly are you trying to achieve Increasing the size of a page is not possible in SQL Server, they are always 8KB. Increasing the size of a row is as simple as adding a column to the table definition. Rows cannot span multiple pages, so if that is what you are looking for yo ...Show All