Answer Questions

• JeanKap CeWriteRecordProps failling with a empty FILETIME field..

  Hi All, Does anyone have already made an application that writes some data into the EDB Pocket database I’m trying to insert a record with a empty FILETIME field and I’m getting the Error 87 (INVALID_PARAMETER), I’ve tested with some date in the field and the record is added sucessfull, it seems that the database doesn’t accept anymore empty FILETIME fields Is it true I didn't find anything in the docs. thanx in advance. ...Show All

• j_johnso Join problem

  hi I have got two tables and each table has about 8000000 rows.. the format of the tables is as follows.... Table 1 Comnpany_name Id Year Volume_jan Volume_feb....... Volume_dec ABC 1 2000 12 34 44 ABC 2 2000 222 50 44 .................................................................................................................... ...Show All

• yelz Left Outer Join

  Hi All Dudes and Dudesses Please help... I've got Two tables, Problem and Breach, in DB Support. The main Table (Problem) has a primary key on field Number and I retrieve most of my data from this table but the other fields are irellevant. The Breach Table includes fields: Number & Keyword. I use an Left Outer Join to connect from Problem.Number to Breach.Number and retrieve the Breach.Keyword if any. If there's no records in Breach it s ...Show All

• Apek Views or not?

  I am supposing that SQL Mobile 2005 does not support views in its database It is odd that all development tools show the tab of Views, but I cannot seem to find how someone would create one there. Is there a reference someone can point me to, or just reply to the forum to set me straight. Thanks. Correct, views and stored procedures are not supported by SQL Mobile. I would guess development tolls are c ...Show All

• yamadhrama Where is SQL Server Management Studio?

  I have the "Ready to Launch" package, which includes Vidual Studio 2005 Standard Edition, SQL Server 2005 Standard Edition and something else called BizTalk Server 2006. Anyway, Visual Studio is spread across two CD's and I have installed that. I now want to use the SQL Server Management Studio to administer a database I have running on a website. Anyway, SQL Server is on a DVD and when I put it into the drive it comes up with the a ...Show All

• Vaiduks OLAP cube format

  Can the reporing services read the cube definitions (backcolor,forecolor etc.) the MDX contanins the " CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL, FORE_COLOR, BACK_COLOR, FONT_FLAGS " clause. Thank you Thank you Robert, but yet i'm using OLAP2000. We're intend to move OLAP2005 soon. So i understand i cannot access those properties with OLAP 2000... Shlomi ...Show All

• dferraro How to get a left function in MDX language?

  We know in T-SQL, left(str,n) function let us get n characters in str, I want to get it in AS, but it seems not such function in MDX. can we write a self-define function as "left"     Hi, Chris, thank you for your help. But it seems not work. Can you give me a detail description of VBA Left function as I can't find it in AS2000. I have this problem as I want to fetch some members from one dimension t ...Show All

• tzvikab Accessing Initiating Event + Data From Existing External DB

  Hello, I have been exploring NS and I would like to use it as a rudimentary transfer tool. I have an existing database table from where I would to transfer a record to subscribers and then possibly move the records out of that table. 1. How do I set up the ..\SubscriptionClasses\SubscriptionClass\EventRules\EventRule so that it reads from another database The TSQL Statement should probably work accross databases 2. As I scroll through the samp ...Show All

• Sean Solt post SP1 hotfix

  Just curious, I'm reading about the SQL Server 2005 post SP1 hotfix and it looks like you need to install the packages in order: SQL Server Analysis Services Integration Services Notification Services Reporting Services Tools My desktop is configured as an Analysis Services and Integration Services instance, but without the SQL Server proper components installed. What should my install order be Does important note 3 about S ...Show All

• jpchen How to import *.mdf file

  I have a SQL Server 2005 database *.mdf file that I would like to import into another SQL Server 2005 engine on another computer. I don't see how to do this. How can I import a *.mdf file to create a copy of an exiisting database from another computer Thanks. Hi there, If you want a copy of the database on both servers then you can use the Copy Database Wizard. On the server that hosts the DB you ...Show All

• Alex Coppola Expand/Collapse all buttons in reports

  Hello! We just wonder if there is an easy way to incorporate  "expand all-collapse all" options in the reports we chose to drill down. Starting with a collapsed report is lovely but as the data get more it may be easier for some to see it all expanded. Thanking you in advance, Dimitris, Athens, Greece For the hopeful benefit of anyone else trying to get the InitialToggleState property to behave properly ...Show All

• StevesDisplay Report Deployment Problem on SQL 2005

  Hi everyone, I'm trying to deploy my Report Project on SQL 2005 on my machine from Visual Studio itself, but I keep getting this error: " The Report Server Web Service is unable to access secure information in the report server. Please verify that the WebServiceAccount is specified correctly in the report server config file. " Although I specified the WebServiceAccount in the rsreportserver.config file, using an administrative account, but still ...Show All

• Chad Moran Report Headers

  I'm new to Reporting Services, but am familiar with other reporting tools. My question is, is there really no way to reference a field in a page header If so, I suppose you could repeat some header information on subsequent pages from the detail section of the report using a text box, but how is that done because when I check the property box "Repeat report item with data region on every page" nothing happens. What is the best way to ...Show All

• ICE-Computer sql 2005 Error: Unable to read local eventlog (reason: 87).

  on the same machine both 2000 and 2005. 2000 replicate to 2005, then 2005 replicate to 2000. I recieve the above error from 2005 instance. The replicates (both) work fine, but the application EVL is full with this error. Any Ideas Hi, This is a known issue with SQL server agent and should be fixed in the next release. But this message should be harmless. Thanks, -Peng We're al ...Show All

• lie08 Convert MMYY ?

  Hi all, I am having a problem at a customers site: They are using a month field consisting of 4 digits. '1105' means November 2005. The field is a varchar(6) field. How can I convert this field to a date field, or read it as such 'Dateadd' doesn't seem to work. There is no need for dates, only months and years are relevant. Thx Regards Birger You can't have a date without the day. So, my suggestion would ...Show All