First check the same query on the server side SSMS(SQL Server Management Studio)

if resposnse is good then check the query on the client side with the SSMS(SQL Server Management...

Give SQL Server Agent service account rights to access the particular file on the Server

you can configure multiple email accounts on SQL Server Database Mail and then send emails with different email account at a time

How much database size ? best way is to take a backup and then restore on another server

you have to define the sharing path of the source database files as...

check SQL Server services account ,these service accounts have administrative rights

yes this report also available at the same process which one i have mentioned in the previous answer

Machine is Server Class or Desktop Class ? watch your RAM continously and check twice at which level OS restart it , if at the same level then RAM is...

check the SQL Server instance and agent service account are enable or these service accounts have administrative rights or not ?

Thats why I was asking about database purpose or load on it, check it my second statement with question mark if you guys can see

you have to use SQLCMD for multiple scripts

SQLCMD syntax

sqlcmd -s ipaddress or DNSname -U username -P password -i "f:\script\executor.sql" -o "f:\script\output.txt"

open notepad and write this command as your requirement...

For Resource Governor information

http://msdn.microsoft.com/en-us/library/bb933866.aspx

Example

CREATE FUNCTION My_Classifer_func()

RETURNS SYSNAME WITH SCHEMABINDING

BEGIN

--workload definition based on login names

DECLARE @WorkLoadName sysname

IF SUSER_SNAME()= 'admin'

BEGIN

SET @WorkLoadName='AdminUsers';

END

--workload definition based...

SELECT create_date

FROM sys.databases

WHERE name='tempdb';

you can check with Tempdb because tempdb recreate when SQL Server service started and then create a sample table with datetime column only and schedule it on...

Just right click on the Instance and then generate the SCHEMA CHANGES Report as shown in the figures

Do you have any changes in the backup plan like TAPE backup running at the time of your maintenance plan ?

Check the Schedule time of Backup and Maintenance plan job...

Your autogrow increment must be large enough to avoid the performance penalties.The exact value to use in your configuration setting and the choice between a percentage growth and a specific...