Row Versioning In SQL 2000?
I replicate (transactional replication) my data entry database to a
read-only database. Both are SQL 2000+SP4. The web server reads the
read-only database. At times, there will be lots of changes in the data
entry database, thus lots of replications to the read-only database. I
am concerned that the replication may lock the data in the read-only
database, causing slow response to the web server.
I would like to use row versioning so that the read-only database can
supply old data when the same row is being written by replication. I
read that row versioning is a feature in SQL 2005. Is there any
versioning capability in SQL 2000?
Thanks
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Versioning
Dear friends,In the area of GIS (Geographic Information Systems) there is a featureknown as versioning (long transactions).This feature allows databases to maintain different versions of data,in a hierachycal structure, in order to do simulation (what if ...),historical snapshots, concurrent editing, etc.Each version can be reconciled with its parent version in any moment(merge-post changes).I have recently seen that Oracle supports this feature from version9i.I am very interested in knowing if SQL server will support thisfeature in future versions. Looking at SQL Server 2005 doc. I haven'tseen any related info.Thanks,Jerry
View Replies !
View Related
DTS Versioning
I'm having problems to keep proper versioning control in place between the development and production environments. I'm running SQL2000 and we have hundreds of packages that runs daily. Some on shedules and some not. Every time a package is saved, it creates a version in SQL Server. After development I want to be able to use something like "Visual Source Safe" and book the final version in that was moved into production. Something with a version number etc. This is especially a problem if I want to roll back to a prior version of a package. I do not know which one of the 1000 versions to choose from that were created while developing the package. Another problem is that I do not know if someone is working on a package if I want to work on it. I can not run a search on all the packages to get a list of which tables/fields are used where to determine the impact of a program/database/design change that needs to be implemented. Any suggestions would be helpfull.
View Replies !
View Related
Database Versioning
I have a big delimma. We are developing and application that requires parallel work to be done one different copies of databases at the same time. Then when one when group is done and ready to ship their bug fixes/features, the changes they make to the database and data have to be merge back into the baseline database. Here's the specifics. 4 databases (that make up the product), 4 copies of the 4 database (one for each team). I was thinking about using SQL DMO to attach to each database and comare each table's schema and data against the baseline (the current release) then scripting out the changes that were made. Can someone give me some tips on how to maintain parallel database development and the merge process that can make this happen? Thanks, Kurt
View Replies !
View Related
Report Versioning
I was wondering if anyone knows if there is a way to version a report, after changes have been made kind of like there is to an application. when changes are made to an app with a version # of say 4.0.1 you can changge to 4.0.1. Without using a program like SourceSafe. Thanks in advance for the speed responses.
View Replies !
View Related
Sdf Database Versioning
I have a question about how I should go about handling different database versions (schema changes) with my application. I am using an sdf database as a local data store (either on the .NET framework or Compact Framework). I set it up so that the database file has the database schema, but no actual data, which is copied to the AppData folder if it isn't already there. The I load the database into the dataset, and can store data in the database with no problems. What I want to figure out is what happens when I later decide to change the database schema. For example, say I add a column to a table. When I load the existing database into the dataset, I get an exception because the existing database doesn't have that column. It seems that there should be some way to update the existing database so that it adds the column into the table, and sets the rows to just have NULL for that new column. I am not sure if the TableAdapter or some other object should handle updating the existing database so it matches the latest dataset schema, or if I need to manually write SQL statements to modify the existing database. Any help is appreciated. Adam
View Replies !
View Related
Database Versioning?
Hi, Could someone point me in the right direction? I have an internal development database and a production database. Is there an easy way to replicate the changes that have been made to the development version on the production server without modifying the actual data in the tables? So, if I add a new user in my development version I offcourse don't want to see it pop up in the live version. But adding/deleting/updating a new table or column should. And if possible I'd also like to know how you could do the following: Let's say we have an OrderDetail table containing information about the purchased product. Let's say I'd like to add a new column 'total' to skip calculation on the database every time I want to know the totals. It should be able to initialise the value by doing 'times ordered * price' for every existing row. Is that possible as well? Srry for the noob questions edit: Using MSSQL 2005
View Replies !
View Related
Versioning - Deploy Just The Changes To The Server
At ScottGu's Blog about "Database Publishing Wizard", AlexD from codeplex said: "Regarding the multiple requests for versioning, backup/restore of remote database, and selection of individual objects - these are all things we are actively looking at for our next release in the first half of 2007." After so many searches, I still don't know if this tool performs Versioning, i.e, when deploying the database, just update de diferences between the local and server database. Did Visual Studio Express 2008 have somethingh like that? (I know that VS Team Edition 2005 had). If this tool can't make it (versioning), which tool/method did you recomend me? Thanks in advance. Alberto
View Replies !
View Related
Versioning && History Question
I did a seach here and found some posts but none that answered my specific problem.I am a programmer tasked with building an application for generating Quote Proposals. The database is for the most part fairly simple except when it comes to versioning and history. Basiclly every quote can be revised and modified several times prior to making a final decision (final approved quote), so I need to keep track of the changes that occur durning the revision process. I am not a DBA but I have had some database experience. From what I can tell I have two choices a.) Duplicate all the data everytime the quote is revised. While this method is does cause a lot of duplicate data it is very straitforward and easy to explain (or turnover to someone else) and reporting becomes very easy as well.Reporting.... this is my biggest area of concern as the users of the app should have the ability to print out the original quote proposals as well as the revised quote proposals. Duplicating all the data makes reporting very easy.b.) Create a history table and record the original data (along with who and when) before recording the new value in the main table. While this method does conserve disk space it make reporting a bit difficult as you would have to pull the specific value for a specific Quote Revision and display the orginal values on the report instead of the current ones.Table info: I looking a 10 to 12 tables to record and store the data. The largest table will have about 40 fields. Current estimates are producing about 5 to 8 quotes per week. Each quote is revised an average of 2 to 3 times.Are the pros and cons I listed the main ones to be concerned with and are there any other options?Thanks
View Replies !
View Related
Versioning Of Stored Procedures
I would like to use versioning of stored procedures and must install Visual InterDev as instructed in a document obtained from a Microsoft web site; part of the instructions say to "select Visual InterDev Server Setup when this option is offered." Using Visual Studio 6.0, this option doesn't exist (but according to the document, it should). How do I perform this installation?
View Replies !
View Related
SSIS Versioning Control
Hi All, I'm new on SSIS, but have worked for some time with DTS and a long time with other ETL tools like Informatica or OWB. I would like to know in which way can i, easily, control my project/package versions. At the same time i need to implement a concurrency management system, which will control what developer is using which package, and when finished update the central repository (As it does Informatica or even OWB). I have heard that i could implement versioning with source safe, but can i implement this in the way that i've referenced before. Can i use CVS? Thanks, VÃtor Ferreira
View Replies !
View Related
Row Versioning, Audit, Best Practice
I have a small webapplication, sql server 2000. The users can only update the data in the system. However my client needs a report that display changes. The changes are that needs to be monitored are only change of order status, change of delivery date and when a user splits an order. What is the best practice to keep track of changes? A mirror table for each table with changes? /Magnus
View Replies !
View Related
Versioning Stored Procedures With SQL Server 7
Followed instructions in "Versioning Stored Procedures with Visual Studio 6.0 and SQL Server 7.0," but am not able to add a database to source control. When I right-click the data connection in the Data View window, "Add to Source Control" is not enabled. Also, when installing InterDev Server, got a message that it hadn't been tested with NT 4 (which we are using); continued setup anyway. Could this explain the problem?
View Replies !
View Related
SQL Deployment / Production Package Versioning
For the past few months I've been developing an DW and ETL with SQL 2005 / SSIS. My packages are being deployed to a SQL Server. Although in the end game we will have a Dev/Staging/Production environments, I would still like to archive production packages when we push staging to production. Essentially I would like to archive the last X packages that were deployed to production where X is a reasonable number (3 - 5). I don't necessarily need to have them accessible to run. One of the purposes is to have another safeguard should we miss anything in user testing and need to roll back a deployment. I am utilizing VSS and we will have backups running on the production server, but I would prefer to have a archive that is a little more accessible. I just wondering if anyone has any thoughts on how to extract/archive production packages when the push is made. I could easily develop an app that queries the MSDB and exports the packages to the file system. Anyone have any thoughts? Larry Pope
View Replies !
View Related
Suggested Best Practices For Custom Component Versioning
Edited:Maybe I should have posted this to the "managed" newsgroup. If any admins think that would be better, then let me know. I don't want to duplicate unnecessarily. Hi, We developed a custom Control Flow task for SSIS (2005, not yet had a lot of time to look at 2008 yet) and found that it does not handle versioning, or an uninstall and the resulting lack of an addressable component very gracefully. Here is a typical scenario: Baseline Install component MyCustomTask 1.0 Create Project Save Project Action 1 Uninstall MyCustomTask 1.0 and don't install the new version (a typical user scenario!) Open Project SSIS acts like the world has ended, especially if the user forgot to manually remove the item from the toolbox Fix:None, obviously, but it would be nice to be a bit more graceful and informative. Backdoor Toolbox fix: "Cleanse" the toolbox when it goes haywire by deleting the toolbox.tbd, in Documents and Settings<UserName>Local SettingsApplication DataMicrosoftVisualStudio8.0 Action 2 Uninstall MyCustomTask 1.0 cleanly, plus removing the toolbox item by hand. Install MyCustomTask 1.1, with identical interfaces etc, and add the toolbox item by hand. SSIS acts like the world has ended, and fails to ask you a sensible question like "do you want to upgrade the project to use the new version of the component" Fix:Identify major and minor version component changes and throw the user a rope. Backdoor Fix: Go into the DTSX manually - attack the DTSExecutable ExecutableType and DTS Name, for a Task in our case and replace it with the new version info. Even if the interface for the component has changed slightly, it seems to deal with that OK. Given the fact that it seems to be very likely that there will need to be SSIS version specific builds of components (I am assuming that a task created in 2005 will not work with 2008), what is the best way to deal with the current lack of SSIS smarts. Would this be the best approach: Version the interfaces, but never the builds within a version i.e. My.CustomTask90 v1.0, My.CustomTask100 v1.0 etc. This is a bit of a pain, rather than the simpler My.CustomTask v9.0 / v10.0 etc. Or, are there some nice improvements in the pipe to alleviate this, plus perhaps even a way to programatically add components to the toolbox, rather than the low-rent method of getting the user to do it by hand. All suggestions gratefully received. Thanks in advance Gareth
View Replies !
View Related
Design To Accomodate Entity Based Schema Versioning
in simple words it's about versioning at record level.ExampleTableEmployee - EmployeeId, EmployeeName,EmployeeAddress, DepartmentId,TableDesignationMap - EmployeeId, DesignationId, EffectiveDate,validityTableDepartment - DepartmentId, DepartmentTableDesignation - DesignationId, designationVia Modify-Employee-Details screen following are editableEmoyeeNameEmployeeAddressDepartmentDesignationthis screen should allow user to navigate through changes history.Example :Version -1EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment AccountsDesignation AccountantVersion -2EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment AccountsDesignation Chief Accountant - changedVersion -3EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment Sales - changedDesignation Marketing Manager - changedQuestion :What is the best proposed database design for maintaining historyrecords bound with version and retrieval techniqueBest RegardsSasanka
View Replies !
View Related
Locking In Read Committed With Row Versioning Isolation Level
I have a question on locking pattern of read committed with snapshot isolation level that when two transaction update two different records then why do they block to each other even if they have previous committed value (old version of record). I executed the below batch from a query window in SSMS --Session 1: use adventureworks create table marbles (id int primary key, color char(5)) insert marbles values(1, 'Black') insert marbles values(2, 'White') alter database adventureworks set read_committed_snapshot on set transaction isolation level read committed begin tran update marbles set color = 'Black' where color = 'White' --commit tran Before committing the first transaction I executed below query from second query window in SSMS --Session 2: use adventureworks set transaction isolation level read committed begin tran update marbles set color = 'White' where color = 'Black' commit tran Here the first session blocks to second session. These same transactions execute simultaneuosly in snapshot isolation level. So my question is why this blocking is required in read committed with snapshot isolation level? Thanks & Regards, Subhash Chandra
View Replies !
View Related
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
HI, I installed Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A in my computer, but I can't see MSDE on my Start menu. I am really new to this and don't know how to open MSDE, so I could work with it. Sorry for such a silly question, but please help me. How can I open MSDE from the Start menu. I have windows XP professional. Thanks for the help. Munny
View Replies !
View Related
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer. I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm). When I try to run setup, I get that message that says: "A strong SA password is required for security reasons. Please use SAPWD switch to supply the same." Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up? I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks! Ron
View Replies !
View Related
SQL 2005 Thinks A SQL 2000 Backup Is Corrupt, But SQL 2000 Restores Just Fine
I am attempting to move some SQL 2000 databases to SQL 2005. My main production database does not seem to want to move. When I use the SQL 2005 GUI the .bak backup file is marked 'Incomplete'. When I attempt to restore the backup file I get a 'RESTORE detected an error on page (0:0) in database' message. I saw a thread in the SQL Express forum suggesting trying to restore from the T-SQL level to get the GUI out of the picture and I get the same 'error on page (0:0)' message. However when I take the same file and use SQL 2000 Enterprise Manager it restores with no problems. Any ideas? Thanks Mike Mattix
View Replies !
View Related
Vista Business ODBC/DSN To Remote Windows 2000 Server / SQL 2000
Hi, Just upgraded some development desktops to Vista Business. However we need to still connect to some older remote windows 2000/SQL 2000 servers. Trying to setup an ODBC system DSN on our Vista Business local desktop we get the following errors - -START ERROR WINDOW- Connection Failed: SQLState: '01000' SQL Server Error: 772 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (SECDoClientHandshake()0. Connection failed: SQLState: '08001' SQL Server Error: 18 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security Error -END ERROR WINDOW- Any help greatly appreciated as this is stopping us from making database/table connections etc. We've checked the firewall setup and all is well there. PS - we can still connect fine using XP or windows 2000 desktops and their local DSNs.
View Replies !
View Related
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release
venu writes "Hi, Am very new to MS SQL adminstration Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice. The activity which am going to workout on MSDE is below. How to install SQL(on XP) How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other) How to create/delete tables if so, how can we do it either by GUI or CUI just i need a clarifications reg same Thank you, venu"
View Replies !
View Related
Maximum Capacity Specifications Comparison Table For Access, SQL Server 7, 2000 And MSDE 2000
Parameter Access 2000/XP SQL Server 7.0 SQL Server 2000 MSDE 2000 Number of instances per server n/a n/a 16 16 Number of databases per instance / server n/a 32,767 32,767 32,767 Number of objects per database 32,768 2,147,483,647 2,147,483,647 2,147,483,647 Number of users per database n/a 16,379 16,379 16,379 Number of roles per database n/a 16,367 16,367 16,367 Overall size of database (excluding logs) 2 GB 1,048,516 TB 1,048,516 TB 2 GB Number of columns per table 255 1024 1024 1024 Number of rows per table limited by storage limited by storage limited by storage limited by storage Number of bytes per row (Excluding TEXT/MEMO/IMAGE/OLE) 2 KB 8 KB 8 KB 8 KB Number of columns per query 255 4,096 4,096 4,096 Number of tables per query 32 256 256 256 Size of procedure / query 64 KB 250 MB 250 MB 250 MB Number of input params per procedure / query 199 1,024 2,100 2,100 Size of SQL statement / batch 64 KB 64 KB 64 KB 64 KB Depth of subquery nesting 50 32 32 32 Number of indexes per table 32 250 (1 clustered) 250 (1 clustered) 250 (1 clustered) Number of columns per index 10 16 16 16 Number of characters per object name 64 128 128 128 Number of concurrent user connections 255 32,767 32,767 5
View Replies !
View Related
Bit-data From SQL Server 2000 (2005 Working, 2000 Doesn't)
Hi, I am trying to edit some data from a SQL2000-datasource in ASP.NET 2.0 and have a problem with a column that has bit-data and is used for selection. SQL2005 works fine when declaring <SelectParameters> <asp:Parameter DefaultValue="TRUE" Name="APL" Type="boolean" /> </SelectParameters>When running this code with SQL2000, there are no error-msgs, but after editing a record the "APL"-column looses its value of 1 and is set to 0. Looks like an issue with type-conversion, we've hit incompatibilities between SQL200 and 2005 with bit/boolean several times before. So, how is this done correctly with SQL2000? (I've tried setting the Type to "int16" -> err. Also setting Defval="1" gave an err) ThanksMichael
View Replies !
View Related
Problem Using Access 2000 As A Front-end To SQL Server 2000 Tables
I've created a small company database where the tables reside in a SQLServer database. I'm using Access 2000 forms for a front end.I've got a System DSN set-up to SQL Server and am using links withinAccess 2000 to get to the SQL Server tables.My forms worked fine until I made a few minor changes to the databaseschema on SQL Server (e.g. added a foreign key, or added a column).After that, all the links break - I click on a table link and get anerror msg like "invalid object name."Deleting the links after a schema change and re-adding the links seemedto fix the problem. The forms I'd already created seemed to work fineafter re-creating the links.But then I got more advanced with my forms. I have it set up so thatfor certain entry fields, the combobox gets populated with values froma table (the description appears in the drop-down and the correspondingprimary key value gets populated in the table). I created a number offorms using this technique, entered data, and everything worked fine.Made a small schema change and it broke everything -- not the actualtable links, but the functionality for the drop-downs. My values nolonger appeared, and this was true for forms that accessed tables whoseschemas did not change.This is driving me nuts. Is there any way to keep my forms frombreaking each time I make a small schema change?Thanks.- Dana
View Replies !
View Related
Problem By Design - MS-SQL Server 2000 And MS-Access 2000 Project.
Hi.Sorry for cross posting!After I've installed MS-SQL Server 2000, I've got a problem each time I opena table, view or diagram in design, in a MS-Access project.Something like a table is popping up, but only the headline of the table,there is no name in the headline. The (ghost) table is automatic gettingfocus, (like a dialog box), and I can't do anything.I can close the (ghost) table using ALT-F4 combination, but it is veryannoying me.I've tried to uninstall both the MS-SQL Server 2000 and MS-Access 2000, I'vealso tried to compact and repair the database without luck.If I connect to MS-SQL Server 7 on another computer, (same database),everything is fine.My OS is Windows XP Home edition; the MS-SQL Server 7 is running on Windows98.Does anyone here have had the same experiences?TIAJørn
View Replies !
View Related
Reconnecting Access 2000 Front End To New Instance Of SQLServer 2000
I recently had to reinstall a new instance of SQLServer 2000, but was unable to use the previous server name. As a result, my Access2000 front end is not happy with it's linked tables. I can't seem to find anyplace within Access to universally change the address of the SQLServer used as the back-end for all linked tables. When I do try to access the linked tables through Access, I get an error, and the option to change the server location. When I try to type-in the new SQLServer location, there is an attempt to reconnect to SQLServer, but a whole lot of errors are generated, and none of the data is transferred into the Access table. I really don't want to have to re-do my Access front end, so it seems it would be easiest to somehow reinstall SQLServer to have the same server location it used to. Is there a good way to completely erase all traces of SQLServer so that I can have better luck reinstalling it to the same location it used to be in? Just using the uninstall program from SQLServer doesn't seem to be cutting it. Thanks!
View Replies !
View Related
Listing Users In A Winwos 2000 Group For Sqlserver 2000
Hi, I wanted to see what are all the users in a windows nt group that has a group access to sql server 2000. I have a windows 2000 group access to sqlserver 2000 as "xxxsomegroup". How can I list all users that belongs to this windows 200 group? is there any stored procedure to find out this? any information could be greatly appreciated. thanks
View Replies !
View Related
Windows 2000 Sp4 && SQL Server 2000 Causes Java Core Dump
I've just started getting this EXCEPTION_ACCESS_VIOLATION (0xc0000005) on machines using Windows 2000 sp4 connecting to SQLServer. This is crashing JVMs (multiple Sun versions and BEA also) in the Java VM frame (outside our code). This has just started recently - perhaps with the last set of patches? Has anyone else seen this or know what I could do to get more information? Could this be related to updates to named pipes? Thanks! -Brian Temple
View Replies !
View Related
Access 2000 Frontend MS SQL 2000 Backend - Locking Problems
We are using an Access 2000 project to view our SQL Tables and using Access 2000 Runtime to Access the forms in the project. We have written in a locking system in VB and removed the video controls to prevent users from accessing the same records. But of course now we need to make the video controls available. This has now thrown up the problem of multiple users accessing the same records. We have tried to write code to lock records when then video controls are used but this is not working as well as we hoped. Can anyone please suggest any way of setting up locking on SQL using triggers from the Access frontend? or any other types of locking systems that could be written in the Access front end.
View Replies !
View Related
Converting Data From Access 2000 To SQL Server 2000
Hi, I worked on a project in ASP.NET using SQL server 2000 as the back end. Its a conversion application that I rewrote in ASP.NET using C#. I need to import the old data in Access db into SQL server 2000 and I have very little knowledge about doing it. The data in not a direct one -one transformation. There are considerable changes to the Database design and data types. Any help and suggestions wud be really helpful. Also, any article links wud be great. Thanks
View Replies !
View Related
Importing Data From Pervasive 2000 To SQL Server 2000
I am working on bringing data into our SQL Server from a btreivedatabase through Pervasive.It seems to work, mostly, but I am having problems with dates.At first, all date conversions from btreive field type Date to SQLServer SmallDateTime would produce nothing but errors of this sort:ActiveX Scripting Transform 'DTSTransformation_1' encountered andinvalid data value for 'HomesteadDate' source column.Looking into the data on the pervasive side, many of the the datefields had no data in them.I tried to get around this by changing all lines that brought overdates from this:DTSDestination("HomesteadDate") = DTSSource("HomesteadDate")to this:IF ISDATE(DTSSource("HomesteadDate")) = 1 THENDTSDestination("HomesteadDate") = DTSSource("HomesteadDate") ELSEDTSDestination("HomesteadDate") = NULLWhat I have discovered since then, is that all my dates are simplyfailing the ISDATE check and returning null to the SQL Server, evenwhen it is a valid date.Any suggestions would be greatly appreciated.Steve HoyerGPW, MI
View Replies !
View Related
READ_UNCOMMITTED Problem With SQL 2000 And I-net Opta 2000 JDBC
Hi,I have a problem to set a JDBC connection as READ UNCOMMITED.setTransactionIsolation(Connection.TRANSACTION_REA D_UNCOMMITTED)This is causing lots of blocking on tablesand update or insert doesn't work properly.Does anyone have any idea what I'm missing here?I asked i-net support and they suggested to callsetAutoCommit(false) after the above functionand it didn't work.also suggested impltrans = true, and I changed that option on SQLand it caused more blocking.Thanks in advance for any info.
View Replies !
View Related
SQL Server 2000 - Problems When Installing Windows 2000 SP4?
I installed Windows 2000 SP4 on my server this evening. We ran intoan odd error, and (1) wanted to share, and (2) wanted to see if therewere any other things I should be on the lookout for.The problem we ran into this evening was "no storage was available".Email wouldn't work, Openqueries to other systems didn't work, and Icouldn't log in except as SA. Solution: upgrade IE to 128bitencryption. Since it's a server, I've never bothered upgrading theWeb browser on the system, but apparently SP4 does do something withthe encryption that breaks things. CryptoApi errors.We upgraded IE and it seems fine now, but I wanted to see if there wasanything else like this I should be on the lookout for. Thanks.
View Replies !
View Related
'Upgrade' From 2000 Standard To 2000 Development Edition
Hello!I would like to change the SQL server 2000 from Standard version toDevelopment edition. I have two database running on this server, bothreplicated, with few jobs, etc ... Can you recommend the easiest way to dothis? I heard, it would be as easy as, detaching the databases, deletingcurrent SQL software, installing different one, and attaching the olddatabases back. I doubt that is true, so that's why I'm asking here for anyreal-life instructions.Thanks for your input!Kind regards,Dejan--
View Replies !
View Related
Generic Help On A Few Issues (Access 2000, MSDE 2000)
Hi, my first post :) I've been reading this forum for a little while now, there's some excellent information within. I have a few issues that possibly someone, if they're willing, could give me a few pointers on. Firstly, I moved a backup of a database (that is located on a server running SQL Server 2000, I was not able to just simply copy the .mbf file to my workstation since its in use, and I cannot detatch it (its the backend db for the entire accounting system)) to my workstation, and I attemped to restore this DB using osql and MSDEManager2000, so I can develope a solution that connects to accounting data on my workstation. This is the error I recieve in osql: 1> RESTORE DATABASE master FROM DISK ='C:filesdataCDTData_db_200404130100.BAK' 2> go Msg 3108, Level 16, State 1, Server CODERBLUELINK, Line 1 RESTORE DATABASE must be used in single user mode when trying to restore the master database. Msg 3013, Level 16, State 1, Server CODERBLUELINK, Line 1 RESTORE DATABASE is terminating abnormally. I tried to research on how I could either restart MSDE in Single User mode or login to MSDE (in osql) in single user mode (if possible), but no luck. The other problem I'm having is: I created a new database in MSDEManager2000, then connected to it successfully in Access as an access project, and attempted to create a table, but the table creation window disappears immediately. The other operations work ok, such a create a view, form, etc. When I try to start a new Access Project w/ new database, and connect to MSDE to create the DB, I get an overflow. strange. Anyhow, thanks a lot, I'll continue researching to find solutions, but no luck as of now at all. (and not sure where to continue to search) Update: (5mins later) My download of SQL Server Books Online has completed, and I have installed it. WHAT AN ABSOLUTE GOLD MINE OF INFORMATION! First search query, I was able to find the command line parameters for starting sqlserver in single user! I am about to try this moment. If someone could please post a solution/information about my other issue I would greatly appreciate that. :) Update 2.0: "The backup of the system database on device C:filesdataWFIData_db_200404130100.BAK cannot be restored because it was created by a different version of the server (134217922) than this server (134218262)." damn.
View Replies !
View Related
Problem Importing From Access 2000 To SqlServer 2000
When I try to make a connection to an Access .mdb I get the following error: "Unable to open application. The workgroup information file is missing or opened exclusively by another user" Yet, I am able to open the file through Access and have necessary permissions and I know no one else has it opened. The mdb is password protected and I have provided the correct login information in the DTS connection.
View Replies !
View Related
Access 2000 On Windows 2000 Can't Interact With SQL Server 7.0
We have a SQL Server 7.0 system in NT 4.0 environment. We upgraded our users to Access 2000 and started to work with this. Now we installed a new server which is Windows 2000 based and the domain is different from the SQL servers domain. We then installed Access 2000 on Windows 2000 to use with terminal server. But I noticed that there was a problem with the program. I then looked at the program which was written on Access 2000 and saw that the tables and views can't be seen. The program runs but I can't see the views and tables. Another thing is access disconects from SQL Server when I want to see the tables. So what can be the problem. In one part there is an Access 2000 on Windows 2000 server. On the other part SQL Server 7.0 on Windows NT 4.0. And Access can't see the tables in SQL server.
View Replies !
View Related
Sql 2000 Installation On Windows 2000 Advance Server
I am trying to install microsoft sql server 2000 enterprise edition on a windows 2000 advance server. I keep getting error message A previous program installation created pending file operations on the installation machine. You must restart the computer before running . I have restarted machine and no change. What does error message mean and what is solution?
View Replies !
View Related
|
TRACKER
