I haven't done anything yet. I was planning on doing the drop server this weekend for the 100dw01-new. I don't think it should hurt anything because there is no alias...

this is the error i get

ah, that's right. I pulled the code from something i wrote on a sql server 2016 ent server. I forgot about that. That's going to be a problem for me....

sorry, i was looking in the wrong folder. It's in C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio

sorry, i should have specified. Each view that u see is querying mysql using linked server w/ open query. It does a select * from each mysql table

there is no order by and the actual select that is called is below. For some reason when the "top" clause is added it never completes. It may actually finish...

unless i'm missing something it appears "change data capture" would do what i need. We're going to be building this in sql server 2016

i suppose it will have to

is there a wat to get the value of the data change?

it was rebooted 5 months ago. So when you say wrap around are u speaking of just the that column or all of them? Also, i assume when u say...

when I run the SELECT * FROM sys.dm_io_virtual_file_stats (NULL, NULL);

The "sample_ms" which from what I understand is the MS since last restart. It's showing 480 hours ago which impossible. The...

98 db's in full recovery. all 98 have full backup every sunday night. 17 of these databases have their trans logs being backud up every 3 hours. All 98 db's...