Answer Questions

• nzmike Identify which reports are running

  Is there a way to identify which reports are currently running did you try this did you write a report to display this what did you do ... I havent done anything much yet with the execution logs. thanks No, haven't tried it yet. Will post again when I do. Don't query the tables directly, you could cause locking which will affect stability of the report server. You should instead use the ListJobs() SOAP api. http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listjobs.aspx What if I query using WITH(Nolock) Running with NOLOCK will prevent locking. However it will not p ...Show All

• MiltGrin Microsoft.Jet.OLEDB.4.0 has not been registered. ??

  Hi folks, We've got SQL2005 April CTP i64 running on Win2003 with SP1 appied (Itenium Proc).  Last week, one of developer sent me an email with error msg, : Msg 7403, Level 16, State 1, Line 1 The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered. I ran Component Checker against that box and it found that MDAC2.8 with SP2 installed.  I also found from MS site that Jet 4.0 SP8 i64 version available but the installation aborted due to newer version installed on the box.  I am stucked.  Any advice would be appreciated. Sunny Sunny, It sounds like the developer is executing code in a 64-bit application, and is looking for the Jet OLE DB Provider.  There is no ...Show All

• Tammt error while saving in text datatype

  HI,    I've a table with  5 fields datatype as text. I get error like this when i save huge data (like letter format) String or binary data would be truncated. The statement has been terminated. Is text a better datatype to store huge data. What are the problems i might get with this. is there any other better datatype other than varchar(8000).   thanks venp-- HI, I'm planning to try with varchar(max) datatype. venp-- ...Show All

• spanky4_3 SQL Server 2005 Clustering

  Hi, Would anyone give me some directions on where I could get good information on Windows 2003 and SQL 2005 clustering Thanks in advance. Run SQL Server 2005 Setup and click the Help button. There's a lot of very valuable information there that isn't in Books Online. Remember that SQL Server 2005 clustering is dependent on Windows Clustering Service(MSCS). Make sure you are very much comfortable with MSCS before you install SQL Server 2005 on a clustered server Here you go, this is pretty good. http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005.asp ...Show All

