Hello Experts, From past few days the Log reader agent of one of my databases(Simple Recover) is scanning the transaction log records and replication...
Hi Experts, I have a table which stores domain and its url s .All the urls in the table are distinct.I have a column which stores md5 hash of that...
The most simplest thing you could do is declare a variable @end_date , set it to next day DECLARE @end_date DATETIME SET @end_date= @start_date+1...
Hi Ksr39 What is your interval to delete the log files on primary?.The default is delete files which are older than 72 hrs. I had a similar problem...
Thanks For the reply 1. Update statistics + Rebuild indexes in particular more these 2 tables "Sometable" and "Table_a" and check again… I...
I have table say table_A having many columns and millions of rows.There are two columns customerid,date on which index is created.I have a procedure...
Recently I created a partitioned table having day wise partition.I populated the table with some dummy data for 2-3 days.As I was testing I truncated...
Hi If your transaction servers are DB servers then you can replicate your transaction s on that DB server ie the process( or code ) which retireves...
Hi in order to find out which procedures or functions contains the 'TEST.dbo' you can use below queries. SELECT routine_name,routine_type FROM...
Some of the errors are related to corruption in system tables http://www.sqlservercentral.com/articles/Corruption/65804/ Hope this helps.
Thanks David for the reply.I guess its a network issue because the job is sometimes succesfully executed and log files are getting copied.As you...
I had configured logshipping on our production databases.And all the jobs(restore/copy/backup/alert) were running fine on both primary and secondary...
Recently I encountered this wait type on our production servers.The command column in sys.processes was KILLED/ROLLBACK.And this process was blocking...
Hii I was just reading an article about DDL triggers on MSDN. I created a trigger on my test server CREATE TRIGGER DDL_TRIGGER_1 ON DATABASE FOR...
Hii , I have been reading about contained databases on MSDN and I read on Aaron Bertands blog that you can connect to contained database by creating...
Hey can u set the replication using TSQL . Because i have encountered such kind of problems when i had set replication using GUI.
hii I have been reading about Autotruncate mode in SQL server. I found that SQL server truncates the log in 2 conditions. 1)When recovery model is...
hey i am just taking the result set of ExecuteSQL task in a object variable. And in ForEachLoop--->For Each ADO enumerator im reading that object...
Hey hii thanks for a quick reply. I solved my problem by creating a new useraccount and password. And its working fine now with the above process....
Hii I have a requirement in which files will get copied from various FTP location s.The problem is my FTP servername/username and password are...
Separate names with a comma.
