Answer Questions

• Slowpoke Some guidlines for posting questions...

  Hi, When you post questions here, please strive to: a) Post the simplest possible repro. Please do some up-front debugging and detective work, and post the narrowest possible repro. It's not helpful if you post 5 pages of code. b) Post the DDL of your schema so that we know the data types, NULL-ability, and constraints. c) Please indicate exactly which version and SP of SQL Server you are using. d) Please indicate any additional info that may ...Show All

• Ryan Milligan Pkg Execution Works in VS but not in SQL

  I'm able to execute a package in VS Pro on my machine. However when I upload it to the sql server and try to execute the package directly it fails with: Error: The product level is insuficient for component "...." (3129) Error: The product level is insuficient for component "...." (5411) The first component is a DataReader Source which is consuming an ODBC (Noble Systems ATOMIX Driver) connection and the second componen ...Show All

• StPatrick Confused with a change in t-sql behavior

  I am really curious to know why a simple query like throws an error in SQL Server 2005 and not in SQL Server 2000 On SQL Server 2005 ---------------------- select RowNumber, RowNumber, TextData from dbo.[Tempdb Profile] Order By RowNumber error Msg 209, Level 16, State 1, Line 1 Ambiguous column name 'RowNumber'. You can have two columns with the same name, try to give them an alias and the query will execu ...Show All

• XtremeKP I am not able to load two different images dynamically in an Image control

  HI, Base on pagenumber, i need to display a particular image in first page and another image in next page. there are two images and has to be displayed alternatively in the pages. but, it is displaying only one image everytime. I am using Exteranl and URL based concept and using parameters to pass the values from the front end to the report One more thing I did was, I place two image controls and passing the URL through two parame ...Show All

• senthilkumarr connect to MSSQL2005 via ODBC

  Installed SQL2005, connect via (the new) SQL Nativ Client ODBC Vers. 2005.90.1399.00 works, just as (the old) SQL Server ODBC-Driver 2000.85.1117.00. Works fine. But from an other machine -there is no client installed - using driver 2000.85.1117.00 I get the message "Server dosn't exist or access denied" How I can connect It is due to the fact of .NET FRAMEWORK 2 Thanks! Sounds like the 'other' machine is your first network client - check ...Show All

• newX Installing RS2000

  We want to start working with Reporting Services on a Windows Server 2003 (SP1) server that has SQL2000 (SP3) Standard Edition. I thought I could load RS from the CD but it does not appear to be on there. I seem to remember that Microsoft added RS to SQL2000 in the last year or so. Can I download a copy of it, or how do I go about getting a copy and how to I show my boss that it is a legit copy Thanks... Hi, I clicked on the link ...Show All

• opc3 MergeSynchronizationAgent Status event

  Hi, I am attempting to use the MergeSynchronizationAgent Status event to display the current status of the synchronization in a dialog. It seems that the StatusEventArg properties returned to the StatusEventHandler from the MergeSynchronizationAgent don't match the acutal progress - for intance, the PercentComplete always stays at 0 and the MessageStatus never is "Succeed" for a successful web sync, so it is impossible to tell if the synchroniza ...Show All

• Claus P Updating Table Structures

  Colleagues: When I try to save changes made to tables in SQL Server 2005, I get a time out error about 30 seconds after I initiate the save to the changes made to the table. I then have to back out of the "modify table" operation and I lose my changes.  I never had this problem with SQL Server 2000, even in tables with millions of rows - it would take a while, but I wouldn't get the time out messagand the updates would be saved.  ...Show All

• Richard Grant SQLXML 4.0

  I just installed SQL2005 and VS2005. It appears that a new version of SQLXML is available, SQLXML 4.0. Does anyone know if this version is compatabile with SQL2000 I am going to use the SQLBulkLoad library. I could not find a download of SQLXML 4.0. Does anyone know how to redestribute this version of SQLXML Thanks Hi Kevin, SQLXML 4.0 can be redistributed from the SQL 2005 CD (it says so in the EULA) and it has gone through t ...Show All

• originsnone This SMO transfer script doesnt transfer ?

  Hello, this takes a lot of time  but when I got to sql server management studio there are no objects there!! What am I missing private void button1_Click( object sender, EventArgs e) { Server sv = new Server ( "ESTACION15" ); Database db = sv.Databases[ "GescomDllo" ] ; Database db2 = new Database (sv, "PRUEBA" ); // db2.Create(); Transfer xfr; xfr = new Transfer (db); xfr.CopyAllObjects= true ; xfr.C ...Show All

• RLauzon Microsoft.Jet.OLEDB.4.0 has not been registered. ??

  Hi folks, We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc).  Last week, one of developer sent me an email with error msg, : Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed.  I also found from MS site that Jet 4.0 SP8 i64 version available but the instal ...Show All

• cuco ReportViewer control

  trying to build a test page with a single ReportViewer control < rsweb : ReportViewer ID ="ReportViewer1" ProcessingMode ="remote" runat ="server"> < ServerReport DisplayName ="VSTestReport" ReportPath ="MyReports/VSTestReport" ReportServerUrl ="http: //pugrs/reportserver"/> </ rsweb : ReportViewer >   build fails with 401: Unauthorized. Not even sure where to begin troubleshooting this one. ...Show All

• LesGeddon "(rsInternalError) Index was outside the bounds of the array" after upgrade to SRS SP2

  After upgrading to SQL Reporting Services SP2, we now get an error every time we try to run any of our reports. The error is "An unexpected error occurred in Report Processing. (rsInternalError) Index was outside the bounds of the array." Anyone have any suggestions I looked in the Report Server logs and see this error but there is no other information that points me to the problem. Thanks in advance. Can yo ...Show All

• benjycleyndert split partition log files costs too much space.

  I upgrade my sqlserver to sql2005. I try to use partition, when I split one partition into two, I found the split operation cost too much space, even I use the simple/bulk recovery model. since Idon't have much space, I think maybe the log files can be controled. how to control the log file thanks. I suppose that partiotion split is an atomic opertion that runs within one transaction, and this transaction appears in the ...Show All

• heguangm Report task?

  Hello, I'm not sure if this one should be in this forum. Anyway... I need to build some reports in MS Word format. Is there are any way to do that It can probably can be done in Reporting Services, but how I can merge these two tools in one project (solution) for example Thanks. Ok... Thanks. Last question. How I can include report part in SSIS package itself So the report can be executed on package flow. ...Show All