Answer Questions

• polymorphicx Applying CASE in Stored Procedures

  I'm creating a stored procedures, and pass in few parameters, which is @keys, @fields, @types and @likes, whereby I will select from certain table based on the @types, where the @fields equal to @keys, I also wanted to implement the LIKE to the statement as well, but I found out some problem, so ends up my stored procedure looks like this: ALTER PROCEDURE searchBooks @keys varchar(50), @fields varchar(50) AS SELECT * FROM books WHERE (CASE @field WHEN 'Author' THEN Author WHEN 'Publisher' THEN Publisher WHEN 'Title' THEN Title WHEN 'ISBN' THEN ISBN END)= @keys This statement run well, but I would like to specify the table to select with parameter instead of specified it, but I found it won't works, not even let me s ...Show All

• James Walsh Strange Query Behaviour

  Hi, I am seeming strange results with a query. I have two tables, lets call them Table1 and Table2. Table1 has an ID field, Table2 does not have an ID field. To be sure I wasn't blind, the query 'SELECT ID FROM Table2' returns: Invalid column name 'ID'. OK. Now when I run the query 'SELECT * FROM Table1 WHERE ID IN (SELECT ID FROM Table2)' it returns all the records from Table1. What gives Is this a bug, or am I missing something Aazad, It is something like this.. Select 100 From Table1 Where 1=2 How many 100s you will get as output Zero Rite.. that means empty set So your query trying to get all the table1 value where ID in empty set. So none of the ID will mee ...Show All

• Kunk Cannot open offline cube

  Hi, I created an offline cube file (.cub) using SSAS 2005 sp1. I tried to open the cube file by following these steps: 1. Open excel 2003. On the toolbar, click on Data and select PivotTable and PivotChart report . 2. Select External data source as the data you want to analyze then click on next. 3. Click on the Get Data button on the next step. 4. Choose the OLAP Cubes tab on the pop-up window, select <New Data Source> and Click OK. 5. Type "Sales" as the name of the data source. 6.Choose Microsoft OLE DB Provider for Analysis Services 9.0 as the OLAP provider. Click on Connect button 7. Select the cube file option and browse for the location of the cube file. Click Finish. 8. On the fourth step ...Show All

• Kitty DTS to VB

  Can someone help me please. I am having issues with the following code. This is the first time I am doing this, so it is Brand new to me. Sorry if I look and sound like an idiot. I am having issues with 'DTS.OleDBProperties' cannot be indexed because it has no default property at the following line :oConnection.ConnectionProperties I used DTS wizard to create my vb code and I am following this page: http://msdn2.microsoft.com/en-us/library/aa176248(SQL.80).aspx Can someone please guide me in the right direction. Option Explicit Public goPackageOld As New DTS.Package Public goPackage As DTS.Package2 Private Sub Main() set goPackage = goPackageOld goPackage.Name = "Test" goPackage.Description = "Casier" ...Show All

• enric vives Cannot Connect to an MS SQL Server

  Hi, I've developed an application that connects to an MS SQL server to read and write from a database. I have tested the program on about 6 computers (all on different networks and internet connections, etc...) and they can all access the database remotely just fine. However, today I tried it on another PC (i.e. the 7th computer) and for some reason it won't connect. This computer is definitely on the internet as I can surf the web with it just fine, but every time I try to run the program it comes up and says that it cannot connect to the database. I can't remember the exact error message, but it was behaving as if the computer wasn't on the internet. What might cause a problem like this I did notice that this PC is running Norto ...Show All

• Gaurav Sehgal Don't Understand

  I am having a problem reinstall SQL Express 2005.  I had it installed, but then I unistalled it.  I have tried installing it again, but everytime I do it says that the product is already installed.  There is no instance of it in my Add/Remove Programs.  I have read the threads that relate to this topic, but they haven't helped.  I have looked at my logs of the installs, but they don't make sense neither.  I just want the program installed again, or a way to get it so that I can use it.  When I try to manually uninstall using msiexec.exe /x <processid> I get an error saying that the package could not be opened.  This happens with all the process ids I use that I get from the log files (I have ...Show All

• sigipa How to deal with the problem? "Errors in the OLAP storage engine: "

  Who can tell me how to result the problem Errors in the OLAP storage engine: The attribute key cannot be found: Table: FactSalesSummary, Column: ProductKey, Value: 212. Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute Product of Dimension: Product from Database: Teradata Adventure Works Test, Cube: Teradata Adventure Works, Measure Group: Fact Sales Summary, Partition: Fact Sales Summary, Record: 1. Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation. Errors in the OLAP storage engine: An error occurred while process ...Show All

• Konstantinos Polychronis Fatal Error

  Need help, I am trying to update my server connection ( Microsoft.AnalysisServices.Server.update ( ) )and got the following error message: Microsoft.AnalysisServices.OperationException: Fatal internal error. at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadRespon se(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfEr ror) at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate) at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions o ptions, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult) at Microsoft.AnalysisServices.Server.SendUpd ...Show All

