Answer Questions

• KCD Copying a database to another server

  Im running SQL Server 2005 Express with SQL Server Management studio installed on my laptop. After updating my database, how do I copy the entire contents to the main server in the office, which is running windows server 2003 and SQL Server 2000 Developer Edition. And is it possible to do it all from my laptop right click the database an you will see a context menu. on one of the sub menus here you will&n ...Show All

• simkinnet Large amount of text pushing to separate page after PDF Render

  I am having a small problem. When I generate a report with a large amount of text data (Paragraphs) the report will not split the text between two pages. It will move the entire text box to the next page leaving a large amount of space on the previous page. I tried every control on the page to render this. I tried textboxes, tables, lists, rectangles, subreports, etc.. The data is stored in a SQL table using a text data type (there c ...Show All

• amit Kumar Will Work for Help SQL 2k5 SP1 Installation issue (log attached)

  The upgrade to SQL 2k5 SP1 fails to upgraede the Database Services. Attached is the log. Will work for help. 05/24/2006 16:19:47.500 ================================================================================ 05/24/2006 16:19:47.500 Hotfix package launched 05/24/2006 16:19:53.687 Product discovery successfully completed during the install process for MSSQLSERVER 05/24/2006 16:19:53.687 SP Level check successfully completed during the ...Show All

• Eric Cooper Validate and Bulk Load Datatables in Dataset to SQL Server 2000 tables.

  I have a dataset with three tables. I would like to use XML bulk loading to load the data from the datatables in the dataset into three database tables. 1. Is there a way to validate the datatables(in a dataset) against the schema of each database tables and selectively remove the rows that are invalid Say 13th row in datatable 1 does not have a required value, I would like to remove row 13 and proceed loading the other rows. 2. L ...Show All

• Stuart_D Distributed Transaction on Windows 2000 Professional

  Just curious if anyone out there has had success running a Distributed Transaction on Windows 2000 Professional SP4 lately I have come to the conclusion that is is virutally impossible. I am running MSDE on a Win2k Pro machine and trying to run a distributed transaction via linked server and am getting the " The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction ." error. Yes ...Show All

• Kavitha SQL2005 Peer-to-Peer Transactional Repl. Table Constraints

  I am researching the possible use of Peer-to-Peer Transactional Replication with SQL 2005 to improve the availability and scalability of the SQL-farm. The "Peer-to-Peer Transactional Replication" MSDN-document states: "Conflict detection and resolution are not provided. Updates for a given row should be made only at one database until it has synchronized with its peers. This can be accomplished, for example, by the application directing updates ...Show All

• malangpc semicolon terminator

  Can someone define for me what is a statement when it comes to having to use semicolon statement terminator This is absolutely undocumented in BOL. Googling only finds this incoherent article which is far from official documentation. TIA The Semicolon The semicolon character is a statement terminator. It is a part of the ANSI SQL-92 standard, but was never used within Transact-SQL. Indeed, it was ...Show All

• Antons1 Excel pivot table

  Hi, I have several pivot tables in Excel that access data to a SQL 2000. We install SQL 2005, we change the ODBC from the 2000 server to the 2005 server. Now when we try to run the pivot tables I've got the following message: "User 'public' does not have permission to run DBCC TRACEON" Any idea on how to fix this problem Thanks, Arty Hello Igor, knowing that the code helped many users - would yo ...Show All

• tjiwe Cannot pass expression on command line

  I am trying to pass an expression in on the command line but it is not getting to ssis correctly dtexec -f "C:\Documents and Settings\simonsa\My Documents\Visual Studio 2005\Projects\Integration Services Project3\Integration Services Project3\Package.dtsx" /set \Package.Variables[User::datevar].Properties[Expression];(DT_DATE)"01 feb 2006" the "s are getting stripped so that the SSIS is trying to use expression (DT ...Show All

• Nic Butler Time Intelligence Wizard script shortcomings

  This is a question very much like one posed at http://spaces.msn.com/members/cwebbbi/   Basically, the script generated by the Time Intelligence Wizard only works for one level of a hierarchy.   I would like to know the best way to correct this. In my case several time dimensions are present - this means a short and simple answer is preferable as many scripts must be updated.   I will list a couple scenarios using A ...Show All

• yadav.shivam Can we toggle the database status between recovery and nonrecovery?

  Hi, 1) We will setup logshipping for a large database. 2) 2 systems are located at different city 3) Instead of use 'backup from primary and restore with norecovery to secondary ', we planned to use SAN disk clone to get a second set of disks for related database files and log files. 4) We will mount the disk to the secondary server, however, how can we put the database on the new server as 'norecovery' mode so that we can s ...Show All

• AlBu70 Newbie question: How to move a package from BIDS to SQL Server 2005

  HI, I have problems with executing packages in the SQL Server 2005 and before I go into the details I would like to check, if my workflow is correct. Can someone explain me the best way to move a package from BIDS to a SQL Server I would like to store the packages in the SQL Server. In addition if I login to Integration Services with SQL Server Management Studio I can see in the folder "stored packages" my package but I canno ...Show All

• Raja Pratap Other databases stopped working

  I have a similar problem but not with the sample databases. All the sample databases work perfectly fine but all my other databases that were hosted appear to have similar error "The database cannot be opened because it is version 607. This server supports version 603 and earlier. A downgrade is not supported" I'm using the SQL Server that came with Visual Studio 2005 Beta 2. Version 9.01116 Any ideas The er ...Show All

• Janet Robinson How to SubTotal with top N grouping?

  Hi all, I have a table on my report with a group on a field. I just want to SubTotal the 5 rows per group! I can get a sum per group,however, this sum is for all the rows per group! I just need the total for the first 5 rows per group! Can anybody help me with this Thanks. Group #1 2 3 4 0 2 1 ======== Sub-Total:11 (Sub-Total for the first 5 rows) ======== Group #2 1 2 0 2 2 10 8 ======== Sub-Total:7 (Sub-Total for the first 5 rows) ======== ...Show All

• Sivarv Sql Reporting Services Question

  Hi, I use sql reporting services in a C# windows form application. I made 3 reports which i use in the application. I tried to use each report several times during the application, i.e. - I filled in the report with parameters and DB data at first during the running of the application, and created a mhtml file from the report. when I tried to use the same report in the same running time of the application , but with different data and diffe ...Show All