Thank you Gila monster. It worked.

Thanks a lot Eugene, it's working.

Yes, i understand this is SQL forum. Can you suggest a good DOS forum pls.

Super !. Thanks a lot John.

Thanks, but sorry i am not confortable with T-SQL coding. Can you please show me how to write the looping logic.

Thanks for the overwhelming response and i am really thrilled to see so many responses, but sorry a small correction here (and a big relief for those who are still...

Actually over the couple of years, the db size has grown from few tens of GBs to such a huge size. At the time of design, we have kept the...

Msg 102, Level 15, State 1, Procedure InsertRows_MT, Line 29

Incorrect syntax near 'END'.

The editor is pointing the error at the last 'END' statement.

No, i am running the osql from same machine where SQL Server is installed.

Yes, but i have to write an automated script that would add BUILTIN\Administrators to the SQL Server Logins. And this script is run by Local administrator.

All are enabled. I could log in to Management studio using the same account without any problem.

I used the following command after logging into windows machine as local administrator.

osql -SstrMachineName -UstrLogin -PstrPwd -i addsys.sql -ooutput.txt

(strLogin is an account which has login rights to SQL Server along...

Hi Sergey, thanks a lot !

But when i delete the database, i guess the action should delete all related entries in msdb as well. Is there any logical reason behind non-deletion ? Otherwise, msdb would...

So, what in case if the primary fails and no one is around to monitor this ? You mean there should be DBA who should be sitting and constantly watching...

What is a tail log ? I believe all the logs (.trn files) are being copied over to secondary server instantly. Sorry if it is silly question, but i am...