• Hrvoje Zlatar Stored procs with variable number of parameters

  I have received a change request for a project i am working on which im unsure if possible or not. at the minute i have a very simple sp that simply selects data from a table by passing in one parameter CREATE PROCEDURE PHAR_SelectGrade @int_ID int AS  SELECT GradeID as ID, Grade as Description, RequiresText, SendEmail, Timestamp  FROM tbl8Grade  WHERE Obsolete=0 AND GradeID = @int_ID ORDER BY Grade the user now wants the option to select more than one grade type (there are 100's of different grades) so they might decide they want to see details for 2 grades, 22 grades etc. these would be selected and stored in an array (via an asp.net project) and then the stored procedure is called from within a ...Show All

• Fayez Mutairi Urgent: SSIS data Convertion ??

  Hello all Ho can i convert Integer to String in SSIS Derived column. Thanks in Advance Raj Lakamana Yes, you mentioned ' derived column '. But I already used ltrim(rtrim( )) before 'Data Convertion'. The same problems happened.   What is "The data value cannot be converted for reasons other than sign mismatch or data overflow."     Thanks MoonRiver000 wrote: Yes, you mentioned ' derived column '. But I already used ltrim(rtrim( )) before 'Data Convertion'. The same problems happened. What is "The data value cannot be converted for reasons other than sign mismatch or data overflow." Thanks How are you converting the data What is ...Show All

• mary jane Reporting Service vs UDM

  I am new to both technologies and would has been reading UDM on how to create a cube. My orginal intention is to create cubes for efficient retrieval of data which ends up in reports managment in an application. Can anyone elaborates on how the reporting service differs from UDM ( or what reporting services are )I thought they are mutually exclusive Thanks. Regards Alu Yes. Thats my opinion. Most customers like both types of reports, leaf level and top level. Regards Thomas Ivarsson I know that alot time decision to use SSRS with or without SSAS(UDM) and vice -versa depends on customer requirements. But generally speaking is there a general guidline on when to favour SSRS without/with ...Show All

• Leaf. Import data using excel file!

  I import data to my Database(SQL Server 2000). I use excel file to import, some file is ok, but wiht some file, some data cell in these is lost. What do I do now I import data by using  "DTS Import/Export Wizard" then, "select Microsoft Excel 97-2000". In my excel file, I tried to use types(general, Number, Text) to format cells but not sucessfull  .  any ideas to solve my problem, sir  I appeciate your help. note: If you need that excel file for test, pls send me your email addr.      I believe DTS using Jet OLEDB provider to do the import and, I believe you could specify connect ...Show All

• Mateusz Rajca OLAP Services connection 8.0 Vs 9.0

  Microsoft OLE DB Provider for Analysis Services 9.0 ------ Microsoft OLE DB Provider for OLAP Services 8.0 I have both 8.0 and 9.0 installed in my box. I use Excel 2003 to connect to AS. I opened two excel files in one I used OLAP 8.0 to create connection to OLAP database which is in AS 2000. Connection was created as soon as I click OK in "Create New Data Source" window. When I do the same using OLAP 9.0 and create connection to same OLAP database in other server using AS 2005 it takes 2 mins to just create a connection after I clicked OK "Create New Data Source" window. I am just trying to figure out why Is there some thing which will slow down my query too. Hardware is almost same and those server runs only ...Show All

• jdang Error 3449 SQL Server shutdown

  SQL Server 2005 X64 Standard running on Windows Server 2003 X64 Htper Threaded Quad processors with 16 GB RAM. I have had two production servers shut down this week due to Error 3449: SQL Server must shut down in order to recover a database (database ID 1). The database is either a user database that could not be shut down or a system database. Restart SQL Server. If the database fails to recover after another startup, repair or restore the database. Previous to the shutdown I received multiple Error 3314 & 602: Could not find an entry for table or index with partition ID 491897996509184 in database 2. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored pr ...Show All

• Murre DCOM error

  I just installed sql server 2005 on a windows 2003 server.  I chose the option to install but do not configure.  After restarting, I used the Reporting SErvices Configuration Manager and it all looks ok.  When I browse to //localhost/reports I get a rs page with the message of: The request failed with HTTP status 400: Bad Request. One slightly unusual thing is SQL Server 2005 was installed as a named instance ("(local)\SQL2K5") - the server's default instance is a sql 2000 installation, which had RS installed and running.  Before configuring RS for 2k5, I deleted the VDs for Reports and ReportServer from IIS, so that I could recreate them to use 2K5. The new ReportServer VD appears to work (althou ...Show All

• AndriesVermaak Stored Procedures

  Hello Have you ever worked with stored procedures I am making an application in .NET using CSLA framework and I use as a data base one i've made in Access (not my wish) and I can't really manage those stored procedures. Any help Thank you, Monika Its an object containing the information about the objects stored inside the database. more information about this can be found in the BOL. Also about the ANSI NULL and THE QUOTED_IDENTIFIER behaviour. N converts the string to a UNICODE string. P and PC checks if the object found in the sysobjects is really a procedure. P = SQL stored procedure PC = Assembly (CLR) stored procedure Otherwise you could walk into the DROP part, because a table / view etc. could have the same nam ...Show All

• a.s.viswa Virtual cube

  In As2000 we can link 2 cubes together to create a virtual cube. But I don't see this in As2005. How can I link 2 cubes together You can have multiple measure groups in the cube in AS2005 - this gives same functionality as virtual cubes in AS2000. The measure groups can also be linked measure groups to the other cubes, so one measure group can be shared among multiple cubes, just like in AS2000. ...Show All

• RussP The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro) after SP1

  Having installed SP1, my SSIS packages using the OLE-DB Provider for Visual Foxpro no longer work. Using the latest version obtained from here: http://www.microsoft.com/downloads/details.aspx FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en When attempting to create one SSIS from scratch, the message thrown is: "The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro)." The radio button option of "Copy data from one or more tables or views" and then selecting the "Next >" throw the error. It has to be the SP1 causing the problem because nothing else changed on the Server and everything was working fine prior to this. Microsoft, any feedback on this ...Show All

• ntsoo Execute Function

  hi all, say for eg i have a function and proc named as fun_sample and proc_sample respectivley. why do we specify "dbo.fun_sample" for executing the function, whereas only "proc_sample" is enought for executing the proc firstly its a schema name or owner name, depending on the version of sql server being used...owner for 2000 and schema for 2005 for the main question...why dbo. for a function... i guess its just a syntax thing ...and it does saves time for the server... so maybe i'll use it evn if its not mandatory.... use it for sps as well.... For scalar function: select dbo.fun_sample() or declare @v int set @v = dbo.fun_sample() For table-value function: select * from dbo.fun_sam ...Show All