Need to check how they get created.

You can edit the registry key for the SQLAgent and MSSQLSErver to make then depends but be careful when editing registry keys.

No problems would incur if you have the application also setup at the DR site so that the application can be brought up along with the DB.

There is a third-party tool tool that can do these for you. Check for tools in sites like quest or red-gate they have plenty of tools and cn be used with...

This necessary need not be a hacking issue. Before you confirm one such can you check if any other services are running under that account or any jobs are configured...

As what Jeff says you can shrink the data file only if the data file has more than 25% of space free. But there is no problem in shrinking the...

Script out the logins and the use that to create the logins there in the destination server. Then you can use the sp_change_users_login 'auto_fix','username' proceudre to sync the logins in...

sp_helpindex 'indexname' should give you the details of the index and index keys.

Does this user able to see and access the databases from QA? is it taking time to load the databases and giving an error or does it fire the error...

Below links should be useful for you.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en 

SQL Server 2005 upgrade manual. (This document can be used as a guide to proceed with...

Do you have a maintenance plan to backup this database if so there is a option to remove unused space in the database in that plan. Else you should script...

It would be the default user in the computer account. Did you remove builtin\administrators from your sql server logins.

Did you check for the SET AS USER command din't that help you anyways. Anyways giving xp_cmdshell execute permission is quite dangerous on looking at the operations that the command...

Robert I agree. Snapshot are available with only Enterprise and Developer Editions. Sorry for the wrong post.

You can use DBCC SQLPERF(logspace) to check what is the size of the log file and how much is actually being used. So that you can plan and shrink the...