Answer Questions

• hariram_1975 Is this possible? How

  hello guys, I want to create a report using a bar chart data region from a cube. The cube contains Date and Time dimentions. Here is my question: The catagory field (x-axis) value of the bar chart is dependent on the paramaters value(i.e.StartDate and EndDate). For instance if the difference between StartDate and EndDate is greater than 1 year, the x-axis value for the bar chart should come from the Date dimention and display the year value. ...Show All

• dpatel How to generate SP scripts

  Hi ... there was a cool feature in sql 2k for exporting scripts for stored procedures. i.e for eg if I had 3 procedures. prc_proc1 prc_proc2 prc_proc3   and if I want 2 export the script of these sp's to 3 individual files rather than one single file then I was able to chose in SQL2000 i.e I was able to create 3 files with the same name as the sp's prc_proc1.sql prc_proc2.sql prc_proc3.sql   Now I wa ...Show All

• Mark Levison Cannot connect to SYNDIOMSVR. InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor arc

  I have the following mssql2005 error when I try to connect to the object browser.. [C:\WINDOWS\assembly\GAC_MSIL\Microsoft.SqlServer.SmoEnum\9.0.242.0__89845dcd8080cc91\Microsoft.SqlServer.SmoEnum.dll] InternalsVisibleTo declarations cannot have a version, culture, public key token, or processor architecture specified. (ObjectExplorer) Can anyone help me Thank you....god bless you all.. The .NET framework version has to match what SQL ...Show All

• Olivier Sanzot remote connection error SQL2005

  I am trying to connect to a remote 2005 SQL server “A” from my 2005 SQL Server Management Studio on a different network. I have opened up port 1433 on the remote server A. I have made sure that “Allow remote connections to this server” is checked on the remote server properties under connections. I have also chosen “Using both TCP/IP and named pipes” under Remote Connections in the SQL Server 2005 Surface Area Configuration. I am using ...Show All

• Nirmal Patel Losing umlauts in SQL Templates

  Hi there, does anybody know why I'm losing all umlauts whenever I drag a custom template to a script Double-clicking works fine, but I definitely want to avoid a unproductive workaround like double click > mark all >copy > paste in other script. We work a lot with shared templates and we cannot avoid using umlauts in the scripts. Any expericences or suggestions Thanks in advance Thomas ...Show All

• Berggreen Accessing the contents of a text index

  Hi All, Do you know of a way to explicitly access the contents of a text index in SQL Servers 2000 and 2005 I want to be able to extract all of the words that have been found against all of the rows in a database. I don't immediately want to know what rows were matched, so much as what keywords were found, so that I can do analysis on the keywords to allow things like predictive text boxes, tag clouds, alternate hierarchies etc. I'm n ...Show All

• JoeR Unable to use MS SQL 2000 SA Password

  Dear All! I have installed my sa password "sa" during my MSDE (desktop engine of sql) installation. currently i am loging into query analyzer using windows authentication. But i cant access the database through my code, coz i dont have sa access. Please kindly Help me finding my current sa password. Thank You! Hi, since you are using the MSDE the mode of authentication has to be provided during setup time (call of the ...Show All

• Brasiliansbr General error handling

  Hello, Originally we had laid out how we wanted our packages to work. In that concept we never really wanted our packages to fail but to offload the problem data to a file so that we could examine it (finding a problem in 1, 10, or 100 rows is easier than finding problems in 100,000 lines). The 2nd thing we want to achieve is to audit each task at the beginning and at the end. Very similar to how the the number of rows is shown in the dataflo ...Show All

• Phani_tpk OLE DB Source parameters ignored when subquery?

  I am using an OLE DB Source with SQL command for the data access mode. I defined parameters, then added a complex query with subqueries. It seems like the parameters for a query are not being filled correctly (because I am getting too many rows returned). At one point I saw an error message the said something to the effect that the parameters would be ignored when there was a subquery in the SQL. Can anyone shed some light on this Thanks, ...Show All

• mon Some kind of row versions in triggers?

  I have created an After Update trigger. I can get modified row from the Inserted table, but is there any way to get the "original" row I mean I'd like to compare two rows to get what exactly was changed. The deleted virtual table will give the before image of the rows that were modified. See Books Online CREATE TRIGGER topic for more details. Thank you! ...Show All

• Rosen M Component Property Data Types - How to set?

  I have developed a component, and within ProvideComponentProperties I have added a property (reflected code)-       IDTSCustomProperty90 property1 = base . get_ComponentMetaData (). get_CustomPropertyCollection (). New ();       property1 . set_Name ( "Seed" );       property1 . set_Description ( "The first row number." );       property1 . s ...Show All

• Padmav Balance Forwarding

  Hi, Just want to seek advice on how to forward the ending balance of Balance Sheet Accounts of previous year to the current year. Marvs That' right. So the following more simple sentence could be used: (parallelperiod([Year],1,[DimTime].currentmember), measures.[Balance]) Thanks What I think you are looking for is the new semi-additive measures in AS2K5, specifically the "last non-empty child" aggr ...Show All

• jpdb Very Lost while trying to Configure “Web Service Identity”

  Very Lost and very Frustrated Hello all, I am going to try to keep it short. Been banging my head with this SQL 2005 Reporting System. My system configuration is as follow: Windows 2000 server – (all services packs install) Microsoft SQL Server Management Studio 9.00.1399.00 Microsoft Analysis Services Client Tools 2005.090.1399.00 Microsoft Data Access Components (MDAC) 2000.085.1117 ...Show All

• CS Chan Replication performance measurement

  Hello, I am trying some replication sample.I create a table with thousands of records in the publisher side. as I create a subscription(the subscription database is on a remote machine), the whole table is created on the remote database. I wanted to measure the performence as: 1. how much time was taken in filling the whole table in the subscriber side 2. If i insert some 10000 records on publisher side, I want to measure, how much time w ...Show All

• Thomas GG ADOX - Create MDB problem - data source containing keyword "System" or "Windows"

  Hi, I'm developping an application in VB.NET 2005. I've made a function that creates an Access 2000 MDB with ADOX. I'm using the Catalog.Create method with a connection string to achieve this. Here is a connection string that works: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SYSTEM1\System2.mdb Here is one that doesn't work: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\SYSTEM\System2.mdb and another one that doesn't ...Show All