|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Data mismatch between publisher and subscriber Posted by Biju George at 3/14/2004 5:33:34 AM Hi Guys,
i am using sql server 2000(sp3) transactional replication
for reporting server.i found 4 additional records in a
table at subscriber.
i replicating only tables.
btw there are no errors in the log files.
any ideas?
Biju...more >>
Problem with Replication Posted by Atley at 3/13/2004 4:33:34 PM I keep getting an error when I try to set up a merge replication...
Cannot insert duplicate key row in object 'TRDFIL' with unique index
'ITRDFIL0'.
(Source: CMTSQL2 (Data source); Error number: 2601)
I can't seem to figure out how to prevent this from happening, any ideas on
what is not co...more >>
Requires Aliase Name Connect to Named Instance Posted by Dave at 3/11/2004 3:59:37 PM
I have two Windows 2000 Advanced server cluster servers
one for developement (DEV) and the other acceptance (ACC)
servers. These cluster servers are set up as
Active/Active. These servers are set up as a Primary
Process server (Node A) and Secondary Process server (Node
B). Several mon...more >>
Large user base Posted by Bon733 at 3/11/2004 12:17:08 PM If one database can be accessed by only one instance of SQL Server, how
would you configure SQL Server (and hardware) to work in a large user based
environment? Would you split the database off to two or more servers or
would you use a multi instance setup on a multi processor server?
...more >>
Requires Aliase Name Connect to Named Instance Posted by Dave at 3/11/2004 8:11:40 AM
I have two Windows 2000 Advanced server cluster servers
one for developement (DEV) and the other acceptance (ACC)
servers. These cluster servers are set up as
Active/Active. These servers are set up as a Primary
Process server (Node A) and Secondary Process server (Node
B). Several mon...more >>
sql 2000 install files with SP 3 built in? Posted by Steve Schofield at 3/10/2004 8:34:25 PM Is sql 2000 enterprise have a way to "slip stream" service pack updates like
we can do in windows os service packs install files? I hate having to
install sql 2000, then in a separate step install sp3a. Is there a version
or does sql 2000 come updated with all service packs included in the ins...more >>
Cluster / Replication Database Name Posted by Don at 3/10/2004 9:24:52 AM
I have a system that we are setting up that has a Windows
2000 Advanced server with a Cluster and SQL Server 2000
replication. The Cluster is set up as a Active/Active.
Should I use the same or different database name from the
replicated database?
When the failovers occurs will it be ...more >>
SQL database changes/updates Posted by Joe at 3/10/2004 6:40:03 AM I have been asked to implement a SQL server environment
with a HTML front end accessing SQL data. The data will
be accessed mostly to read, but some changes will be made
by clients. The server will need to be online
permanently, however there will need to be fairly regular
database updates...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Share File Resource Posted by Timi at 3/10/2004 4:36:08 AM I run a SQL2K SP4 on WIN2K Ad Server SP 3 in an active/active two node cluster configuration
node one hung and had to be rebooted
Cluster Log had the message belo
Cluster file sahre resource benthas failed a status check Error Code 64
Event Log had the messages below
The message in the Event ...more >>
MSDTC for w2k3 cluster fails to start Posted by rvuong1 at 3/9/2004 11:47:26 PM
I configured a w2k3 cluster and everything seems to work properly. W
are trying to add the MSDTC resource manually to the cluster group bu
the resource refuses to start. Here is the event we are getting in th
event log.
MS DTC setup failed to populate the shared cluster
registry. The DTC ...more >>
SQLServerAgent will not start for one node. Help Please Posted by Marc at 3/9/2004 7:41:35 PM Hi All
I am having problems with the SQL server Agent what the cluster fails over.
The Event log is logging an event 103 "SQLServerAgent could not be started
(reason: Unable to connect to server '(local)'; SQLServerAgent Cannot
start).
The SQLAGENT.OUT log file reads as follows:
2004-03-...more >>
Connecting to Virtual Server SQL 2000 Enterprise Posted by Tomas Nelson Reyes at 3/9/2004 9:49:05 AM I have a Cluster Server with SQL Srv. Enterprise 2000 +
last HF's installed. And i tray to connnect from an IIS
(ASP) to my Virtual Server and i get an error (Access
Denied), i read a lot of Articles from MS, but i don't
have a clear answer to my problem. The question is:
What is the difere...more >>
Recommended Setup Posted by Bon733 at 3/8/2004 8:56:08 PM We are looking into setting up a SQL Server system that will be used in a manufacturing environment (i.e. production runs, accounting). I would like to get an idea as to the design that would allow us to run two servers with SQL Server in order to produce the best response time. My goal is to have o...more >>
To Cluster or Not to Cluster Posted by Girish at 3/8/2004 3:01:12 PM To Cluster or Not to Cluster is the question folks. We want High avaiability. period
We would like to run a Four PeopleSoft Production databases on this *Clustered* Database Server. My Boss is asking me if we should go for it ? We will be investing atleast 70-80K on a indentical pair of servers. C...more >>
SQL Server 7.0 Cluster Failures Posted by Gary Hampson at 3/8/2004 1:03:30 PM Hey folks..
I have a SQL 7.0 sp3 Cluster (A\P) on NT 4.0 sp6a. We are running into an
issue where we will get the following errors and then SQL Server will stop
and restart automatically. The error is as follows:
Error: 17801, Severity: 17, State: 1
2004-03-08 11:56:13.96 ods Unknown...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |