also you can use the set identity_insert to on to insert values to indentity columns

Check for the permissions. Check if the user has permissions to system tables in master database.

might be this link will be useful to you

http://www.querycat.com/faq/e55ef7cda2b6e9f152e5881a8efdbf10

No white papers on this but you can't you use profiler to track what is happening behind.

Now i understand that you have your CD containing the install files of SQL7 scratched. There are few tools on net that can be used to read CDs like those...

Any firewall, are you able to connect to the remote server using client machine

Do not run your sql services with local account unless there is nothing that you acccess on the network. mostly prepfer a domain account with needed permissions to run the...

Are you sure that the log file is just a GB and the backup is 2Gb in size this can't be just check with perfmon what is happening also you...

SO do you mean to say that you are appending data to the same backup file daily. if so then the size might increase as you find.

Karthick i hope i have messaged you the details and that was helpful.

You need not have xp_cmdshell enabled. You need to run that from the DOS and not from sql server.

put all those as a batch script and call the batch script...

If you do not need a service i have a program of server side tracing also i can send that too.

i have a same requirement and i have written a service to track all these send me your id i shall send the code to you.

You need to check the SPN name of the server. There might be multiple occurences of the same account. Search for setspn.exe in microsoft site you will have the details...

Is it win2003 try using Kerberos authentication method instead of NTLM.