Answer Questions

• Allaudeen_N_587b24 Help please - New user

  Hi all My project is a bit like eating an elephant, and I am about to take the first bite! I have built a number of Access databases over the last 4 years which support our local Production reporting, these work well and are within the scale supported by Access. However, my boss does not want to move forward with the Access platform. He wants me to redevelop the applications into one SQL database, which will have a new, and yet to be identified back end (something like clickview). Once developed we want to roll out the application to the rest of our group. The tables in my database will mainly be populated from our ERP system. The tables will either be master files, or transactions for a given range of dates. The master file ...Show All

• BabyGBear Need SQL server advice

  Hi, I need some advice concerning a vb.net windows application I'm building using SQL server as it's database. The idea is to have a main enterprise SQL server database on the company network. The application will be installed on stand alone computers with it's own Standard SQL server database which will mirror the network database. This is so users can work with the application when not connected to the network. The Network database will often be updated with new data and I will program the application so that everytime it is opened it will check the network database for new data and then update the local database. Of course this can only happen if the computer is connected to the network. My questions are: 1. When install ...Show All

• canadian_coder restore Differential back up file Using SQL DMO

  The log or differential backup cannot be restored because no files are ready to rollforward. [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE DATABASE is terminating abnormally. How can I restore Differential back up/Transaction log file Using SQL DMO You should take a full backup of the database before a log or differential backup. This can be done using the Backup class as follows - Server s = new Server ( "servername" ); Backup b = new Backup (); b.Database = "dbname" ; b.Action = BackupActionType .Database; bkp.Devices.Add( new BackupDeviceItem ( @"c:\testbackup\dbbackup.bak" , DeviceType .File)); b.SqlBackup(s); Thanks, Kuntal ...Show All

• Gordon Duff alter table - change time evaluation

  Hi, I have a table with 70 million records. I want to change the datatype of one of the columns from int to decimal(18,3). What is the best way of doing it and how can I evaluate the time change before I start and make the change thank you, Tomer ..assuming you want to know how long the operation would take....this varies massively by table definition + indexes + hardware + load you could use SELECT INTO to create a table of one million records and add indexes identical to those on the production table. Then drop the index on the int column on that table, execute an ALTER TABLE ALTER COLUMN to change the datatype and rebuild the index. Then multiply the result by 70 though that's ...Show All

• tattoo SQL Express -> SQL CE

  Hi there , if i'm posting on wrong forum, pleas redirect me :-D i'm still learning, and i decided to make my app for start in SQL Express and Visual Basic Express... i dont use stored procedures and sql specific features... so i use express only as data store.. questions 1. can i just convert database from sql to sql ce format when sql ce goes public 2. is then enough just to change connection string in my aplication or do i need more changes 3. when users needs grow, can i then again convert sql ce database to sql database with all the users data ! i need it to work with both... cose i would like to have one version for single user app and another (using sql express) for network version of the same app... tnx for all your help : ...Show All

• Vanyel Table Partioning with Computed Column

  This full version of this reporting table will have about 12 million row for each of three years. Prior years will be in separate partitions and frozen but the current year will be reloaded each night by source_key, probably in parallel. I am trying to do this with a computed column but I can't slide the partition back into the main table due to an apparent problem with the Check constraint. I have tried everything I can think of and still can't get it to work. I hope I am missing something simple. Anyone know why this does not work or how to fix it ALTER TABLE SWITCH statement failed. Check constraints or partition function of source table 'db_template.dbo.foo_year_source_partition_test_stage' allows values that are not allowed ...Show All

• Elad_23 Error source: Microsoft.VisualStudio.DataTools

  Sometimes when I edit a table through sql server (2005)management studio I get this error: No Row was updated The Data in Row 7 was not committed Error source: Microsoft.VisualStudio.DataTools Error Message: The Row value(s) updated or deleted either do not make the row unique or they alter multiple rows(3 rows). Correct the errors and retry or press Esc to cancel change(s)." The table is very simple with no constraints, key etc. And there is no relation - as I see it - to vs. I know others have had the same problem. But I could not find a solution. regards Michael hi, You don't have primary keys and sql server tables should never have duplicate rows. Try adding a primary key column to the ...Show All

• WV John Copy SQL Server 2005 DB to SQL Server Mobile - is it possible?

  I'm creating a prototype of a PDA app using CF.Net 2.0 and SQL Server Mobile for a prospective client and I've gone through and designed, built and populated a database using SQL Server 2005... and then realised where I really need it is on the PDA! Without going through all the pain of setting up SQL replication or writing all the code is there a way to export a 2005 database to SQL Server Mobile so it results in an .SDF file I know I can script each table out and run it via the SS2005 management studio when connected to a local .sdf file then copy that to the PDA but the thing is I really want to keep my test data so I don't have to re-enter it again. TIA for any help... there must be a way to do this but I'm quite new to SQL Server ...Show All

• Zwigby Relationshiptype in type 2 Slowly Changing Dimensions

  Hi, I've got a cusomer dimension buil on a type 2 slowly changing dimension with following attributes: customer group customer name customer number (business key) surrogate key I've got one hierarchie: customer group -- customer number and defined a one to many relationship between customergroup and customer. What I am not sure about: Can I choose relationshiptype = Rigid for this relation When a customer is moved to another customer group, a new record in the dimension table will be added. Before change Group A nr. 12345 surr. key 1 after the change, a second record was added Group A nr. 12345 surr. key 1 Group B nr. 12345 surr. key 2 So the relationship ...Show All

• NeederOfVBHelp Merge replication losing changes.

    Hi, I am facing a wierd problem while sync'ing. When I am do a synchonize from a mobile device to the server DB, one of my table column fails to update while all other columns get updated. The table uses row level tracking (tried making it column level too) and the field which fails to update is a date field (Nullable). This happens in case of syncing after updating >1 records on device. But syncing after updating just 1 record on device, this date field gets updated as expected. Note: I have filters set for this table. The filter downloads fields only with this date field=null. I need to downlaod all records meeting this filter condition but at the same time, this filter should not be applied while up ...Show All

• Batistuta Newbie: How to fires a WMI event alert?

  hi everyone, I've made a WMI event alert with this query: SELECT * FROM DDL_DATABASE_LEVEL_EVENTS WHERE DatabaseName = 'AdventureWorks' In Response tab I've defined my email as destination. Thanks a lot for any link or thought about this, ...Show All

• tala SQL Mobile create sdf file from SQL 2005 DB

  Hi, I'm trying to create a SQL Mobile .sdf file from my SQL Server 2005 database and cannot. I read the ms support docs for doing this and have had no luck . I created the respective publication and SQL Subscription for the db and when i run the process (not sure if i'm running the right process - docs don't say) it creates a directory under a "unc" directory with all my table objects (articles) with subscription/replication files for each table such as .cft, .bcp, .dri, .prc, .sch, and .trg. But no .sdf file for my SQL Server 2005 database. All I want is the .sdf file so that i can copy it to my Pocket PC device and then connect my mobile application to it. I want to copy my SQL Server 2005 database to my device so that t ...Show All

• Orest Bolohan Save data flow task result into specific table in database

  Hello Kindly i need support in this issue, i create task flow import from flat file and store in database but i need to save all result for task into specific table   Like Record count transferred Destination t able name Time ..........etc thanks   Sounds like you are looking for auditing information. Watch the Kimball Webcast on the main page of this forum. Plenty of examples in there. In summary, you'll populate variables in your data flow, and then after the data flow completes, you'll use an Execute SQL task in the control flow to perform an insert statement into your "specific table" using those variables previously populated. where in the main page Hosam Abd EL-W ...Show All

• nehajampala Debugging a Custom Resolver in VS2005

  Hi, I have created a custom resolver in VB .net (VS2005). The resolver works ( Both Publisher and Subscriber are SQL 2005 ), but I need to be able to debug the code within the resolver. How do I do this I have tried a number of things without success. Any suggestions would be appreciated. Cheers Neil Neil, you can open the merge agent (replmerg.exe) as a project in Visual Studio 2005, attach symbol files for your custom resolver, set a break point in your custom resolver source code, and run the agent with parameters. You will be able to trace into your resolver code from there. To open the replmerg.exe as a project in VS2005, go to menu File->Open->File/Project, and choose the execu ...Show All

• Rhubarb Can not retrieve application. Authentication error

  Hi All Environment We have used .NET Framework 2.0. We setup our web application in another domain. All reports are designed in microsoft SQL Server reporting services and uploaded to report manager. We have given link to Report manger from our application. Issue Whenever users trying to access Report Builder option from report manager, they are getting "Can not retrieve the application. Authentication error". Trails made to resolve above issue Action taken 1 From the msdn we come to know the error is due to not setting the Anonymous user privilege for the Report Builder folder in SQL Server Report services. The URL reference: http://msdn2.microsoft.com/en-us/library/ms365173.aspx "By ...Show All