Answer Questions

• Maksim Dangerous Bug in SSIS?

  Hi, I recently seemed to have found a major bug in SSIS packages... Well i was just showing the new SSIS to a few work collegues when i suddenly decided to show how cool it was to be able to minimize and maximize tasks containers. Well the bug just showed up when i maximized the container again and there it was... the Conditional precedences where gone... no more visible.. Everyone is experiencing the same problem Solutions Best Regards, Lu ...Show All

• JoergD Hide a line item in a matrix

  Is there any way in which a line can be hidden in a matrix according to a condition I have a matrix that displays various teams totals. There is a field in the dataset called "Display" which is either 1 or 0. The sales director wants a couple of the teams hidden from the display, but for their sales to affect the totals (don't ask!). I have got as far as editing the visibility according to the value in that field, but it is showi ...Show All

• JDArsenault Failed SQL 2005 SP1 installations (Hotifx.exe crashes)

  I am seeing repeated failures installing SP1 database services with crashes in hotfix.exe being reported and the following appearing in log files: Property(S): SqlUpgradeMessage = SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL ...Show All

• Cong Li Pre-execute error in simple import/export

  I am trying to copy data from a SQL Server 2000 DB to SQL Server 2005 DB using the import/export wizard in SQL Server Management Studio. The two databases are not identical with different table names and different columns but I thought I had set up all the right mappings and had set the 'Enable identity insert' option. When I ran the wizard it errored at the Pre-execute phase. I simplified the wizard down to one table and only as couple of varch ...Show All

• Brian Pullin Cannot generate SSI Context

  New install of SQL Server 2005 (x64) Standard after uninstalling previous version SQL Server (x86) Standard. After installation, client connections are receiving "Cannot generate SSI Context" error messages. TCP/IP Integrated Authentication is being used. Kerboros authentication is failing when SQLService is running under a domain account and works when running under local system account by reverting back to NTLM authentication. ...Show All

• Paulustrious Why does the index lock my updates in SQL Server 2005?

  When one process has one record locked in Update-Mode then an other process can't update any other records on that table with some queries, other queries that access the same records (but with a different WHERE statement) will execute. This problem occurs with SQL Server 2005, but it didn't with SQL Server 2000 (or any other database). The problem: -Process 1 locks a record in the table, and keeps it in Update-Mode, because the ...Show All

• Doug Griffin SET IDENTITY_INSERT

  We have created an "AdminUser" with the bare minimum rights for the activites it will need to do. One thing the "AdminUser" will need to do is a "SET IDENTITY_INSERT ON/OFF". I understand that for this user to be able to do this they will need ddl_admin rights. But that gives them all kinds of permission that I don't want this user to have. Is there a specific permission I can give the user so they can do th ...Show All

• GenxBear bcp_bind smalldatetime

  Question. How to "DB_IN" into SQL 2005 smalldatetime not null column in non-unicode exe When i describe the column like this (see below), bcp_sendrow fails. if (bcp_bind(lpDbc, (LPCBYTE) szTime, 0, SQL_VARLEN_DATA, (LPCBYTE) _T( "" ), sizeof (TCHAR), SQLCHARACTER, 4) == FAIL) {  report an error; } Thank you very much! PS szTime is TCHAR[20] and looks like "2006-03-14 12:25:37" and is "null-terminated". ...Show All

• Rafer Handeling Parent-Child hierarchy in RS2005

  hello, I have a problem in RS2005: In my report I see all levels in one column. However they are shown in a way that I think that if I only could get it to toggle correctly it will work out fine... I would like my P/C dimensionto display just as it does when I use AS. Expanding top level (by pressing +), viewing next level down where I can "open" (by pressing +) next level and so on. Does anyone know how this is done or suggestions ...Show All

• JamesChapman44 Return random rows

  Are there any way to execute a procedure and return N random rows Well I didn't know about newid() either, thank you Jens. newid() is a funcion that creates a unique value of type uniqueidentifier. I executed select top 10 * from ACCOUNTS order by newid() against ACCOUNTS table with 30000+ rows, the execution plan shows 0% cost for generation of newid-s. So I guess it serves perfectly for you-you don't need to create and maintain ...Show All

• micxba Help! - Error in moving data from AS400

  I have a process that simply copies data from a table on an AS400 to SQL Server. This process executes fine until it gets to around 44 million rows copied out of 48 million rows in the source table. At this point, the process exits with the following error messages: The attempt to send a row to SQL Server failed with error code 0x80004005. The ProcessInput method on component "SQL Server Destination" (40) failed with error code 0xC02020C7. Th ...Show All

• undead142 Multiple MeasureGroups and Fact tables for a cube

  Hi, I am creating dimensions and Cubes thru AMO. The data comes from a existing Oracle Olap datawarehouse. so there is no exact mapping between SSAS objects and the existing olap. When I need to update a cube, I might have new MeasureGroups which might be associated with new fact tables. Do I have to add a new partition when ever a new MeasureGroup is to be added to the cube What if the New MeasureGroup is associated with a new fact table ...Show All

• Mikey Stevey Using DSO for parallel partition processing

  I have written some code to process partitions in parallel, but I'm not seeing the performance improvements I was expecting.  Plus, perfmon indicates that only 1 partition is being processed at any given moment. Each thread is creating a separate connection to the cube.  The object below is created with the first "process" method as the entry point for the thread. using System; using System.Collections; using System.Threa ...Show All

• kolegiumkk Possibly similar issue with launching Report Builder from client PC's

  Hi, I got a working installation of reporting services 2005 up and running, Im able to create models and launch the Report Builder on the machine on which the server is installed, however if I try and run it from another machine on the network I get an error and Im able to view the following exception. Following errors were detected during this operation.  * [04 Jul 2005 10:39:34 +01:00] System.Deployment.Application.DeploymentDownload ...Show All

• Dariusz Jankowski SQL2005 [264] An attempt was made to send an email when no email session has been established.

  [264] An attempt was made to send an email when no email session has been established. The message is from a job which will send email to an operator when it is completed. In the operator notification setting, I'm sure the correct email address has been input for the 'Email Name' text box, such as abc@xyz.com SQL Server 2005 Std Ed, Windows 2000 SP4. However the Database Mail is configured and I can send/receive a test email. Thanks! ...Show All