• Varix Database Mirroring Transport is disabled in the endpoint configuration.

  Hi. I am getting this error. Msg 1486 , Level 14, State 2, Line 2 Database Mirroring Transport is disabled in the endpoint configuration. Someone please help me.It's urgent. I am using same PC with 2 different intsances. This is how i have done it: CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'test@#56' GO -- CREATE CERTIFICATE PRINCIPAL_CERT CREATE CERTIFICATE PRINCIPAL_CERT WITH SUBJECT = 'PRINCIPAL CERTIFICATE' , START_DATE = '03/07/2006' , EXPIRY_DATE = '01/01/2010' GO -- CREATE ENDPOINT NAMED (EPMIRRORING) USING CERTIFICATE AND ALGORITHM CREATE ENDPOINT EPMIRRORING STATE = STARTED AS TCP ( LISTENER_PORT = 6025 , LISTENER_IP = ALL) ...Show All

• briggins5 TRANSACTIONS in SSIS (error: The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION."

  I'm receiving the below error when trying to implement Execute SQL Task. "The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION." This error also happens on COMMIT as well and there is a preceding Execute SQL Task with BEGIN TRANSACTION tranname WITH MARK 'tran' I know I can change the transaction option property from "supported" to "required" however I want to mark the transaction. I was copying the way Import/Export Wizard does it however I'm unable to figure out why it works and why mine doesn't work. Anyone know of the reason If you are having three Execute SQL tasks like: BEGIN TRAN | | | V <Your SQL> | | | V END TRAN Then, you h ...Show All

• MrOctree Linked Server problem

  Hi, I have created a linked server with oracle database. Iam using SQL Server 200 and Oracle 8.0 client. I have made the registry settings as mentioned in KB280106. But when i I try to access the tables from the oracle database i get the following error: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' reported an error. Authentication failed. OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.]. Any ideas how this problem can be solved. http://support.microsoft.com/default.aspx scid=kb;en-us;280106 "This error message indicates that the linked server does not have correct login mapping. You can execute ...Show All

• Rush hour sp_xml_preparedocument failed to parse XML

    Hi All, I have a stored procedure that parses a XML string parameter and loads the data parsed from the XML string into a table. The stored procedure has been working fine until a foreign customer has entered unicode string into one of XML attributes.  I debugged the stored procedure and noticed that as soon as the sp_xml_prepare_document  is called, it returns the following error: "An invalid character was found in text context" "Could not find prepared statement with handle 0" The attribute entity_name = 'co ke co ke' is the attribute that contain the unicode character o which caused the parsing failed. The entire XML string that the sp_xml_preparedocument failed to parse is below: < Table ...Show All

• White_Horse DTS deployment issues

  Hello! I'm trying to deploy an application that runs DTS packages from the local machine. I've read some articles that it would be enough to install the SQL Client Tools on the local machine to make the DTS work . I did this, the package executes a few steps (it shows message boxes and writes data into the database), then (before executing some validation tasks on the data) it throws an exception 'Execution was canceled by user'. I've set the pbCancel flag and the package runs fine on some computers, but on an empty system that only contains my application and the Sql Client Tools I get this exception. Do I have to install anything else or do I have to make some changes to DTS package to make it work Thank you in advance! ...Show All

• imranmp Better way to filter dimension members?

  I have a dimension hierarchy that has several thousand members (it's a geographical one). We often times want to answer questions for a particular city or zip code in the hierarchy - has anyone found a better filtration mechanism in either BI studio's OLAP browser or Excel 2007 Basically, I'd love to just type "Seattle" or "Seattle, WA" and have it choose the Seattle geographical member (instead of navigating the full hierarchy to select it). Better design practice in case of having hierarchy containing many members is pretty simple, but is not often simple to implement. Unfortunately there arent that many alternatives. Anyhow. You need to try and create additional levels in your hierarchy so your use ...Show All

• FlashyPants Restore database on different domain - performance

  Hi, I'm trying to restore database on the server in the different domain. The destination server is located in the physically remoted place. First I tried UNC path (including IP address) with DBCC TRACEON | OFF (1807) optioin but it didn't work. Some Internet document suggested that the FTP file transfer & restore locally on the remote domain but I didn't use this method because there is additional step. Instead I used the following scripts: DECLARE @COMMANDLINE VARCHAR(500) SET @COMMANDLINE = 'NET USE B: \\192.168.1.xxx\sql_backup$ password /USER:SourceServer\read_sql_backup /YES' EXEC master..xp_cmdshell @COMMANDLINE RESTORE DATABASE [DestinationDB] FROM DISK = N'B:\SourceBackup.bak' WITH FILE = 1, NOUNLOAD ...Show All