i think SQL 2012 introduced shared datasources in SSRS

How the user is connecting and what permission does the login has.

[quote-0The way I am trying to do it is to go to a specific dataset and on the parameters tab choose the parameter and do as example below:

=Parameters!Period.Value-3

[/quote-0]

This is...

in dataset check what is showing in parameter section and see the mapping

you may get the problem.

and what is the exact error you are getting.

It should work, can you check in dataset how is parameter mapped.

No data scripting is not available in 2005. Other scripting are available in 2005, sorry for miscommunication

Apply the closing parenthesis in the '

EXEC msdb.dbo.sp_add_job @job_name=N' + dbo.quotestring(' + @DatabasenameInput + '- backup Job') + ',

try this... but what is "quotestring".

What do you mean by this - "developers who login from their applications to run DML...

Do you mean to say in production DB user's have write access other that DBA?

Are there no other statement other that PROCCHILD and FUNCTIONCHILD in PROCPARENT?

and when you manually failover again is it going back to the previous master.

we have a DBA Group, reader group and windows apps user account , do you need anything more than this

any new DB added to the backup list witout full backup?

Mehernosh (8/8/2013)

If this helps - you can script the database items using the Generate Scripts option for your selected database.

[p]

1. Right click on your database in SSMS, select...