Thanks, it works. I ran it for rebuild index.

In order to find out what exactly column and row don't get inserted, add an option Errorfile = 'C:\folder\file.txt'

Thanks, Lowell, but I found slightly different file names.

2005: ....Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\1033\SqlWb.CTM

2008: ....Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\1033\ssms.CTM

But modified timestamps for them look too old: 2005 is for March, and 2008...

This is not a new question . He actually replied to original post question which is "Common questions asked in SQL Server DBA..."

Thanks, Craig.

This is summary by rows.

Unioning to the datasource will bring me summary by columns ?

This is a great resorce for replication, it explains everything what's going on inside of replication mechanism:

http://books.google.com/books?id=ezb61gAFkBQC&printsec=frontcover&dq=sujoy+paul&source=bl&ots=2Biftplu1H&sig=K458S-5eandNdwiu9iVGMG6Mjbk&hl=en&ei=XfeYTNKcCoLGlQftg8kt&sa=X&oi=book_result&ct=result&resnum=3&ved=0CA4Q6AEwAg#v=onepage&q&f=false

Hi Jack, I am also interested in this great script, but in my case I need it for tables, stored procedures and indexes. Should I change anything in this script...

You can also implement CDC - change data capture. It will write all changes (updates, delets, inserts) to another table.

Why do you have to care about company money? Go and enjoy it !

I am more in this industry than you, but unfortunately I have never been on this...

That's a good question. Actually that exercise was like a "rehearsal" before deployment to production. There were too many errors, so we ran same things until install became clean.

Once...

I probably found even better solution. Sinse these tables initially clean in destination, I created 2 scripts in SSMS: tables and F.K., then I dropped all tables, ran script that...

Hmmm...

There are 38 tables, they are all from same schema. I created a cursor to script insert /select against source database. Putting them in correct order would be rather...

But unfortunately, we are not given APTER TRACE permissions.

The whole reason is that we cannot use xp_cmdshell in production.

Thanks a lot !

So the main point that I did not know about is:

DBCC SHRINKFILE (Test1data, EMPTYFILE);

Everything else worked well after executing this. Thanks