Hi,

1. Repeat: try to search before open a new topic 🙂

2. Anyway: If the question is the FILEGROWTH parameter of the data and log files then the answer is quite...

Amit,

If you want to simply add an identity column to your table which will be replicated then you can easily do it with sp_repladdcolumn, however, the subscriptions need reinitializing. Issue...

Hi,

Try transactional replication with updatable subscriptions. Check in both immediate and queued updates during creation so in case of a connectivity issue branches can use their local data. In this...

Hi Dave,

How did you enable the auditing?

Hi,

Can you write a bit more about the architecture? It seems that you're replicationg into Oracle. Which version and what kind of replication?

-- Erik

My favourite game for PocketPC is Warring States, a freeware and not-too-complex Risk-like strategy game. I spent dozens of hours with it. This is why I wanted a PocketPC emulator...

Oliver,

It's basically impossible. The best you can do is to encrypt the database content and use this encrypted database from the application. However, I'm not sure now what kind of...

Hi,

As far as I know, it's not configurable, and it'll be in the copy destination directory with the name of the last restoring log backup file.

Viv,

Operating system error 112 is the 'no space on disk' as I recall. So check the permissions on that file if there's enough space. Log in to the server with...

Robert,

Do you know the sp_change_users_login SP? It'll be your good friend. This way you can fix this problem even without creating the logins in advance. I'm just guessing, but your...

Ok, I read the BOL again, and yes, they say that it does work. They even give an example of it. http://msdn2.microsoft.com/en-us/library/aa173551(SQL.80).aspx

Btw, it works very simple: when you...

LP,

What is the error message when you try to restore the transaction log in question? Probably somehow you missed some trans as George pointed out. This case you get an error...

Hi,

NTBackup uses VSS to create consistent file backup of your data files. Enter the following command on your server:

vssadmin list writers

. This will list the writers -and there's the...

Hi Hans,

Your plan should work. You don't need to cycle the subscription server in order to rename the database. Simply disconnect everyone, if they are too agressive then deny them,...

Hi,

Are they pull or push subscriptions?

In general you can change quite easily the publisher/distributor server name if it's the same. Use sp_addserver and sp_dropserver and modify the distribution agent jobs. In addition, you...