Answer Questions

• Toby Tellier Can't uninstall books Online CTP Preview

  It shows in Add/Remove Programs.  I had ASP.NET 2.0 installed  and Add/Remove Programs tells me I need 2.0 before I can Install Books Online.  But I'm trying to Uninstall Books Online.  I uninstalled 2.0 with no effect.  I reinstalled 2.0 with no effect.  I searched Program Files and the Register and can't find Book Online.  It won't go away.  How to get rid of it   Thank you. There is no ...Show All

• Imti having a constraint on a adding a record

  how can i make a stored procedure for inserting a record in the database where it detect if the title is already present and then disregard insertion and just update the number of copies in that specific record i would be so thankful for any hel out there...tnx! Sure, this is one way to do it. But you will have to watch out for performance issues. INSTEAD OF trigger requires materialization of the rows in the inserted/deleted tables. A ...Show All

• pod Student Virtual Memory best practices with SQL 2005?

  After having my newly installed SQL 2005 instance lock-out all connections due to an Out of Memory error during a data transformation, I decided to start looking into memory config options. (Please consider I'm primarily a SQL developer who was selected as the DBA and therefore has to manage a Windows 2003 server as well.) In my case, the SQL memory settings looked fine but Windows 2003 Server had a fixed maximum on virtual memory of 2Gig on ...Show All

• seanu SQLParamData fails when putting large BLOB when MARS is enabled

  I am having problems putting large amounts of data into MSSQL 2005 with MARS enabled. If I use any other version of MSSQL or if I do not enable MARS, my program works fine. However, when MARS is enabled, the SQLParamData call after the SQLPutData call fails with the error "A transaction that was started in a MARS batch is still active at the end of the batch. The transaction is rolled back. (3997) A transaction that was started in a MARS ba ...Show All

• DragonsBlade SOAP Lite client error problem with CGI code - Help

  Hi, I have been working on a soap client project for over a week now and can not figure out what I am doing wrong. I am not an expert using Perl or SOAP so any help would be "greatly" appreciated. I get basic errors throughout, starting with: Error - SOAP::Transport::HTTP::Client::send_receive: POST It seems as if the user access information is not carried through as it should, but I truly have no idea what the problem is. Her ...Show All

• Yogesh2810 DB Files

  I have my Production database running in SQL Server2000. Some of the data is processed in Non-Production environment which has the same name as that of the Production database. The Non-Production environment has some additional tables with large volume of data . I want move these additional tables only to my production environment without overwriting the existing ones in production environment. Is there any way to move my dbFiles and atta ...Show All

• Ben S ReportViewer with Authentication

  I'm new to Reporting Services but have built some reports and have implemented them.  I have used the report viewer which works great and has a great tool bar that users really like.  One problem, I can't figure out how to pass network credentials using the viewer. If I use the ReportingService class I can pass the credentials and everything is great except that I lose the nice tool bar. I want the best of both worlds without having th ...Show All

• Theodore Chen Replication with filter

  Hi All, I've done my replication successfully between SQL Server 2000 and SQL Server CE. But how if I want to filter my replication For example :- At Table1 have 5 field which is UserID,Month,Year,Price,ItemCode I want to filter replication data with UserID and Month and Year. How can I do it Thank you!! Thanks Darren, I think that not the solution that i want.. :) Actually my problem is :- ...Show All

• PaulCzy problem with update

  Hi Gurus! In a scenrio i want to add one figure in the employeeid column in my table. I just want employeeid+1. And i m applying this query. UPDATE SET employeeid=employeeid+1 WHERE employeeid=111 My Table: employeeid lastname firstname reportsto ----------- ------------------------- ------------------------- ----------- 110 soomro w.a 11 111 Jhonson Tom 12 111 ...Show All

• Steele Synchronize SQL Mobile 2005 using ActiveSync

  I want to synchronize my database on Pocket PC / The Emulator that use WM5 and SQLCE3, but the synchronize is doesn't use IIS as the bridge, but i want to use ActiveSync as the synchronizer bridge. The rule like this. 1. Have database on Pocket PC. 2. Have application on Desktop PC. 3. When device or emulater placed on cradle, then the database automaticaly synchronized with database server on desktop pc. Why I want to use ActiveSync as synchron ...Show All

• ShoaibNC Dynamic Scripting for USE [DB]

  Greetings, I am having a difficult time figuring out a way to get this to work.  The scripting executes without error, but does nothing.  What I want it to do is change the connection to the database retrieved by the cursor. DECLARE @PAR1 VARCHAR ( 256 ); DECLARE DB_PAR CURSOR FOR SELECT NAME FROM SYS.DATABASES WHERE NAME LIKE '%HRN%TEST' ; OPEN DB_PAR FETCH DB_PAR INTO @PAR1 BEGIN EXECUTE ( 'USE ' + @PAR1 + ';' ...Show All

• JohnnyC Need to reset page count or use distinct count on new Grouping

  I have a report that will come back as 20 pages. What the user wants is on the beginning of another unique ID, which causes a new page to be started, to have the page count restart. So, if I have 3 UniqueIDs for all 20 pages, and the first, IDAA, is 10 pages long, the second, IDBB, is 4 pages long, and the third, IDCC, is 6 pages long, then the page numbering would be as: 1-10 for IDAA 1-4 for IDBB 1-6 for IDCC I know how to do this with Cr ...Show All

• Junio Vitorino RSClientPrint problem

  I'm trying to get client side printing to work in asp.net with reporting services 2005. I've got an aspx page to do printing as described here but when I try to render a report I get the following: 1. Print dialog box appears as expected 2. Press print 3. Dialog box appears saying "Print in progress" 4. After a few seconds another dialog box appears saying there was an error printing the report. Error code is 80004005. I ...Show All

• Andre Guergolet Error connecting from classic ASP

  I'm haveing some problems with using SQL Server in a classic ASP app. When trying to connect with the db I get the error: Microsoft SQL Native Client error '80004005' TCP Provider: No connection could be made because the target machine actively refused it. The Windows 2003 server runs both the SQL server 2005 express and IIS. Connectionstring: "Provider=SQLNCLI;Server=KSP;Database=KSB;UID=sa;PWD=;" ...Show All

• Barry Meaker Newbie Question

  I want to load a dropdown list based on another dropdown selection.Iam not sure how to do this.  Both are report parameters.Based on one parameter i need to load another parameter. Can someone help me. Thanks in advance mahalaks.   hello, I believe in the properties for the drop down, you can define a constraint (drop down), which is where you set that up. Brian ...Show All