The subscription option will come on SSRS web site after the report is deployed on the server.

You will have to deploy and the browse the report to have the Subscription...

Sure!

When you create a subscription for a report you will have to give the following information:

1. How to send the Report (Report Server E-mai/(one more option is there)).

2. Whom to...

Forgot to mention that you can send offline Excel/PDF files through subscriptions.

You can try the Subscription options available in SSRS.

- Open the report.

- Go to Subscriptions

- Select 'New Subscriptions' OR 'New Datadriven Subscriptions'

- It will show you a step by step...

Did you used a query like:

Select * from sys.sysobjects where name = 'MSmerge_PAL_role'

?

try the same query on master DB also and check if the object is present in master....

Also, verify the INSERT query that gets fired on click of Submit button; you should use the name of the columns in the query

INSERT INTO yourtable

(col1, col2,.....) -- dont...

Yes you can achieve this using PIVOT!!

Check out the BASIC example given in the following link:

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

-Do you have any backups available with you before the delete?

-What is the recovery model of your database?

I don't think that is possible using different schedules for different packages, the solution that comes to my mind is something like this:

1. Create a table in your DB(MontlyPackageStatus) with...

Database mails are not available in Express edition.

The message "Run the RECONFIGURE statement to install" came from the first SQL statement "sp_configure 'clr enabled', 1".

As you are already executing the "RECONFIGURE" command just after the ...

Could be a security issue? Can you post the errors from the log/application event log?

sp_help_jobschedule

Try dropping the indexes before inserting and recreate the indexes after insert

and insert using Select unionall option

Yes! below query will perform better as this will be bulk insert

Insert into Table_name (columns...)

select value1,value2....

union all

select value1,value2....

union all

select value1,value2....