1. What is statistics and how to see statistics through command ?

Also how to update statistics and when to update statistics also let me know if any one...

Set the database in simple recovery mode. and increase the restricted size of log file. So that can accumulate the transaction log. If possible try to breakdown your copy transaction...

I don't think that you can find this AD group details in SQl server.

So,if we have a s.p in DBO schema, then can't we have the S.P with the same name in different schema?

Yes, You can create it but in reverse if you...

Welcome !!:-)

Here is a simple query.

SELECT *

FROM msdb.dbo.sysmail_account a

JOIN msdb.dbo.sysmail_server s

ON a.account_id = s.account_id

JOIN msdb.dbo.sysmail_servertype st

ON st.servertype = s.servertype

http://msdn.microsoft.com/en-us/library/ms177580(v=sql.100).aspx

1. When we are using backup strategy or maintenance plan strategy then at that time how do we come know that our database is failure or success ?

-You can...

Best practices for SQL Server service accounts

•Use a specific user account or domain account rather than a shared account for SQL Server services.

•Use a separate account for each service.

•Do not...

Do you want to do this for high availability or anything else? Can you please

put...

Yes , you can create 2 Strored procedure with same name in two different schema. but not in dbo schema.

This below command should execute perfectly. what error you are getting.

exec...

Have you installed Sql Server 2005 SP2 on 64 Bit?

Check this link.

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

Here are the scripts.:-)

http://www.sqlservercentral.com/scripts/31541/

http://www.sqlservercentral.com/scripts/63620/

http://www.sqlservercentral.com/scripts/63620/

To see how much percentage of your backup is done , you can use this.

Find out SPID and pass it here

select percent_complete

from sys.dm_exec_requests

where session_id = 74

Select last_log_backup_lsn from

sys.database_recovery_status where datbase_id=db_id('dbname')

if its null then No log backup exists

Same issue

http://www.sqlservercentral.com/Forums/Topic937194-146-1.aspx#bm937206