Answer Questions

• unknown311 How to transfer database to mobile device?

  Hi all, I'm new to mobile devices. I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mobile device with the one on the desktop would suffice. Is something like this possible Thanks! You can copy the SDF file from the desktop to the device using RAPI. Thanks, I'll check that out. ...Show All

• dustinto Logging Packages Execution

  Hello all, I am struggling around defining a logging mechanism for my packages. I have 2 questions concerning that matter: I have used event handlers for my loggings (as defined here: http://blogs.conchango.com/jamiethomson/archive/2005/06/11/1593.aspx ), but the problem is with packages that failed validation. I cannot find log entry for these cases since no "onerror event" doesn't trigger (for instance when the table I'm loading to doesn't exsist). And the second question: many of my packages are executed using execute process task (using dtexec command line). I am trying to capture the result of the execution as a log file by using the ">" in the command line in order to output the execution to a lo ...Show All

• Adam J Friedman Who can give us an example connecting to a remote dw?

  hi, now i have a problem about Analysis Service, i have deployed a dw on a server and i want to connect it with ADO, but only when client and server is on the same machine ,i can succeed,if not the client can't connect the remote dw .   thks & Regards Try and see if opening Analysis Server ports solve your problem. if you are using AS 2005 the port number is 2383. You find some more connection trobleshooting tips on http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx Edward. -- This posting is provided "AS IS" with no warranties, and confers no rights. What product are you talking about Is it SQL Server or Analysis Server Edward. -- This p ...Show All

• MaggieChan Getting larger drive array

  We are planning to install more disk space and need to temporarily move the data and log files and move them back after the disk space has been added. Is Detach/Attach the best way to handle this You have to detach the database and then copy the .bak files to the directory and then attach it. Steve Russell, MCDBA Your absolutely correct, my bad; the .ldf and .mdf files. Steve, Thanks for the response. What will I need the .Bak file for I thought I would just be working with the .mdf & .ldf files. In other words, I was planning to do a Detach, then move the .mdf and .ldf to another server, uninstall the current 30 GB drives then restall 200 GB drives and finally Attach the ...Show All

• Davids Learning What's unallocated space

  I seem to have a lot of unallocated space in my SQL server 2005 database. I have shrank the database and also rebuilt every index checking the fragmentation of each. I can't seem to get rid of this unallocated space. Using the summary report from SQL Server Management Studio the break down of my database is Index Space 19.87% Data Space 43.43% Unallocated Space 34.71% Unused Space 1.99% Here is the command I used to rebuild the index which works really good (just be aware it will drop the index so dont run it during work hours). sp_msforeachtable @command1 = ' PRINT ''Starting ''' , @command2 = 'ALTER INDEX ALL ON REBUILD' , @command3 = ' PRINT ''Completed ''' Hi John, Unal ...Show All

• John_Wesley An attempt to attach an auto-named database for file......

  I've read through all the posts in this fourm that are related to the problem I'm getting with this error message on my main form, but none of the fixes seen to solve the problem. So I hope someone can get me pointed in the right direction. I'm running visual studio 2005 professional, and SQL Server 2005 Express Edition and this is a desktop application. I added the db file to the solution with the Add New Data Source wizard, I can create the datasets and preview the data correctly. An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\dbInventory.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. When I run ...Show All

• skrajmohan Dynamic capabilities with Parameters

  Hello all, I have a winform application, where in we get the parameters from the reporting service and we display them in a panel for user's to input their criteria. So far everything worked good, but now we have a requirement wherein dynamic functionality is needed. For Example: Based on a selection of a combobox value, we want the other control to be enabled or disabled. Also we want default value of a control to be calculated based on another control's value like .. if user enters value "1" in textbox1 then texbox 2 should have default value of "6". (Textbox1 + 5).........and mix and match of such capabilities. The Question is........IS IT POSSIBLE and if yes...HOW!!! Not a problem, Oka ...Show All

• StriderIRL SQL SERVER 2005 INSTED OF Trigger

  Hi. I set an INSTED OF INSERT trigger on a table, that deny the addition of rows in some conditions. My question is: When I run the insert command, I get the (X row(s) affected) message, even if X isn't the real number of added rows. I tried to set the @@ROWCOUNT function, but it turns out this isn't the way. Is there any way to change the affected rows count of a trigger / sp Thanks, Yaakov Well, when your DML violates FK constraint for example, an error is raised, and you get a real @@ROWCOUNT. IMO, because INSTED OF triggers overrides constraints, there should be a way to modify the rowcount. In such a way, INSTED really becomes INSTEAD. BTW, there is a way to do so in stored procedures Thanks, Yaak ...Show All

• CSharpShooter dev to UAT to Live using linked server catalog to default the database

  Hi all, Im trying to have one set of TSQL code that uses global settings in 'linked servers' so code can migrated from development, to test to UAT and finally to live without change. e.g. select * from [oursystem].ourDB.dbo.table join [linked_server_othersystem] .. dbo.tablename ... By using no database name (and expecting the catalog set at the linked server to be used) the same code is equivilent to : select * from [oursystem].ourDB.dbo.tablefrom [oursystem].ourDB.dbo.table join [linked_server_othersystem]. developmentDB .dbo.tablename select * from [oursystem].ourDB.dbo.table join [linked_server_othersystem]. testDB .dbo.tablename ... select * from [oursystem].ourDB.dbo.table join [linked_server_othersystem]. UATDB .db ...Show All

• JonathanAramburo error: the publication does not exist

  I had a publication that I removed from the Local Publications folder but it still shows up in Replication Monitor (with a red 'X'). No jobs exist related to this publication either. Everything is working ok, but I can't get rid of this from the Replication monitor. Any help would be appreciated. Thanks. Yes, that did it! However, the problematic data was in another set of tables... There was a record in the MSReplication_monitordata table and an associated record in the MSSnapshot_agents and MSSnapshot_history that were associated with the publication that no longer existed. Not sure why this data was still in these tables but once I deleted these records, the error in Replication Monitor dissa ...Show All

• adi151478 Strategy for upgrade to SQL server 2005 , consolidate and cluster

  Hello there, We have about a dozen SQL server 2000 Enterprise Edition servers in house. Our goal is to set up a cluster SQL server 2005 and consodiate the existing dozen servers to a few servers for easy manage and maintainence. So there are 3 things that we want to accomplish: 1. upgrade to SQL server 2005, 2. Consolidate existing servers 3. Make a cluster server to get high availability But I'm sure what's the right order to acheive them. To upgrade each server to 2005 and then move them to cluster server or set up the cluster server in 2005 and restore existing dbs to the cluster server. upgrade first or cluster first upgrade first or consolidate first pros and cons upgrade or backup/restore What do you recommend We have ...Show All

• .Net Pro Readers not queued?

  When multiple readers are waiting on a message from the same queue, I would expect that the reader that has been waiting the longest would be the first to pick up a message. However, I'm shocked to discover that the opposite seems to be true; in my tests I'm showing that the reader that has been waiting the least time picks up a message first! This seems totally counter-intuitive, and I'd like to know why it's working this way. This implementation will cause a lot more reader timeouts to occur than a properly queued method. For instance, assume that I have two readers, each using a one minute timeout. Reader #1 starts waiting, and reader #2 is busy for another 20 seconds before it starts waiting. 39 seconds later a message comes in and rea ...Show All

• james_cline_ SQL Server 2000 - Generating new field containing the sum of other rows

  Hi guys, This one seems to be a difficult one: I have a table called "myTable" with a field called "myField" (which contains only numbers). I need to generate a new field where each row is the sum of the row in field "myField" plus all the values in the rows before it. something like this: myField NewField 100 100 = 100+0 200 300 = (200+100) 300 600 = (300+200+100) 400 1000 = (400+300+200+100) 500 1500 = (500+400+300+200+100) I'll apprecciate any smart help. Aldo. Hi lkh, Thanks for answering. I have never used the code to create a table yet, but I understand from your code that you are creating a new Table and entering each val ...Show All

• PK_VBE05 Package randomly stops

  I have a very weird issue in my latest package. I run it and it just randomly stops. When I watch it in debug mode or not in debugging a command prompt window will flash for an instant (too fast to read) and then the package will stop. It stops inside of a for each loop and the "on completion" is never fired for the loop. I never receive any errors - its just like someone hit the stop button. Sometimes it will process hundreds of files before stopping, other times only a few. (And its not stopping on the same file each time.. it doesn't appear to be related to the file at all) Any ideas what could be going on How to troubleshoot Well I ran the package directly on the server and it crashed a ...Show All

• caligula log_reuse_wait setting

  Hi All I changed a database from replication to non-replicationg, but sys.databases stil shows log_reuse_wait column =6 (REPLICATION). Consequently the log file keeps growing and am not able to shrink it. Any body know how to fix this Thanks K T Hi Greg Using the Man. Studio. First dropeed subscriptions Dropped Publications Then disabled database for publication When I run exec sp_dboption 'dbname', 'published' returns published OFF Thanks K T What build are you using, RTM or SP1 There was a bug similar to what you were describing in RTM that was fixed in SP1, but only happens under certain conditions. A quick workaround is to re-enable your database for replicatio ...Show All