Thanks for your replies. Database in queston is already in Simple recovery mode. Unfortunately at this point of time , management has no plan for...
This is related to SQL Server 2005 Enterprise edition. One of the database log file is 100 % full and its log_reuse_wait_desc = CHECKPOINT ( from...
Hello, I have implemented partitioning for the first time. Requirement is to have partition by weeks. So each partition have around 25 million rows...
On the remote servers users who belong to their windows group , can easily log into the server , but the problem comes when these people ( who belong...
Moderator / Gurus , Any help regarding this issue. Thanks
I am trying to add windows group ( MYDomainlogin) to the Linked Server security page, but when I click add --> then browse to find the windows group...
Do you have any links to articles or samples ; that would be very helpful. Thanks for your help.
As we want to do this only once, for this we do not want to create triggers for this prupose. Is there a way Profiler or DMV's can help ?
One of my colleague wanted to know , how often changes are performed against Table_A, Table_B , Table_C in production. Here are some more details ,...
I have a scenario wherein I have to combine two columns into one . Its SQL Server 2005 Below is the example : CREATE TABLE Table_Source (...
As our publications size is huge , we cannot generate snapshot agent. So to avoid this , we configured our subscriptions to use "REPLICATION SUPPORT...
This is SQL Server 2005 Transactional replication configuraiton. I am modifying the table schema at publisher by adding addtional columns on...
I would like to do inserts into my destination tabel in chunk of 5000 rows at a time because source table can have milions of rows and I dont want to...
Hi all, 1) If I dont want 'Delete' statements to propagate to subcriber.........What needs to be done, when creating new publication (or) modifying...
All~, Is it true that , if a subscription is created with parameter @sync_type = N'replication support only' , then even if we generate a new...
Hi All, I configured Transactional replication on my staging server and will be configuring transactional replication on Production as well. I...
These steps might help : Workaround : Update the location that is saved in the value of the LastUsedSource registry entry 1. Click Start, click...
Satya & All, This is sngle instance. I tried the KBA before starting this thread. I did following actions earlier: In order to resolve the above...
Mohammed, Here are two log files from : (1) Summary log file (2) Hotfix log file: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfix...
Separate names with a comma.
