Answer Questions

• r3n DB Mirroring Monitor Job - Purge Old Data?

  Hi, Not sure if this question makes sense, but is it necessary to purge old data in msdb tables used by the db mirroring monitor job I'm just wondering if an insert into the data table every minute of the day would still be needed a month from now. I'm thinking this data would be useful for the purpose of "alerts" and to have access to its recent history, but other than that, is it recommended (or necessary) Would these records keep accumulating until manually purged TIA. You can manually purge the data using SP_DELETE_BACKUPHISTORY and you can set to retain number of rows or worth of data from SQLAgent properties in this case. If there is a business case in your situation you can se ...Show All

• Ken Villines Error on Export to Excel

  We are getting this error when we try to export to excel in one report. Has anyone had this problem and what can I do to fix it Server Error in '/Reports' Application. Found the answer on server. We were returning too many rows in excel. ...Show All

• Thara Riaz Choosing the most frequent

  There must be a way to do this simply. We're running SQL Server 2000. I'm looking for some generic SQL statement that I can apply. If I have a table with a person column and a location column and multiple records for the same person / locatioin combination, how do I select the person with the location they most frequently visited Say George visits Mexico 5 times, and the Bahamas twice and costa rica once. I would have 8 records in my table for George. The data looks something like this: George/Mexico George/Mexico George/Mexico George/Mexico George/Mexico George/Bahamas George/Bahamas George/Costa Rica Ben/Brazil Ben/Brazil Ben/Peru The results would be: George/Mexico Ben/Brazil Thanks! Myles ...Show All

• krishna mohan2990 SOLUTION! - VB.NET 2005 Express and SQL Server 2005 - NOT saving updates to DB - SOLUTION!

  VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION! ----------------------------------- The following article is bogus and confusing: How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy' http://msdn2.microsoft.com/en-us/library/ms246989.aspx You must manually copy the database file to the output directory AFTER setting 'Copy to Output Directory' to 'Do not copy'. Do not copy The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file ...Show All

• avikhinvasara Read the filename, split it and put it in a table

  Hello I'm working on a package which loops through each xml file in a folder. The name of each xml file is put in variable. The format of the filename is something like "part1_part2_part3.xml" I need to store the 3 parts in three different columns of table A The content of the xml file needs to be manipulated ("." needs to be replaced with ",", ....)and put in serveral columns in tableB It's not clear to me yet how to start this but my main concern is read the three parts of the filename. I don't find any task in SSIS which could help me with that. Could someone give me some pointers Many thanks! Worf how do you get the filename into a variable ...Show All

• DavidThi808 Loosing database connection when device power-off (native oledb code)

  Hi, I experienced this problems on both Windows Mobile 2003 SE and Windows Mobile 5.0. Its native development (c++, oledb, atl and mfc). It's quite simple to reproduce... 1. open a database 2. open a rowset on table A (whatever, valid of course and with both IOpenRowset and ICommandText), read datas and close rowset 3. power off 4. power on 5. try step 2 with another table (failed on openrowset with error 0x80004005) or try table A (sometimes working because of cached memory, sometims failed on Read Datas). 6. being stuck ;-) Our work-around was, in case we loose our connection (identified by error 0x80004005 on openrowset), we close it and re-open database... ugly for sure, but working. What ...Show All

• Fahad349 Why the same attribute_value appeared several times within a mining model?

  Hi, all here, I am encounterting a question with attribute_value in my mining models. That is an attribute_value appeared several times within my mining models with different support and probability for a specific node (in my Clustering mining model) Why is that Really need guidance for that. Thank you very much in advance for any help. With best regards, Yours sincerely, query syntax: select node_name,[node_distribution.attribute_name],[node_distribution.attribute_value],[node_distribution.support] from MyMiningModel.content Part of the result is as following: Node_name, Node_distribution.attribute_name,node_distribution.attribute_value,node_distribution.probability (selected mining model column names) 002 ...Show All

