|
|
|
April 2003 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 sqlcesa300.dll connection Posted by Doug Richardson at 10/6/2006 11:46:03 AM installed Sql Server 2005 Mobile Edition into an IIS6 virtual directory
security for Anonymous with a custom application pool
when configured to use a sql account name and password on the connection
string - everything works as expected.
however, if the connection string passed to sqlces...more >>
Replication and use of Remote Server Posted by LMK at 10/6/2006 7:54:01 AM When Replication is configured it creates a remote server connection. Can it
be configured to use Linked Server instead? Linked server seems to have all
the same capability as Remote Server (and more).
--
LMK...more >>
Guest account in the Distribution database Posted by Abraxas at 10/5/2006 2:50:22 PM Hi,
I noticed that the "guest" account gets created by default and assigned to
the Distribution database. We are using transactional replication with
updatable subscribers and anonymous subscriptions and need to be able to
remove the guest account from the distribution db.
- Is i...more >>
Merge Replication Schema Changes Posted by Zer0Day at 10/5/2006 2:11:02 PM We have three distinct environments that a databse resides in: a lab
environment, merge replicated with other lab servers, a production
environment, merge replicated with other production servers, and a
development environment not replicated anywhere. We do not want day-to-day
development ...more >>
SQL Client PC Replication Methods Posted by bob britton at 10/5/2006 1:55:48 PM With MSSQL2005, what technologies does MS provide to support an application
environment based upon a central server model replicating updateable data to
clients (XP)?
Imagine if you will having MSSQL2005 on the back end. Imagine, if you will,
having 300 PCs running a .Net app needing DB sto...more >>
Strange reoccuring problem - 'distributor_admin' is not defined as a remote login at the server Posted by rich NO[at]SPAM adgooroo.com at 10/5/2006 12:24:15 PM Hello everyone,
We set up replication yesterday and it runs beautifully ... once. After
the first replication, we get the following error whenever we try to
access any of the replication admin screens, with the exception of the
"disable replication" screen:
Error 18483: Could not connect to...more >>
set up Email notification when transaction repl fails? Posted by Rich at 10/5/2006 10:43:02 AM Hello,
The other day our ISP lost our mac address (or something) and we lost
internet access. Along with that came our transactional replication failure
as the publisher DB could not reach the subcriber DB. The internet
connection got resolved shortly afterwards, and no customer was compl...more >>
Good book about replication in SQL2k? Posted by andsm at 10/5/2006 9:31:03 AM I want to buy good book about replication in SQL2k. Mostly I interested in
transaction replication. Are any good books about it?
I know about book of Hilary Cotter "A Guide to SQL Server 2000 Transactional
and Snapshot Replication", from content it looks like it is what I need, but
the book ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Memory pressure Posted by stephanie at 10/5/2006 1:10:01 AM When I issue the command, sp_browsereplcmds, it returns
Msg 6513, Level 16, State 27, Procedure sp_browsereplcmds, Line 110
Failed to initialize the Common Language Runtime (CLR) v2.0.50727 due to
memory pressure. Please restart SQL server in Address Windowing Extensions
(AWE) mode to use CL...more >>
P2P replication Posted by Lalitha at 10/4/2006 10:52:01 PM Hi,
I understand that P2P replication does not do automatic conflict detection.
I do not have conflict scenarios in my application except for the following
single requirement:
For a test plan i will add cases and will give numbering like case 1, 2, 3,
4 etc.
Any new case added to a plan will ...more >>
msdb recreate cause replication problems Posted by renedevries NO[at]SPAM gmail.com at 10/4/2006 1:45:16 PM We just went through a nasty experience whereby we had to recreate the
MSDB database.
System is now back, but replication is completely messed up. Is there a
way to get all the MS* tables back, in the MSDB? I tried to de-install
and install Replication, but that doesn't seem to generate all th...more >>
I need help about two server configuration Posted by Guillermo Villanueva at 10/4/2006 12:59:45 PM Hello I have one sql server 2000 and one MSDE , I need a database replicated
in two servers, but I can't modify table structures.
I need to make data modifications in SQL Server and in MSDE, what type of
replication can I use ?
Thank you .
Guillermo
...more >>
Frequent Trans Log backups Vs Autogrow Posted by Methodology at 10/4/2006 7:55:01 AM Hi
Im doing some testing on mirroring at the moment, and have found out about
the inherent problems with transaction log size that thie replication
scenario entails. However I have found that frequent trans log backups are a
way around the problem - This sets the vast majority of VLFs in th...more >>
Transactional replication - update does not follow row filter rules Posted by ian.hingley NO[at]SPAM swiftlg.com at 10/4/2006 4:13:38 AM Hi
I have an issue where inserts follow row filter rules OK, but updates
and deletions don't seem to. I'm using transactional replication.
Let's assume we have a table called Customers with a simple row filter
of
SELECT <published_columns> FROM <<TABLE>> WHERE custkey > 1000
The snapshot...more >>
SQL 2005 Distribution DB not visable Posted by Andrew Copeland at 10/4/2006 12:40:31 AM Folks,
I have configured replication for SQL 2005 Enteprise Edition today and all
works fine but the Distribution DB is not shown in System Databases or User
Databases.
Is this by design because the old Task pad feature in SQL 2000 was great to
see if you have issues with the replication...more >>
Remote-Agent Activation Posted by paul.mu NO[at]SPAM gapbuster.com at 10/3/2006 11:09:53 PM Hi,
Two questions:
1. Not 100-percent sure about this, but it looks like for a
subscription configured with remote agent activation where the
destination owner for articles are not specified as dbo, during a
resync the articles at the subscriber can be owned by any login on the
subscriber. I...more >>
Problem with 1 Server in 3 Server Peer-To-Peer Posted by EoRaptor013 at 10/3/2006 3:33:09 PM Boss created a new table in a database in which most, but not all, of
the tables are part articles in a peer-to-peer publication. He claims,
and I have no reason to doubt, that he did not add his new table to the
list of articles in the publication. Nevertheless, the replication on
the one serve...more >>
Distribution times out... Posted by Query Builder at 10/3/2006 7:30:15 AM I have a transactional replication working fine till to date. I have
the publisher on ServerA and subscriber on ServerB. The transactional
replication is running fine...
I need to get a copy of the subscriber to another server and replicate
the Publisher to that serverC while the replication o...more >>
Merge replication - changes not populated to subscriber Posted by Roman at 10/3/2006 4:47:33 AM We use merge replication with SQL Server 2005 and SQL Server Mobile. In
one table changes at the publisher are not populated to the subscriber.
In this publication I have two articles which are linked with a foreign
key. The initial replication works but if I perform data changes
(updates) at th...more >>
truncate log file - mirroring (again) Posted by Methodology at 10/3/2006 4:18:02 AM look
what is the absolute gospel on this?
If I backup the DB, THEN can I truncate the log file of a Dbase thats being
mirrored? (running a backup now buts its going to take 4 hours and im
impatient). There MUST be some way to stop the log from growing infinitely,
surely? limiting the siz...more >>
Quick Question - Mirroring 'Spooler' device Posted by Methodology at 10/3/2006 3:29:01 AM Hi
what is it that actually holds and 'spools' the transaction changes to the
mirror server - the transaction log, or A.N. other?...more >>
Invalid Descriptor Index Posted by colinlr at 10/3/2006 3:08:01 AM I'm testing db to db transactional replication on a box ( all on the same box
) and the distribution agent fails with the above error. I know it's
something to do with the physical server as this test works on other servers
fine. SQL2k Ent sp4 on w2k3 ent sp1. ( clustered )
Server and Agen...more >>
Moving SQL Server installation (dbs, logins, replication, jobs, DTS etc) to new server Posted by Laurence Neville at 10/2/2006 10:48:31 PM I need to move an entire SQL Server installation (databases, logins,
replication, jobs, DTS etc) to a new physical server.
What method requires the least manual intervention? Ideally I would like to
not have to reenter user passwords, and the replication to pick up with the
remote SQL Serve...more >>
SQL Mirroring - Log file size management Posted by Methodology at 10/2/2006 7:58:03 AM Hi
I have two SQL servers in a mirror, and its working great - beats so many
shades of crp out of replication I cant believe it. Im not sure how I go
about managaing the size of my log files however.
I have a reindex that runs every week that creates a log of about 130 gig.
Getting this...more >>
Transactional Replication - filtering records in child depending on data in parent table Posted by ian.hingley NO[at]SPAM swiftlg.com at 10/2/2006 6:23:03 AM Hi.
I've set up transactional replication, distributing on a daily basis.
Let's pretend I have two related tables, customers and orders. I set up
a row filter on orders as follows:
SELECT <published_columns> FROM <<TABLE>> WHERE exists (
select * from customers where customers.verified=1 and
...more >>
Move Repliaction Posted by Samuel Shulman at 10/1/2006 12:00:00 AM Hi
I have 1 publisher that replicates well to to Server1 and doesn't replicate
well to Server2 I would like to simply move the database and the
Subscription from Server1 to Server2 (that will save me the initial phase of
the subscription of copying the database) (Push subscription)
Is th...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |