Answer Questions

• HariAdu Problem when deploying Reports

  Hello, I am working on SQL Server 2005 Reporting Services embedded in the Visual Studio 2005. I ve build reports perefctly, but the problem raised when I tried to deploy this report: I am deploying these report with a debug configuration , and I have tried with the 2 TargetServerURL: http://localhost/reportserver$sql2005 http://localhost/reportserver The Error message is the following: TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/reportserver$sql2005 . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the erro ...Show All

• rob warning ADOMD.NET Server

  I am trying to create a stored procedure that retrives product items which sales volume variance is below certain level using the following code: Public Shared Function FindLowVarEntries( ByVal InputProductSet As [Set], ByVal InputTimeSet As String , ByVal SalesVolume As String , ByVal VarLowLimit As Decimal ) As [Set] Dim oMDXVal As MDXValue, oResSet As SetBuilder = New SetBuilder Dim oTuple As Tuple, strContext As String , oExp As Expression = New Expression For Each oTuple In InputProductSet.Tuples strContext = GetCurrentContextFromTuple(oTuple) oExp.ExpressionText = "Var( " & InputTimeSet & ", " & SalesVolume & ")" oMDXV ...Show All

• feroz_ahmed Identity field property lost after import tables between databases

  I have found an issue on sql server 2005 data importing function: For example, I have two databases named DB_A and DB_B. If it has a table named table_a on DB_A with an identity field (say field_a), then after transfer table_a to DB_B by using the 'Import and Export Wizard' of MS SQL Server Management Studio, the identity field of table_a on DB_B is no longer an identity field. i.e. DB_B.table_a.field_a is not an identity field any more. This issue is remain the same as transfering tables from sql server 2000 to 2005, or from sql server 2005 to 2005. Has anyone know how to work around for this problem Thanks in advance. Athens Yan P.S.: I have using sql server 2005 with SP1 applied (9.0.2047). ...Show All

• Postman001 SSIS hang

  I sumbit a package A in MSDB in SQL2005 EE server with SP1 by dtexec. Package A called 2 packages B and C in MSDB to do some data flow task. The package A finished successfully in about 2 to 3 mins. Howerver, when I submitted the package A again. Package A hanged. I checked the Activity Monitor and found all related Package A, B, C task is sleeping. I killed the dtexec and then re-submit the package A. Package A finished successfully this time in expected duration. It is strange. Could anyone tell me the reason of hanging Thank you very much. >I checked the Activity Monitor and found all related Package A, B, C task is sleeping. Do you mean SQL Server Activity Monito ...Show All

• Kernel Panic Numbers less than zero

  In a pretty standard select statement (as shown), i want to return 0 when "dbo.v_AgentOrderTotals.Total - dbo.v_AgentAmmountPaid.total - dbo.v_AgentCommClean.total AS amount_outstanding_commission" is less than 0. SELECT     dbo.t_Agents.agent_code, dbo.v_CurrentParamPaymentTotal.ammount AS weekley_payment_total,                       dbo.v_AgentNumberOfCustomers.count AS number_of_cust, dbo.v_AgentAmmountPaid.total AS total_paid,                       dbo.v_AgentOrderTotals.Total AS ytd_order_total, dbo.v_Age ...Show All

• shaw79 How to import relations with DTSWizard?

  Hello, I have installed the recent version of MSSQLExpress 2005 with the DTSWizard. I was able to import my Access Database successfully into MSSQL. However the keys and relations are not copied over. Is there a way to do that or Do I have to set everything manually Thanks Kave Check this KBA http://support.microsoft.com/kb/237980  about upsizing the access database and that will talk about your need. Review http://support.microsoft.com/kb/285829  too. Many thanks that helped me out. Regards Kave ...Show All

• Eladka Cannot connect to 2000 from 2005 via linked server

  Interesting issue.. I think I have 2 linked servers on my dev 2005 instance (sp1-win 2003). My 2005 instance shares the physical server with a 2000 instance. This linked server works fine. The second linked server is on a separate server running sql 2000 sp3. I cannot connect to this server at all. I can connect the other way -- from the 2000 to the 2005. I have tried all kinds of combinations of security and options but nothing works. The only resolutions I have found referenced installing Management Studio on the 2000 server or creating an ODBC connection from the 2005 instance. Any ideas Here is the error I get: OLE DB provider "SQLNCLI" for linked server "ALLFLDB6" returned message "Login timeout exp ...Show All

