Answer Questions

• Alex Bell Querying Oracle v8.1.7 with multivalue parameters

  I am currently working towards an Oracle server through Microsoft SQL Server Reporting Services (2005) and I am troubling with an "ORA-12704: character set mismatch" error when I generate my reports. What I'm trying to do is to run a query using multi value parameters from Reporting Services to the Oracle server. This have worked fine until recently towards an Oracle version 9 database, but now I'm trying to make it work ...Show All

• dabagaalle Execute Mutiple Tasks In Debug Mode

  Maybe I'm missing something, but I can't find how to run multiple tasks in sequence while in Visual Studio debug mode. In DTS design mode I grew accustomed to right-clicking tasks one-at-a time, but in SSIS I find the additional step of having to exit Debugging mode after every task gets old after a while. There must be a way to start execution at a certain task and have the package continue all the way to some other specified task. It wo ...Show All

• trainer2k Snapshot Meta Data Problems

  Hi There I realize these question are not specifically for replication by anyway .... I am using snapshot replication from Server 1 to Server 2. I cannot use the drop table option for replication publication. The distribution agent keeps on failing if a colmn order is different or an index defined differently. Is there any script or sp i can run to check that table defintion, column order, idexes etc are identical between servers Also when the ...Show All

• smoky6880 Capturing Processing Status and Progress Messages

  When you use BI Dev Studio or SS Management Studio to process an Analysis Services database or object, there's a nice dialog box that shows very robust status and progress information. Is there any way to capture this information if you are processing something programmatically   Specifically interested in both the ability to capture and display this information to a user when processing via a custom application.  Also interested in wh ...Show All

• Craig Roffers MS SQL Server 2005 EE & MS SQL Server 2005 Express Manager

  I recently installed SQL Server 2005 Express Edition CTP (It appears to be working fine). I then found the SQL Server 2005 Express Manager, and tried to load it, but I keep getting the error: This computer must have at least Windows 2000 SP4 and the user must have administrator privileges in order to continue. Also, you must first install the SMO Components and the .NET Framework version 2.0. Well, the machine is Windows XP Pro SP2 (fully patche ...Show All

• Lacko Javascript in RS 2000

  Hello, I'm tyring to do 2 things: 1. Have a hyperlinked field open up into a new browser. I'm currently using the "Jump to URL" property to map to one of my fields (=Fields!BoardURL.Value). I'm not sure where to put the =windows.open(Fields!BoardURL.Value, 'blank') code to get it open up into a new window. Does this go in the "Jump to URL" text box 2. I have some additional javascript code for that same URL that checks wh ...Show All

• Zakspeed63 Installing Sql Server 2005 Trial Software From Microsoft Website - Self Extracting Executable

  Hello,   I'm trying to install sql server 2005 Trial software from the self-installing executable (X86 Executable) as I wait for my copy of the full version of SQL Server 2005. Steps: Click the X86 Executable link When prompted, click Run SqlEval.exe. After that is finished I (Excuse me if I don't have to exact terminology down) I clicked O.K. and the software evaluated the .exe and then prompted me to click the finish button.  As soon ...Show All

• suraj victor sysconstraints and syssegments views do not show under system views

  NO idea how this happened, I was getting an error altering the views, and I noticed in one database of mine sysconstraints and syssegments views shows under user created views , in other databases I noticed they are listed under system views section. How can I move sysconstraints and syssegments back to system views Thanks Hi - I presume you're running against a SQL 2000 back-end Also - can you explai ...Show All

• Johan Strand Lesson 1 - Problems with data formats

  Hello, I'm going through the tutorial lessons and found a major issue in Lesson 1. As I tried to transform the data from the flat file in debugging mode, the sample didn't work correctly. No related data to the dates and times from the flat file could be found in the dimension table dimTime. I discovered that this was due to the different time format that was set in control panel (german time format). After&nb ...Show All

• fenneran XSD: Reading string in ROOT of XML

  Hi all, I am making a import from XML to SQL. I have chosen to do this via a XSD file, but I have a problem with the ROOT file of the XML XML: <Dogs bulkmode="0" xmlns=" http://scheme01.isp.com ">   <UnderDogs>     ...   </UnderDogs> </Dogs> XSD: <xsd:element name="Dogs bulkmode="0" xmlns=" http://scheme01.isp.com "" sql:is-constant="1"> Unfortunately this does not work. If I (for testing) ...Show All

• whoareyou Using OLE DB Source properties in Derived Column

  I am converting the contents of 64 lookup tables from individual tables (each called lookup_xxxxx) into a single LookupReference table. The individual lookup tables are my OLE DB Source objects. I want to derive the variable part of the lookup_xxxxx table name from the OLE DB Source 'OpenRowset' property as a variable and make it into a derived column (which will be the lookup Type column in the output table). For example, extract "Species ...Show All

• mdenomy drill-through does not work ?

  Hi friends I have a simple report that lists summary of transactions made by each customer. when i click on no of transactions ,as you know, it would display invidual transactions automatically. It all working fine with VS2005 RC1 but recently we bought VS2005 standard edition (Nov release). with this licensed version i cant drill thru report !! i mean i can run my report ok but if i click on no of transactions it would not display any details ...Show All

• intrus0 unable to use existing sql logins

  Hi friends i have sql 2000 db which i attached to our sql server 2005.the problem all sql logins i've for this db are there but i cant login using any of those logins. i tried to delete them as i wanted recreate them but get following error. any idea how to reactivate those logins.Thanks for your help TITLE: Microsoft SQL Server Management Studio ------------------------------ Drop failed for User 'Damia'. (Microsoft.SqlServer.Smo) ...Show All

• owangecounty creating a windows athentication login

  Hi all. Here is my problem. Computer A has sql server 2005 express installed on it together with sql management studio. Computer B has only sql management studio. Computers are members of a corporate domain and are running xp professional. After starting management studio on computer B the databese engin on computer A is visible in the 'select server to connect to' dialog under network servers. When i try to connect i get the message login faile ...Show All

• EricPatterson Chain transact sql scripts

  I have two Transact SQL scripts and I want to call the second script from the first – is this possible in SQL server 2005 I am trying to do a port from Oracle (where this is possible) but cannot find the mechanism to do so in SQL Server. Eg if Script1.sql is BEGIN PRINT (‘Inside Script1’) //Invoke Script2.sql – how do I do this END where Script2.sql is BEGIN PRINT (‘Inside Script2’) END When I execute Script1.sql - I need it to prin ...Show All