About 5 and a half hours. Was a firewall log monitoring all pcs information about internet.

-

Lic. Andrés M. Aiello

DBA MSSQL - Oracle

http://aiellodba.blogspot.com/

if you don't know structure you can use this:

SELECT * INTO NewTable

FROM cdc.dbo_OldTable_CT

-

Lic. Andrés M. Aiello

DBA MSSQL - Oracle

http://aiellodba.blogspot.com/

SSIS have no problem with large files. I use it to import cvs files about 7G every day (6 millions rows) and have no problem.

-

Lic. Andrés M. Aiello

DBA MSSQL -...

yes.

-

Lic. Andrés M. Aiello

DBA MSSQL - Oracle

http://aiellodba.blogspot.com/

Use WITH ENCRIPTION option, but remember that can wach it by profile if the user set stmnt watch. Another problem is scripting, because you can not encript scripts, only compiled...

Remember that select define execution plan, soo order by can change. That's way you need to put it in select statment.

-

Lic. Andrés M. Aiello

DBA MSSQL - Oracle

http://aiellodba.blogspot.com/

and you have that OR problem, with that you will also do scan. I suggest, if it's possible, to change app and set a checkbox to filter "exactly, start like,...

that's a very commun escenario. You need to save data in other table before disable cdc. Last year I have that problem and I give to user a view, and...

ps: I love your signature jajaj

sorry, you're right! I will edit the post.

Thanks!!