I use custom log shipping on my servers...

YOu can use the following...

http://www.sqlservercentral.com/columnists/ckempster/customlogshipping.asp

sysobjvalues table is system table and I don't think you can do anything against this in 2005 because you can access directly system tables in 2005.

I think you access the...

Login might be expired...

Check the login properties...

Did you test the database mail first before using in TRIGGER?

If trigger is not working properly then transaction will be left open..

you don't need to restart the sql to close...

It uses full scan mean 100%...

you can with DBCC SHOW_STATISTICS command in your output check for ROWS and ROWS SAMPLED columns to get the info...

Nothing to worry...in many forums this one discussed..

As you know sql server uses time from OS so as long as os got the patch sql should be fine.

Note: I heard...

I have not used it so for... but based on the size it should not be a problem.

If there is any datatype changing will not take much time due to...

For cleanup you can follow the following KB article...

How to uninstall an instance of SQL Server 2005 manually

http://support.microsoft.com/kb/909967

May by want to use SQL authentication

Might be your Maintenance plan has the option to repair the db incase of corruption..

Please remove it because SQL server tries bring bring the db in single user mode...when it...

When you are using doubel quotes you have to SET QUOTED_IDENTIFIER OFF....

set quoted_identifier off

select ("master..xp_ss_backup "+@lvDBName+" TO DISK = '\\"+@lvNTServerName+"\Backup$\"+@lvDBName+"\"+@lvSQLServerName+"_"+@lvDBName+"_DBBackup.BAK WITH DESCRIPTION = 'Database', INIT, STATS = 10")

You can use replication or custom log shipping (backup/restore)...

You can restore the publisher db onto subscriber or you can copy the required tables to subscriber first when you create subscriber specify that the subscriber has schema and data...

All in one tool called SQL Server Management Studion (SSMS).

You can install Express but it has some limitations... it will not have sql agent, MPs, etc..

For practive and learning purpose...