Hi Iam running a job on SQL Server 2005 which executes an SSIS Package which sources data from SQL Server 2000 and deletes few records. The SQL Agent...
How can you enable publication to allow_initialize_with_backup as I am unable to find that property through sp_helppublication.The database is 8.0 at...
While creating the subscription using management studio there is an option to choose not to intialize the subscription which creates the subscription...
I am in the process of replicating SQL Server 2000 database running on a clustered server to a SQL Server 2005 for reporting purposes. I intend to...
When I am trying to configure distribution from the publisher to select another system as a remote distributor but it gives out an error that the...
During the process of creating the subscription the system expects a process account and password, I have used my normal windows account but I am...
thanks its working now
I get the error following error when I try to define the distributor at the publisherLogin failed for user 'distributor_admin'. I could not find a...
While configuring the distributor i get the following message : Property LoginSecure cannot be changed or read after a connection string has been...
Can you please explain this further?
Hi My requirement is as follows: We have clustered Servers and want to replicate data for reporting purposes. We would like to use the subscriber as...
could u plz advise as to why this is not recommended in production environment.
I have been advised to change the recovery mode to bulk logged when running dbcc dbreindex. I have a backup sequence in place. Will this effect my...
I was advised to change the recovery mode to bulk logged mode from full recovery mode when running dbcc dbreindex. I have a backup sequence in place...
this does not provide me a listing of table level permissions assigned to all the logins in all databases. Could you plz help me
Separate names with a comma.