• HSBF Lewe Sql Server access proble from network

  I have installed on a new computer with Windows XP the MSDE. I can not connect to this instance of SQL Server from network with TCP/IP on 1433 port. It is the defaul instance. I execute netstat -ano command on this computer and port 1433 is not opened. I isolated this computer from network, and I have reinstalled Windows and MSDE without any firewall and any antivirus. I have reinstalled the MSDE. The port is still closed. Than I tried with Windows 2003 and Microsoft Sql Server 2000. the port was opened. After I activated the firewall and I installed an antivirus, I connect this computer to network. After a working day the port was closed again, and I cannot open this port. I was in Enterprise manager and I was looking to the enabled pr ...Show All

• barkingdog SMO & DMO FAQ

  I have posted common questions on my blog. Take a look at the FAQ before posting questions in this forum. I will continue to add on answers for common questions as I go. I hope this helps finding answers faster! http://blogs.msdn.com/mwories/articles/smoindex.aspx Comments, let me know! Thanks, Michiel I am trying to maintain some backward compatibility with SQL DMO 80. I've installed SQL 2005, but cannot find the DMO libraries and include files I can link to to recompile the c++ program....any ideas... Which link THe link with the components works for me. Jens K. Suessmeyer --- http://www.sqlserver2005.de --- You can download the backward feature back here: http://download.microsoft.com/do ...Show All

• Suman Ghosh Definition of 'Persistent Data'

  What is the definition of 'Persistent Data' as related to the definition of a RDBMS thx, Kat Hello, Data is said to be persistent in RDBMS when the transaction that has written it is commited. One of cornerstones of RDBMS is the ACID contract between the system and the components that issue transactions. ACID stands for Atomicity, Consistency, Isolation, Durability. The Durability property sais that once a transaction has been commited, its modifications are guaranteed to survive any failure of system, once the permanent storage is not damaged. Another term for Duarbility is Persistence(they just use Durability because ACID is the cutest abbreviature one can think of :) ) So, basically, persistent data is the data that has ...Show All

• BobLane sum in table footer

  hi, I having a problem summing up a group that I have filtered. I'm using the table object and have a group filtered on the states below. I need the sum just for the following. But, instead I'm getting the sum for all the states. I even tried this but it doesn't work either. SUM(Fields!revenue.Value,"table2_Details_Group") state revenue CA 500 CO 600 UT 800 Any suggestions. Instead of filtering on the table group, you should look into moving the filter to the table data region. The table footer sum will cover all detail rows unless they are filtered at the table level. -- Robert ...Show All

• Marauderz Closed conversation endpoints not being purged

  We have been having a problem with service broker for quite a while now and searching on these forums and more generally on the web has not yielded any kind of answer... Our application utilises service broker within a single database (there is no cross database, cross instance or cross server communication). There are approximately 12 queues which are used to varying degrees. A few of the queues have a throughput rate in the order of up to 100s per minute at peak periods. In some scenarios we are able to make use of persistent conversations but the majority of messages are sent on their own conversation or in small batches on their own conversation. Some time ago we found that the database was growing in size more than expected d ...Show All

• BenCh1 Is SQL Server Express what I need????

  Hello, Someone I know told me that they thought SQL Server Express was what I am looking for. Before I get in over my head I need to know from people who use it if this is really for me. I have build my own web site using very basic HTML and CSS. Nothing fancy I am very new to this. What I want to do is have a customer able to enter their email address, once they have hit submit, I want the email address to go to a database (which I believe this software is going to help me set up ) and a document sent to them. I was thinking of a PDF attachment to an email since I have not figured out yet how to send an email that looks like a web page. I now have a customer inquiry form on my site that is sent to a perl script in my cgi bin ...Show All

• DanR1 Migrate SQL Server from 64Bit platform to 32Bit

  Hi, All: We have to migrate several 64Bit SQL Servers to 32Bit platform. Due to the 64Bit source systems are all production system, the downtime is too limited. So we can only get the DB files via Detach way. Among the source systems, both SQL2000 and SQL2005 exist. My question are: Is it possible to migrate the DB from 64Bit to 32Bit via Detach/Attach If ok, how to do that Any info will be highly appreciated! Thanks! Best Regards, Kevin Hi Kevin. The on-disk layout of database files is the same for 64bit and 32bit databases, there's no difference...you can freely attach/detach, backup/restore, etc. to/from 32bit/64bit systems and vice-versa at will with no issues. Of course, t ...Show All

• Piddo Cube deployment issue SSAS 2005

  Hello all, I got an issue with deploying my cube. I am new to SSAS 2005, and I cannot find the option to define which account to use with deploying. I managed to choose the server for deployment, but strangely enough, no user can be selected, so when it deploys, it throws an error stating the standard windows login isn't valid (wich is correct, but I do not want to use standard windows login). And why do I have to use a local windows user account Why can't the account from my server Thanks, that answers my question about how these cubes are being stored. :-) Is it suffice when I get those rights only on that particular directory where the cube is stored ...Show All