I think the problem is with your copy job:

Why not try this:

1. from the primary create a logshipping folder

2. Have a job to copy current tran log to this folder,...

Thanks for your suggestion.

Someone also suggested counting number of characters per row and multiply by the number of rows from the largest table. Wonder if this can work considering white...

Ok, i understand your point. These servers have different sysadmin accounts and these are provided in a connection string.

So this script would be able to login to these servers via...

But i want a script that can read from a list of servers..say i have these servers listed in a text file, and adds the required login, instead of doing...

Well, i figured out the solution. Just created an alias on the client server and i am good to go

Thanks for the responces..but at least a suggestion would have been ok.

Thanks for your responce.

The reason why I asked is because i have already gone through two interviews with a pannel of four people and the interview covered everything about SQL...

very clear, thanks a lot!

Am going to answer my own question, i think i got what i was looking for here

http://www.microsoft.com/downloads/details.aspx?FamilyID=531c53e7-8a2a-4375-8f2f-5d799aa67b5c&displaylang=en

PowerShell will be the easiest way out..use WMI, Win32_NTdomain class..

USe PowerShell to read from the directory..

At the same time, primary key creates the clustered index automatically if no clustered index already exists