Answer Questions

• creaturita processing cube not pumping data

  I am trying to process a cube on a fact query that should return about 600M rows. When I run the processing, all Dimensions are processed successfully, and it starts processing the Facts, but no row count is shown indicating that it does not actually start streaming the data to Analysis Services. It has been running for 30 minutes and no count of processed rows has appeared. When I double-click the query and open the query in SQL Server Management studio it runs fine. Also I tried it with set rowcount 100000 and it starts streaming data to query output right away and gets to 100000 rows within a minute or so. So the query seems optimized and returns the data quickly. Also tempdb seems to be growing slowly. Does Analysis ...Show All

• BrianMcCashin synchronising data between SQL 2000 32 bit and SQL 2005 64 bit servers

  Hi I have a production system running sql 2000 server 32 bit Now i am planning to move to SQL server 2005 64 bit setup . I need to have a set up of both SQL 2000 and sql 2005 in parallel for some time until it is sure that the sytem can completly move . The problem is how do i synchronize the data in the two servers when they are operating parallely..... Please advice. Thanks in advance...... To setup the two systems to be in sync initially, use backup and restore. I do not understand why you would need some form of ongoing synch when running in parallel. In fact it would make no sense for the point of testing. You shoudl duplicate the work in/of your front end app to ensure the test is ...Show All

• simon_ Understanding cube

  Hi, I am new to OLAP and was reading on this area on the web. I come across this statement like: "while the relational database (OLTP) updates...the OLAP database will not be updated. " I am not sure of the above statment. In that case the data in OLAP is not the latest and how is it going to be updated Thanks. Regards Alu Correct. Analysis Services uses MDX and OLTP, Data warerhouse and Data Marts use SQL/relational queries. You cannot mix them in the same query. The only product that use a separate layer against Analysis Services and Relational stores is Report Builder(part of Reporting Services). You build report models in BI-Developer Studio against both type of sources and Report Builder use ...Show All

• JockForrester new records in table

  i have a situation where i have table A with 50 records, )with no timestamp column). Data will be appended to it on a constant basis, daily. how can you filter out the new records Can you please post the schema of the table or a sample of it Does it have an identity column for example If so, you could capture the MAX identity value after every day and determine the new rows. But this will only give rows that were added not modified. You can use similar approach if you have a key that has some time part in it. But this all depends on your data. Often it is best to use staging table approach so that you don't have to go to the main table(s). You can insert first into the staging table and then update the main table. This will ...Show All

• Chris The Avatar SQL 2005 Noise words

  I am trying to use the word best in a fulltext search and I get Informational: The full-text search condition contained noise word(s). I have looked at all the fulltext noise words noiseeng.txt,noiseenu.txt and noiseneu.txt and the word best is not in those files. If I put best in those files I have a c# function that looks at the value and checks to see if it is in the noise files, if it is it strips it (best business would be just business). Does anybody know if this is a known bug Does any body know a work around besides adding the word to the noise lists it's the question of the day at http://www.sqlservercentral.com i found this article h ttp://blogs.msdn.com/shajan/archive/2 ...Show All

• IceAngel89 Calling RS Report from VS2005 C#

  Hello, From a web application written in Visual Studio 2003 or Visual Studio 2005, C#, is there any way to send a SQL 2005 report directly to a local printer, while bypassing the standard Windows Print dialog box and printing 3 copies of the report(we could just loop the call 3 times if specifying a number is not possible) Perhaps there is some kind of api we can use Thanks Sam ...Show All

• vijayjun Advance Tab not available (Greyed Out)

    Hello I am working on a sql express table and while configuring the steps after I select the data source and the selectment statement window shows, I want to use the advanced tab but it is greyed out. I want to be able to add edit and delete my data. I have administrator rights for this project and the workstation so thats not the issue. What I am tryng to accomplish is extending a website to manage it's content and users. Also the table has colums and the colums has test data within them I tested a query and the connection had a successful return. Maybe it's a configuration thing I am unaware of.   DKB  This is the process of setting up a grid ...Show All

• barkingdog Reading a XML from table and passing it to sp_xml_preparedocument as i/p

  Hi All, I have a xml column in a table. As part of converting a XML into rowset i wrote a small proc like; /****************************/ DECLARE @DocHandle int DECLARE @XmlDocument nvarchar ( 1000 ) SET @XmlDocument = N '<XMLDATA> <COLUMNS> <Column name="Val1">sdf \r\nsdfsdfs sdfsdf</Column> <Column name="Val2"> 2 </Column> <Column name="Val3"> 3 </Column> <Column name="Val4"> Test0 </Column> <Column name="Val5"> Test1 </Column> <Column name="Val6"> Test2 </Column> <Column name="Val7"> Test3 </Column> <Column name="Val ...Show All

