Question about Televison & Video

2 Answers

Transaction replication is poosible in sql server devlper edition

I want to do replication between sql server 2000 and sql server 2005 developer edition. if yes devloper edition can also perfrom replication then what hardware and software requirements are required for this.I have sql server 2005 n sql server 2000. i want one wy transaction from server 2000 to server 2005..how to move ahead with this? plz help.
waiting for ur reply,
shubhangi

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Social Spider:

    An expert who has shared 50 answers on their Facebook wall.

  • Expert
  • 43 Answers

Depending on the replication topology. Here's a link to the Microsoft site which explains.
http://msdn2.microsoft.com/en-us/library/ms143241(SQL.90).aspx

Posted on Jun 06, 2016

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 1,800 Answers

SQL Server 2005 provides a lot of benefits over SQL Server 2000 including within the replication feature set.

You might be relieved to know that, although most of the benefits accrue on the side of a SQL Server 2005 Publisher, you can still set up SQL Server 2005 as a subscriber on a SQL Server 2000 Publisher. Thus, you can begin to merge in the newest release of SQL Server into an existing replication scheme. You can read more about this at http://msdn2.microsoft.com/en-us/library/ms217330.

Although major advantage to SQL Server 2005 over 2000 is that changes to the schema, such as through ALTER TABLE statements, replicate out to all subscribing servers. The cool news in a mixed version environment is that the ALTER TABLE statements will be published to SQL Server 2000 Subscribers from a SQL Server 2005 Publisher.

Very cool!

Posted on Jan 30, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I have installed Windows 2012 server Os and in that system i have installed Sql Server 2008 R2 Express Edition and Microsoft SQL Server 2012 Transact-SQL with Same Instences,now i want to stop sqlserver...


Hi Sarma,

If it is the single instance, SQL server service is registered only once. Please remove and reinstall with named instance.

Warm Regards,
Abhay Pujari

Dec 11, 2014 | Microsoft Computers & Internet

4 Answers

Is it good idea to repair sql file?


Bulk Logged will not help you in this situation. Your transaction log is growing because you are performing large transactions. In simple mode, the log is truncated after a checkpoint.
Check these site: http://www.sql.recoverytoolbox.com/ & download demo Recovery Toolbox for SQL Server.
Depending on how you are loading your data, you may need to break it up into smaller chunks. Make sure you are not loading all the data in one large transaction.
Read more: http://www.filerepairforum.com/forum/microsoft/microsoft-aa/sql-server/380-is-it-good-idea-to-change-simple-recover-model-into-bulk-logged-on-etl-system

Nov 06, 2014 | Microsoft SQL Server 2005 Standard Edition

4 Answers

Hay Bahratt, I have uninstalled the 3 SQL programs in the control panel a few times with no effect on the issue. I didn't try moving directory C:\Program Files\Microsoft SQL Server\MSSQL to another...


If you have removed it from control panel, its done. You just have to clean up any left over registry entries using CCleaner and then try installing again
http://www.ccleaner.com/download
You may also want to check out this microsoft link if it doesn;t work
http://office.microsoft.com/en-us/help/HP011128601033.aspx

Jan 10, 2010 | Computers & Internet

1 Answer

How to configure the sql server 2005


Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition loadTOCNode(2, 'moreinformation'); You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:
  1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
  2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
  3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

    Note Click OK when you receive the following message:Changes to Connection Settings will not take effect until you restart the Database Engine service.
  4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Feb 28, 2009 | Microsoft Visual Studio 2005 Professional...

1 Answer

Replication


You need to either use a Domain Account if you are using Windows authentication or you need to use SQL server authentication.
The reason for this is because the user account that you are using only exists on the machine that you are on not on the machine that you will be replicating to.

Sep 24, 2007 | Microsoft SQL Server Standard Edition for...

1 Answer

SQL server won't work on my laptop


Two ways to access your server. First, make sure the SQL Server Service is running. Start | Run | Services.msc | Enter. Look for Microsoft SQL Server Service and that it's running. Or Look for the SQL Service Broker icon by the clock and see that it's running. The default instance of SQL Server uses the Hostname. Start | Run | Cmd | Enter. The type hostname. This will be the name to access to server. Then type IPCONFIG, this is then the IP address that you could also use to access it.

SQL Server runs on port 1433, so any firewall has to have it open.

Open Query Analyzer, type in the hostname or ip of the local box, type in "sa" and the password for sa (if setup in mixed mode) or Windows Authentication.

Once you login in, you should now see the databases in the Tree on the left side under the Server | Databases node.

Your description though states "SQL Server won't work on my laptop". TO answer this, the only two SQL Editions that work on anything other than "SERVER" software is SQL Professional and SQL Developer. All others have to be on a "SERVER" platform.

Aug 30, 2007 | Microsoft SQL Server 2000 Standard Edition...

Not finding what you are looking for?
Televison & Video Logo

Related Topics:

261 people viewed this question

Ask a Question

Usually answered in minutes!

Top Televison & Video Experts

The Knight
The Knight

Level 3 Expert

71182 Answers

Electro Med Services...
Electro Med Services...

Level 3 Expert

6694 Answers

yadayada
yadayada

Level 3 Expert

66744 Answers

Are you a Televison and Video Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...