Answer Questions

• ParanoidX2 Reporting Services 2000 broke by installing .NET 2.0 redistributable runtime files

  We have RS 2000 running in our lab environment where I recently installed the .NET Framework 2.0 Redistributable Package.  After installation, reporting services stopped working with the following error: Security Exception Description: The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the appli ...Show All

• Shalinko Incorrect parent child aggregate values in SSAS browser

  I've created an "Account" dimension using parent child relationships and added a unary operator to the dimension e.g. "+" and "-" to aggregate things like gross margin = sales - cost of sales. The dimension hierarchy shows correct operators and levels (it is a ragged dimension) in the dimension browser, however when I go to the cube browser and place the hirearchy in the rows some of the members which have child ...Show All

• Ronen Tidhar 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 Thanks Mark. It would be good to know if the projected database size that the DTM will use fits the li ...Show All

• Per Dunberg Task to create and drop tables

  I have a package that i want to move between enviroments. Therefor i need to create a package that creates all my tables on the new server. like -- "if exists (select * from dbo.sysobjects where id = object_id(N'[table]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [table] GO" The case is that i have around 30 tables, and my question is therefore I know that you can create the drop and create script for one table ...Show All

• M. Zafar Iqbal Senseless results

  Try to run the following bunch of querries in text and grid output, then see if you can figure out why is it giving wierd results let me know plz. select name, password, ASCII(password) from master..syslogins where ASCII(password) =1 select name, ASCII(password), password from master..syslogins where ASCII(password) =1 select password, dbname, language  as b from master..syslogins where ASCII(password) =1 select password, name, language ...Show All

• Daya123 How do i Create DataBase in SQL Server Express Edition

  I have installed SQL Server Express Edition - ( Down Loaded ) There I found only three entries such as SQL Server Configuration Manager SQL Server Error and Usage Reporting SQL Server Surface Area Configuration Express Managment tool also i down loaded and installed seperatly.. Exp.Management on start asking  ServerInstance Name and Authentication I tried with (Local) and Windows Authentication - I triend with alternative ways suc ...Show All

• Shrilata How to stop a package

  Hi, In one of my packages, I have a script component to do a transformation and I am inserting the output to table. Within that script component, if the data does not match my requirement, I have to stop the job. For that, I am using 'componentmetadata.fireError' to raise an error. The problem is, now even when an error is raised, the job completes by loading the remaining records and then aborts. But I want to abort the job as soon it raises ...Show All

• Erich Franz Common Table Expressions!

  Hi all I've checked the CTE's in SQL server 2005 beta 2 it is really a very useful feature but I want to use it with the output of a stored procedure. Is this available Thanks in advance Hi, Can you please be more specific about what you want I understood you to say that you wanted to use the result set of a stored procedure as the operand to a relational JOIN operator inside a CTE.   AFAIK, that is not allowed.   AFA ...Show All

• fedrok SSIS ! HELP!

  Hi all! Am having some trouble with SSIS... I can't log in! I have just completed a default install, and the following prompt comes up... i have uninstalled and reinstalled it a couple of times now... Any ideas Thanks! TITLE: Connect to Server ------------------------------ Cannot connect to MORAY. ------------------------------ ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer ...Show All

• e-milio How to Reuse functions in script tasks ?

  Hello I have some common functions that i use in several script tasks. How du i store a function globaly so that i can use it from different projects and still only have to edit it one place I think one way is to create a dll of the function and import in each of your script tasks. To Import the dll into each of the script you need to place the dll into <root>\Windows\Microsoft .Net\Framework\<Lat ...Show All

• MovieFan Can I use SQL Server Management Studio Express to work with SQL Server Everywhere?

  Can I use SQL Server Management Studio Express to work with this...SQL Server Everywhere I bought VS2005 Pro and installed everything, including the Developers edition of SQL Server 2005. I would love to play with this and try converting old Access desktop applications. Unfortunately I am unsure how to create and modify a new database for SQL Server Everywhere using SSMSE. I have several tables that have a thousand records o ...Show All

• Igor Deck Guids as primary keys

  Is it a good idea to use Guids as primary key. What is the impact on performance. Guids are random by nature that may have an impact on writing clustered index. Any comments or suggestions I was looking on Microsoft and found this: http://msdn2.microsoft.com/en-us/library/ms190215.aspx The last part of it answers your question. "Consider using the IDENTITY property when global uniqueness is not necessary ...Show All

• DexterDurai For security reasons DTD is prohibited in this XML document

  I have seen one other post about this and using IP addressing rather that DNS names - I am using DNS. I have a large report that runs fine in report manager, but as soon as I try and export it to Excel it takes an age to run and I get the above error. Any ideas anyone Oh, and I export loads of other reports to Excel with no problems on the same server. I have sent a reporting services error log t ...Show All

• 808 Can SQL Express handle database size up to 9 GB?

  Hi everyone, Kindly tell me the size of database that SQL Express can handle. Tks for your cooperation. Brgds, Adien If you do wish to break it up into different databases you are going to have to look at your application design and how it connects to the database. You will not be able to have it configured as the one database over multiple files like you do in the full system, they will ha ...Show All

• Jobr77 Problem with SSIS Transaction...Transaction Scope

  Hi, I am having some problem with SSIS transaction. Eventhought I tried to imitate the concept that Jamie presented at http://www.sqlservercentral.com/columnists/jthomson/transactionsinsqlserver2005integrationservices.asp . My workflow is as followed ********************************* For Each ADO.Record in Oracle (transaction=not supported) If (Certain_Field_Value = 'A') Lookup Data in SQL DB with values from Ora ...Show All