• search and deploy Deploy Package Problem

  I have a package that runs fine on my dev box. I deploy it to another server and run it by right-clicking and choosing run. I get an error saying it was unable to log in to the server.(Log in failed for user 'myuser') I am using sql authenication and the connection string says persist security info = true. So where is that password stored Did I miss something when I deployed (I have other connections in the package that are windows auth and they work fine) Data Source=myserver;User ID=myuser;Initial Catalog=Staging;Provider=SQLNCLI.1;Persist Security Info=True;Auto Translate=False; (I am just trying to get it to run on the other server, I know I may have other issues when I try to run it under sql agent) Thx ...Show All

• enric vives What is the difference between SQL Server 2005 installed with .NET and a standalone one

  Please could anyone tell me what are the real differences between SQL Server 2005 bundled along with Visual Studio.NET and a standalone one. Thanks in advance. This will depend on the edition of VS. With Visual Studio express, SQL Express is shipped. With the other versions of VS you could have installed the express edition of SQL or the developer edition. With most of these the main difference is that they can be instaled on the desktop. With a lot of the SQL Server installs you must have a server os for it to install. As with the differences the only differences are those based on the editions of sql 2005 that are installed, you can find information on these on the the sql home page or in the bo ...Show All

• Beski Merge Rep - Partition jumping

  Hello, We are merge replicating data from a server to client servers. The publication has a static row filter. If a change is made on the client to the field defining the partition, we are seeing a problem. After a synch, the record is deleted from the client. Here are more specifics: There are work orders created on the branch office server with a status of "Scheduled". These are replicated to the main office server upon a synch. Only records with a status of 'Scheduled' are replicated to the central server. If the client server changes the status from 'Scheduled' to unscheduled, the record then falls outside of the partition defined by the row filter. Upon synch, the change in status is sent to the server. The server ...Show All

• ruben_itlp lsass.exe high cpu, Error 18456

  We just migrated to a new sql server with SQL Server 2005 installed (we moved from 2000). We are experiencing two issues that we cannot resolve: 1. The site and database clients that use this SQL Server run very slow now. We have noticed that the lsass.exe process consistantly uses 25% CPU, +/- 10%. When we stop SQL server the lsass.exe process goes down to 0. What can be causing this The website uses a SQL user account, not a windows user account. 2. We have an error in the event log that might be related to the issue above. It appears every few minutes: Event Type: Failure Audit Event Source: MSSQLSERVER Event Category: (4) Event ID: 18456 Date: 10/25/2006 Time: 11:54:42 AM User: NT AUTHORITY\SYSTEM Computer: MSDB Description ...Show All

• jeskey Is it possible to edit the list of export options in RS 2000?

  Hi, I'm trying to edit the list of export options in Reporting Services 2000. I only want to display Excel and PDF in the export options list. I tried looking in the CSS file in the Styles folder, but didn't see anything that could be changed to accomplish this. Is it possible to do this Thanks, Mike Excellent! Thanks. Look in the RSReportSErver.config file. Add visible="false" to any rendering extensions you do not want to show up. You can also just remove them if you don't ever want people to use them (Although getting rid of html4.0 would break Report Manager.) ...Show All

• Narayanan_N_852dc7 ADO Recordset from SQL Task issue

  Dear Folks, I have a Foreach Loop that enumerates a set of files from an ADO recordset variable which is populated by a preceding SQL task. The query from the task that populates the recordset returns about 200 rows with one varchar field(a file path). The loop is long running, and so far it errors on the connection string populated by the enumeration variable after about an hour. The timeout for the SQL task is set to zero. Could it be the source recordset variable timing out, or could it be that the recordset is too large Thanks, Chris This is odd. there certainly could be a bug somewhere in the recordset object itself (in the interest of full disclosure, I wrote the code for the ADO Recordset object back in '96 :) ) If you ...Show All

• steveareno Error in Derived Column component

  I am getting this error, [Derived Column [192]] Error: Converting an input column from type DT_STR to type DT_WSTR failed. An error occurred while performing the implicit conversion on the input column. But I don really understand y there is a attempt to type cast at all Please advise .... thanks in advance Mark Durley wrote: You might try to putting a data conversion transform in your flow and doing an explicit convert from DT_STR to DT_WSTR for that column and see if you get a more helpful error message. I thought of this earlier and when I tried with a Data Conversion Component, I was not able to locate an option as DT_WSTR. Am I missing something here thanks for t ...Show All