Answer Questions

• Samuel D. Colak SQL 2000 Enterprise to SQL2005 Standard

  Can you downgrade a SQL 2000 Enterprise - active/passive cluster to a SQL 2005 Standard active/passive cluster No. It is blocked to downgrade a SQL Server 2000 Enterprise to a SQL Server 2005 Standard. S ee the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online. But you can install a SQL Server 2000 Enterprise and a SQ ...Show All

• Andreas Ohlund How to call a dot net assembly from ssis

  How to call a dot net assembly from ssis. I have used a script component and went in the design script editor by clicking the "Design Script" button.From their using a object browser trying to load a dll file in references to be used in the ssis application. But it gives error " Cannot browse the file"   Can any body help me in the same. http://blogs.conchango.com/jamiethomson/archive/2005/11/02/2341.aspx -Jamie &n ...Show All

• mcl7cdm Indexed View - has no influence on performance

  hi, I am using SQL Servre 2000. i have made tests trying to improve performance by using Indexed View. i have a table T1, that has a datetime field F1. i have another table T2, that holds links between records in T1. T2 has 4 fields : Recid  - identity column recid1 int - identifies a row in T1 recid2 int - identifies another row in T1 LT int - link type i want to build a query that retrieves all the rows from T1 that has a cer ...Show All

• oaktree444 Error: Attribute key cannot be found

  Helo, I have the following problem I have one fact-table in my cube And I have one dimension table When I process the cube I get the following error: "Errors in the OLAP storage engine: The attribute key cannot be found: Table: dbo_fbi_analytic_journals, Column: journals_key, Value: 306." I understand the error, and I know why I get the error, but how can I solve the error In the fact-table there is a record with key 306, but this key is not fo ...Show All

• ashish_2060 OleDB Connection Class in Custom Task?

  I have OLE DB Connections set up in my connection manager (Native OLE DB\Microsoft OLE DB Provider for SQL Server). I would like to reference and query these connections from a custom task, written in C#. I currently reference it as follows: using System.Data.OleDb; ................................... OleDbConnection connection = ( OleDbConnection) connections["MyConnection"].AcquireConnection( null ) ; What may be ...Show All

• The_Drewster (SSAS 2K5) MDX and Translations : how does it work ?

  Hi, When you run a MDX query against an SSAS 2K5 cube that has been created with translations, which of the languages can be used for dimension names, measures, attributes etc... Is it possible to use a language which is not the default language and how thx&rgds, Francois Translations do NOT affect the names of objects (dimensions, measures, etc.), just their captions. MDX queries use object names so th ...Show All

• Lex1957 Get list of all Databases in an SQL server

  Hey all, I have a pretty simple question, how do i get a list of all databases on a given SQL server I just want a list of them, how is this done I know that you can use SMO, but I am acutally trying to do this without using SMO. Can it be done Thanks to anyone who helps the code I have used to get what I wanted was as follows: SqlConnection sqlConn = new SqlConnection("Server=theServer; Database=dbName ...Show All

• am2112rush Restoring to a network paths?

  I'm getting the error "The file \\xxx ... is on a network path that is not supported for database files. File xx cannot be restored to \\xx ..... Use WITH MOVE to identify a valid location for the file. Below is my code for the restore. I've even shared the folder on the network but still no success. Try Dim restoreToServer As New Server("xxxx") Dim rest As New Restore rest.Devices.AddDevice(" \\xx\x$\Pro ...Show All

• Nisith Paul Can't Route to another LOCAL Broker Instance

  I have two databases (A and B )on the same SQL Server instance. Both have SSB enabled and running fine within themselves. All athorizations are at present set to dbo. Recently I had a requirement to start a dialog and send a message from within data base A to a queue via a service that is in database B. I tried coding the SSB instance in the BEGIN DIALOG then I set up a route and tried that. On both occoasions I got the following on sys.tr ...Show All

• Srinivas Lingineni Deployment worked when it shouldn't have done

  I've just had a situation where, when trying to process a cube, it failed because one of my Script Commands referenced a non-existent dimension. Now I have no problem with that - its easily fixed. My problem is that the cube is obviously faulty so why was I allowed to deploy it The deployment should surely have failed shouldn't it Is this a deployment bug Here is the script command: Scope ( Leaves ([Currency]), EXCEPT ( [C ...Show All

• jian Fit dataset on one page

  Hey guys, Let's assume I have dataset with two columns (A,B) and it has 100 records. I'd like to split this dataset on the same page with 25 records in every column. Side by side. Example: ColA ColB ColA ColB ColA ColB ColA ColB 25 rec 25 rec 25 rec 25 rec What should I use and what properties I have to play with Thanks. Hey, I was still not able to control how many re ...Show All

• Durgaprasad_y updating telephone column

  Hi all I have a column the customer table which holds the telephone numbers, 0293 232 232 2 2323 23232333 0222229999 00 the problem is that they all appear with spaces in different places, i need to remove all the spaces, remove the leading 0 if ther eis one and put +44 on the front. Any suggestions Regards Rich Hi, DECLARE @TelephoneNumber VARCHAR(200) SET @TelephoneNumber = '2323 232323 ...Show All

• RobertMC SQL Server Connection Irritations

  We recently migrated from .NET framework 1.x to 2.0 with a code base that is 4 years old. The application is a mix between Windows Services, Web Application, and some internal WinForms tools. We never had a problem using framework 1.x and even the same code that fails in framework 2.0, pasted into a 1.x project succeeds every time. This is a C# 2005 project. All our servers are Windows Server 2003 and all our SQL Server databases are SQL Serv ...Show All

• Bhupathi Venkatesh SQL Server 2005 JDBC v1.1 now available

  The first community preview release of the SQL Server 2005 JDBC v1.1 driver is now available. This build includes a number of bug fixes from customer feedback of the v1.0 driver, as well as new feature work, especially Type-2 integrated authentication. To get the v1.1 CTP1 please email me directly at shelbyg<at>microsoft<dot>com. -shelby Shelby Goerlitz Program Manager Microsoft SQL Server Data Programmability ...Show All

• AidyC Filter a Model Table?

  I am using  RS 2005. I am setting up a Model for use within Report Builder so our clients can write their own reports. A 2 part question, simple question first: 1. How can I filter the records in a Model Entity I thought this would be possible from a Perspective but it is not. 2. How can I filter the records in a Model Entity based on the locale of the person who is logged on And also based on their permissions TIA Hi, can some ...Show All