Minaz Amin (2/15/2015)

---

In my replication R1 and R2 and R3 , I am not able to reinitialize as R1 and R2 act as both publisher and subscriber.

How do I...

Yes I have come across this myself and really there are only two ways around it.

1. Rebooting the SQL instance which normally clears those old tempDB files from the...

DBCC FREESESSIONCACHE removes all queries from the distributed query cache. This however does not impact anything in the standard procedure cache, to clear the standard procedure cache use DBCC FreeProcCache...

Do you have any other linked servers setup on this server?

Setup linked servers. Had to run the following command to enable data access between systems to get linked servers working...

So I convinced them to do something like this: http://www.mssqltips.com/sqlservertip/2085/sql-server-ddl-triggers-to-track-all-database-changes/ Copy the updates to an audit table, then do a sql agent job to copy that ?...

They simply want it for change tracking only.

Hey thanks for your input. I just passed your post onto that developer and I'll see what they say. You make some very good points.

Linked servers are already setup between these two SQL servers. What they want is when it's updated on production, it gets updated on Development as well.

I also have a need for previous week. How would I go about editting this code?

where event_time >= curdate() - INTERVAL DAYOFWEEK(curdate())+6 DAY

AND event_time < curdate() - INTERVAL DAYOFWEEK(curdate())-1...

Luis Cazares (1/7/2015)

---

For previous month, according to the first result on Google, would be using the following clause.

SELECT * INTO #Wrap

FROM OPENQUERY( Shoretel_Ccir, 'SELECT e.g_event_id,wc.w_name,e.event_id,ep.agent_id,

a.a_name,et.event_name,g.g_name,e.event_time,rc.rc_name,month(e.event_time) as ''Month'',YEAR(e.event_time)...

I tried this and ran the report and it came back with this..

An error occurred during the local report processing. Query execution failed for dataset 'DataSet1' Cannot get...

I did try this, but it still just gave me the same month's data.