In the SQL Server Mgt Studio, I can look up the database property 'Last Database Backup', which gives the date and time the DB was last backed up. I would like to access that info from within my VB 2005 program. What commands would I use? -- Ed...more >>

Hi, I use a transactional replication and sometimes I realize that all or some tables at subscriber are empty but the agent history don't log any error message. All the informations at the publisher is ok. This morning, I looked to the data at 10AM and all was fine but an hour after some ta...more >>

I want to implement merge replication between SQL Server 2005 and SQL Server 2005 express. My problem is, when we make table schema changes like adding and removing columns, we drop and re-create the table. Is there any way that this methodology can work with merge replication. I know the repl...more >>

Hi all, we have a complicated merge replication/trigger problem. Ill try to explain the setup first... We have 2 SQL Server 2005 servers (called Server1 and Server2 for this example) On each Server there is an identical database (called SalesData for this example) which contains 2 related t...more >>

=DA=E4=CF=EC Server 1 SQL 2000 (SP4) Distributor, Publisher Server 2 SQL 2000 (SP4) Subscriber Transactional Replication set up between Server 1 and 2. All the agents are running successfully (Log Reader, Snapshot, Other Miscellenaous agent...except the Distribution Clean Up Agent =CA=DA...more >>

I've read some varying opinions on this topic.... Is it a best practice to stop replicating a database during a = maintenance window that is doing reindexing? What is the effect of stopping / not stopping the distribution agent? --=20 JUDE...more >>

Hi, My distribution agent failed reporting, "The agent is suspect. No response within the last 10 minutes". I caught this error a few days later and have also discovered that the log reader agent is not visible anymore. Please help. TIA....more >>

I am using P2P replication between two server. I face a big issue in manual identity management. I did as follows Step 1: Built MyDB1 with data in server1. Step 2:Set up Server1 MyDB1 as Publisher (Followed msdn white paper p2ptranrepl.doc) Step 3:Took backup of MyDB1 in Server1 and restore...more >>

Hi, I am working in the SQL Server 2000 and Share Point Portal Server; we are maintaining the SQL Backup for all the sites, one of the users has deleted accidentally a document library from a particular site. Can you please help me in restoring the particular document library from the SQ...more >>

I need to detect whether or not a database is being replicated. I need to do this in a script and use the results in an IF statement. Is the best way to do this by checking the value of category in the sysdatabases table? Something like this … IF EXISTS (SELECT * FROM sysdatabases WHER...more >>

My server is running SQL 2005 and I'm getting an odd replication error that I need some help with. The error is from the Snapshot SQL Agent job and it says "A required privilege is not held by the client." when I try to run it. The security log on my server records that the "Run As" account ...more >>

We have two servers participating in transactional replication (SQL 2000). The source server is also the distributor. The destination server is getting a push subscription. When replication was initially setup we let SQL server do the initial snapshot and syncing. We now need to update s...more >>

Hi, We are developing SQL Server Merge replication. We have one publisher at our head office and 30 subscriber at different locations. Our publication server name is PUBLICATIONSERVER. And all off our subscriber have same name: SUBSCRIBERSERVER. We can't change subscribers server nam...more >>

When I need to add columns to my publisher in a transactional replication I use the sp_repladdcolumn. How do I Alter a column with no need to stop and recreate the replication??? ...more >>

A while ago we setup transactional repliction between a couple of our servers. The server that was the subscriber has now been moved to do other things (but still has the same name, and a copy of sql server installed). I cant delete the publiction of the publiction server, or try and setup ...more >>

Hello, do you know defined performance differences between SQL 2000 and SQL 2005? thanks in advance ...more >>

Hello, i have a filtered merge replication with a few subscribers operative (SQL 2005). If i insert in a certain runtime about 50k to 80k entrys in a table, after this it gets awful slowly. One insert takes about 7 and more seconds (before, it took less than one second). I think it has somethin...more >>

Hello As our customers use our product often offline, we implemted a sql server 2000 merge replication with msde anonymous subscribers. With the new product release go some schemachanges, which we implemted with sp_repladdcolumn and sp_repldropcolumn (e.g." exec sp_repldropcolumn @source_obj...more >>

Hi, Our replication topology (currently in design) will use transactional replication to replicate from a OLTP server (publisher) to a Reporting server (subscriber) in hope of near realtime results. Not all of the tables require this though and the plan would be to use snapshot replication...more >>

I have a setup where I merge several databases over the web via merge replication. The odd thing is that there is one database that is taking an enormous amount of time, while the others are fine. For example: the slow database is taking almost an hour to merge 2700 rows, while one of the oth...more >>

Hi, I am seeing the following error when I try to sync my PDA to the server. "error -2147198698 Message : The snapshot for this publication has become obsolete. The snapshot agent needs to be run again before the subscription can be synchronized" I have 5 PDAs that sync fine to the ...more >>

I have the intention to move SQLserver (used with dynamic merge replication, also distributor) from an old server to a new one. Can I copy all the files to the new server without reconfiguration? ...more >>