Answer Questions

• Jase555 Is it a bug in SQL CE?

  Hi! I use SQL CE with VS.NET. I find the following bug 2th. The table has an " ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity. I add rows to the table, then I realized that the ID order not in the general order (from 0 to ........) For example: 6,7,8,0,1,2,3,4,5. O f course row 6,7 and 8 was added the very last. The content of each row is not mixed, only the ID order. Is it a very confused, be ...Show All

• TNROROC Long line of text error

  Hey, After working on a package for a while, I started to get the following error when re-opening the package: "Document contains one or more extremely long lines of text. These lines will cause the editor to respond slowly when you open the file. Do you still want to open the file " What is the problem and if there is fix or workaround Thanks. it's on this tread http://forums.microsoft.com/msd ...Show All

• dragon123 Upgrade issues from RS2000 to RS2005

  Is anyone aware of any upgrade issues moving from RS2000 to RS2005 My situation is that I am using RS2000 against a remote SQL Server (also 2000). The RS server is using SSL and also has Sharepoint installed and it all runs under Win2K3 server OS. Due to other issues, I am not wanting to upgrade the DB Server to 2005 at this time, just RS, to take advantage of the new features (such as the cube reporting enhancements). Should I be concerned abo ...Show All

• Keith Craig Broker:Corrupted message

  Hello, Has anyone seen this in profiler I have two brokers on different servers with one of them being the initiator. All messages end up sitting in the initiator's transmission queue. Profiler on the target broker's machine displays this for every attempt to send by the initiator: A corrupt message has been received. The End of Conversation and Error flags may not be set in the first sequenced message. This occorred in the message with Co ...Show All

• Steve001 Export problem

  Hello everyone. I would really appreciate if someone could give me an advice on the issue I'm having. I have the same multi-page report with subreports in it. It is already deployed to the report servers on two different systems and is displayed OK in HTML format through the Report Server  on both of them. When I try to export the report to PDF file, I get the following error: - On one system it gets fully exporte ...Show All

• TenShekels WITH NAMESPACES in SQL function is causing error

  Hi All, I'm getting the following compliation error when i try to execute the following function. I need your expert opinion on how i can solve this. ALTER FUNCTION [dbo] . [GetOrgChildHierarchyXML] ( @HierID int , @fiscalyear int ) RETURNS XML WITH RETURNS NULL ON NULL INPUT BEGIN RETURN ( WITH XMLNAMESPACES ( 'uri' as i ) SELECT OrganizationHierarchyId as "ID" , OrganizationHiera ...Show All

• Vladimir Sapronov Aggregate Function: AverageOfChildren

  I am using the Aggregate Funtion: AverageOfChildren for a Measure. I want to write a equivalent SQL query for the same. Any suggestions as to how can I ge the AverageOfChildren aggregation in a SQL query. Thanks.   How about using the SQL Avg() aggregate function ...Show All

• Senkwe Chanda is it possible to have variant condition clause in procedure?

  i want to use OLEDB to build a COM for my app in the case, i want to execute a select statement which the where-clause is variant. ex, select * from db1 where code='abc' select * from db1 where name='mike' As it's very difficult to change sql-command in oledb, i want to build a procedure like this, create procedure viewDB @filter CHAR(20) as select * from db1 where @filter go but failed! i tried EXEC( select ), ...Show All

• Rosomak_7 Comma in value within comma separated file

  I have a file which contains comma separated columns. One of columns contains names of companies. Sometimes the names of the companies have a comma as part of the name. For those, the value is surrounded by double-quotes. But it seems that SSIS ignores the double quotes and ONLY looks for the column separator. This causes my value to be split in half. Traditionally, I thought parsers that deal with this type of import do not automatically take t ...Show All

• Steve Maine -- MSFT AcquireConnection method call fails when scheduling a job with Excel Connection Manager?

  I have a SSIS package that reads the data from an Excel file using an Excel Connection Manager and imports the data to a table on a SQL Server 2005 DB instance. When I run this package locally on the server the package being on the file system, the package executes perfectly. Now I upload the package to the msdb database and the run the package from there and the package still executes successfully. Now I schedule the package to run as a ...Show All

• Laurent CP SQL 2005 Developer edition fails during installation

  When trying to install SQL 2005, I keep getting the foll. error: Error 1706. Setup cannot find the required files. Check your connection to the network or CD-Rom drive. For other potential soltions to this problem, see C:\Program ....\1033\setup.chm I have tried using two different DVDs, and also downloaded SQL 2005 from msdn, but none of them work. Can some please help. Thanks, Amir acharania@trimontrea.com   Af ...Show All

• Magknip How to restore SQL 2000 DB to SQL 2005

  Hi, All I am trying to restore SQL 2000 DB into SQL 2005 Database. I backup the database from SQL 2000. From Management Suit, I try to restore database but I can not see network drive from there even though SQL serveris running under network account. I could see network drive from SQL 2000 or at least I can type path to find backup file. However I can not do this.. My Q is: 1. How can I restore this SQL 2000 db to SQL 2005 using network path 2. ...Show All

• ssundan MDX script to scope on all but the leaf levels

  Hi, I am trying to specify a scope statement on all non-leaves members of all hierarchies of a dimension (time dimension basically) so I would need to say something like this: scope (MyMeasure, not leaves(TimeByDay));    this = (MyMeasure,timeByDay. currentHierarchy .currentmember.firstChild); end scope; Does anybody see a way of doing this without explicitly repeating a scope statement for each implemented hierarchy.level-above-l ...Show All

• p3aul DB Cluster and Mirroring

  Currently we have implemented SQL 2005 in a clustered environment. I have two questions: 1. Is it possible to mirror a clustered DB 2. If mirroring is implemented, is DB clustering still needed or makes sense Thanks. 1. Yes. Database Mirroring operates at a database level. Failover clustering at an instance level. Database Mirroring doesn't see any difference in a database on a standalone machine vs. ...Show All

• Boulderdude Data Mining - Scalar Mining Structure Column Data type error...

  Hoping someone will have a solution for this error Errors in the metadata manager. The data type of the '~CaseDetail ~MG-Fact Voic~6' measure must be the same as its source data type. This is because the aggregate function is not set to count or distinct count. Is the problem due to the data type of the column used in the mining structure is Long, and the underlying field in the cube has a type of BigInt,or am I barking up the wrong tree ...Show All