Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compare all table records in 2 Databases
Message
 
 
To
12/10/2009 06:18:35
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01428886
Message ID:
01463340
Views:
41
>Don't you think that it is an overkill for a simple job. I would simply use a T-SQL like this:
>
>
select object_name(si.id),si.rowcnt from [sys].[sysindexes] si
>	inner join [sys].[tables] st
>		ON si.id = st.[object_id]
>	where si.indid<2 and st.is_ms_shipped = 0
>      order by object_name(si.id)
>
>Cetin

Is it only for tables having indexes?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform