Answer Questions

• SathyaKV Could not complete cursor operation because the table schema changed

  Microsoft SQL Server 2000 - 8.00.2039 Got this error: Could not complete cursor operation because the table schema changed after the cursor was declared. SQLCode: 16943 SQLState: HY000 Is this a known issue I suspect the application logic may cause this error. Please advise. Thanks a lot! Hi, are you doing schema modifications within your cursor If so the fetch of a new row will break as SQL Server cant validate the u ...Show All

• Aaron Epstein RE-Using passed parameters

  Hi All  I link to a report passing parm a,b,c (3 parms) a (Hidden), B(Multi Selection), C(Single selection), the report display correctly  and the parm selection boxes display with available options. I would like to be able to choose from the selection boxes and replace the initial (passed parameters) B and C would have a new value, and display the same report using the selected criteria. Thank you Trentino &nb ...Show All

• Serene Tiger Error while importing Text file using Import Export Wizard

  Hi all i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import O peration stopped... - Initializing Data Flow Task (Success) - Initializing Connections (Success) - Setting SQL Command (Success) - Setting Source Connection (Success) - Setting Destination Connection (Success) - Validating (Success) - Prepare ...Show All

• Aidy Merge Replication Using RMO

  i have done web synchronisation using RMO, where replication is happening on both ends, i want to perform one way synchronisation where a sales guy wants to update only his details to the server , and not to update the data from the server, can anybody help me on this task , the code for synchronisation i have taken out from msdn for Merge Replication using RMO programming .. Thanks -ExchangeType is not supported for Web ...Show All

• Stephen L How to Reset the Primary Key Counter

  I created a database table in VB.NET 2005 Express. I defined the primary key and set it to autoincrement for each record. I deleted all the data in the table and reloaded it with revised data. The primary key did not reset back to 1 for the new data. How can I force the Primary Key ID to reset back to 0 so the new data items start at 1 again Thanks. Hi, you can use     TRUNCATE TABLE <TableName> TRUNCATE ...Show All

• TommyJ Pakcage Error...How to read files on a different domain?

  So did some troubleshooting on the my previous post - http://forums.microsoft.com/forums/ShowPost.aspx PostID=272319&SiteID=1 Thanks to everyone who tried to help... So I got some insight into what is happening. My package was having trouble reading files on a remote domain although I mapped the drives locally. This does not cause either running the package to failed either through directly running under VSS, or Execution Utility. But i ...Show All

• Houman b Is there any way to relocate the data and log folders?

  Is there anyway to move the data and log folders to another drive without having to reinstall SQL 2005. I have limited space available on the drive where the program files are installed and need to move these folders to another drive with adequate space for growth. Thanks So, it would be nice if you could track it with "solved" in the group system. Cheers, jens. ...Show All

• jawalk Problem in SQL 2000 Analysis Service installation on windows 2003

  I am installing SQL 2000 analysis service on Windows 2003 but when the installation bar reaches to its completion, it closes down without any warning. I can see the directory created but no related service or icon is created. Also there is an error message in the even viewer. Faulting application _INS5576_MP, version 5.53.168.0, faulting module,oleaut32.dll, version 5.2.3790, fault address 0*00060484 I installed the software on anothe ...Show All

• BASmith Error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer

  Hi, I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer. Then when I try to delete it it gives this other error: Cannot remove the specified it ...Show All

• flynhigh deploying cube w/o database dependencies

  Hi, I have been asked to find a way to deploy a SQL 2005 cube with no dependencies on the relational database. Does any one have any suggestions of how this might be achieved Thanks ahur Hi, I have the same case, I need to deploy the cubes structure and data to another machine ( from development to production) , is there any way to achieve that Thanks You can process the cube on one ...Show All

• David N. SQL2005 Notification Services Workflow for MOM2005_SP1

  Greetings All We are trying to install Notification Services Workflow Solution Accelerator and have not been successful. We have come across a situation where notification services wont start. It just times out with error 1053. We have tried couple of things as admin, etc, but to no avail. Is Notification Services Workflow Solution Accelerator compatible with SQL 2005/MOM 2005 sp1 combo *silly me* Database is not on cluster, so that ...Show All

• Kamardash86471 == The SQL Server service failed to start ==

  I'm newbe with SQL Server , I'm looking for help with sql server express edition 2005. At the end of installation ocurrs an error: The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually. Error Number : 29503 . (Summary file) Rest of components has status : Successfully installed I've go installed .N ...Show All

• Fang Wang - MSFT Publisher become subcriber to other publication.

  Hi, I just want to know, is it possible to do this If yes, how to do it Thanks. Please note that if the same articles are involved, the root publisher (top of the replication chain) has to be setup before the republisher is setup. Yes, it's called republishing and common for merge publications. Please search Books Online for more information. See SQL Server 2005 BOL article: Republishing ...Show All

• davidc1110 Is SQL Server 2005 still using Named Pipes ?

  I keep getting errors.  It all started when I enabled named pipes on my SQL Server 2005 server.  Ever since then I've had connection problems up the butt. Most recently I got this error so does this mean that SQL Server is still trying to use named pipes even if I only have TCP/IP enabled in SQL Server Configuration Manager Error: TITLE: Connect to Server ------------------------------ Cannot connect to BG-SQL2005. ----- ...Show All

• Jonas Andero-Pettersson Getting error "Not enough space on drive c:\" when I install SQL Eval2005 on XP(sp2)

  I keep getting that error, yet I have 180GB of space. Is this because my drive is FAT32 and not NTSF (Help) Actuaally now I have 177GB and converted my drive to NTSF yet still getting error. Heres the sequence: Reading contents of package..... Checking package integrity.... Then bang the exact error next is "There is not enough space on c:\ drive to extract this package" I quess there i ...Show All