• Matt354245 Creating RDL using information contained in an existing Data Model

  This question is in regard to creating RDL programmatically, using information contained in an existing Data Model; basically mimicking what the Report Builder does. What I need to do is integrate a dummied down version of the Report Builder into an existing web application; where users will have the option to build and save reports using a very simple web interface, 4 step process. This process will only have a very few of the options that the Report Builder has. So far I have built this process referencing the Microsoft Reporting Services dll's (Microsoft.ReportingServices.Modeling.dll for example), in order to retrieve the entity and attributes information from the Data Model. ** Does anyone know how I could create the RDL, usi ...Show All

• Morn Reporting Services Database Error

  We have had Reporting Services up for about 3 months now in our QA environment with no issues. However when one of our developers tried to go into it Friday we got the following error message: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'C.0.8.43'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights. (rsInvalidReportServerDatabase) I then read some about it and the fix seems to be to delete the DB and rebuild it. This is not going to be acceptable when we go to Production. Is there a reason this happened Is there other solutions ...Show All

• DilipK stuttering performance

  Hi Installed Sql Express on a 2003 SBS - installed fine - usual config of enabling TCPIP etc. The only problem is that my application (vb6 ADO 2.8) intermittently fails to open a connection to the database. I'm pretty sure the network connection is not dropping out etc. It even fails in the startup of the app - where it opens and closes quite a few connections - I have the feeling it is not releasing the connections to the pool We've installed it with many SQL 2000 and SQL 2005 clients previously and it normally works fine.... I tried changing the provider in my connection string from sqloledb to sqlncli but it didn't help at all. The SBS server has 2 gig ram. I had to install onto a workstation for a temporary workaroun ...Show All

• Randine error Type character '!' does not match declared data type

  i've got a report with a table 'table1' , when i try a preview i receive the next error msg Can someone tell me where i can find the cause of this error , i can't find it , to me everything looks fine. [rsCompilerErrorInExpression] The GroupExpression expression for the table ‘table1’ contains an error: [BC30277] Type character '!' does not match declared data type 'Microsoft.ReportingServices.ReportProcessing.ReportObjectModel.Fields'. Build complete -- 1 errors, 0 warnings Tx Stanja Open the edit group details screen by either: highlighting the table, right clicking and selecting properties. Groups tab -> Edit... button OR Right click a row header in a table and choose Edi ...Show All

• martin_eifert Report Parementer Dropdown Problems

  I'm having porblems with Drop down parameters in Reporting Services 2005. When I preview the report the first line of the drop down list is (Select All) but when the report is published the (Select All) option is not avaliable and you have to select each option individually. How do i get the (Select All) option on the published version as well as the preview version. Cheers. SP2 CTP is available via MS downloads. You can ask Microsoft support to give you hotfix RS2005-KB920794-x86-ENU.exe The server you deploy your reports to obviously has SP1 installed. With SP1 this 'select all' feature has gone, but will probably be back with SP2 ...:-/ ...Show All

• Chrisull Using an Excel Query to access SQL Server

  I set up an Excel spreadsheet for several users that queries a SQL Server. I provided the spreadsheet to the users and set it to refresh when ever it is open. The query is working fine. The problem is the users are prompted with a SQL Server login screen every time they open the file. The login screen shows the server name, the username and the password. All they have to do is press 'OK' and the screen goes away. Why are they being prompted with this screen What can I do to eliminate the users from even seeing this window I also receive this window whenever I open the file and I created it on the workstation where i'm opening it. Thank you for any input or suggestions. You might have to make sure t ...Show All

• Aniruddh Arithmetic Operation with Dates

  Hi I'm trying to get the difference between two dates. I need to create a Calculated member to show it. I'm using this formula PeriodDays = LastDate - FirstDate For example, I have a Time Dimension, I choose two dates: FirstDate = 07/04/2006 it's identity is 300 LastDate = 15/04/2006 it's identity is 308 PeriodDays = 308 - 300 = 8 this value I need to show in a Calculated Member The Time dimension has three levels Year, month and date What happens when I choose only a month Thanks Dear, I dont understand onething u are talking about date diffrence and u are giving an identity example. Pls explain in detail. Regards Sufian Hi, ohh, I will try to explain aga ...Show All

• yln Error: "The SQL Server Cannot obtain a LOCK resource at this time ..."

  I am wondering if anyone has any clue about the following error the occurred in a process of inserting a very large number of rows: "The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memeory configuration". It happened to a SQL 2000 PE. Thanks, ...Show All