all groups > sql server dts > july 2007 >
You're in the

sql server dts

group:

Copy SQL Server Objects Task Properties


Copy SQL Server Objects Task Properties Q
7/10/2007 3:40:00 PM
sql server dts:
Hello

I am using Copy SQL Server Objects Task to copy tables and data from SQL
server 1 to SQL server2, replacing the tables and data in SQL server2. Is
there a way to automatically check if all the tables I am copying in SQL
server1 have data before copying?

Thanks,

RE: Copy SQL Server Objects Task Properties Paul Ibison
7/11/2007 1:28:01 AM
Not automatically. You could use sysindexes to get the data quickly and store
it in a global variable. DBCC UPDATEUSAGE would be run first and this is not
guaranteed to be 100% accurate. Count(*) with nolock hint is an accurate but
more time-consuming alternative.
HTH,
AddThis Social Bookmark Button