I don't know if it's deliberate or not but typically for your own management type of application they encourage the use of SMO since that's what it was designed for....

junk.mail291276 (9/13/2016)

---

That works in SQL Server Management Studio (I right click on the database connection containing master.dbo.sp_BackupDatabases and also RiskAliveDev and say 'New Query' and paste...

1. Is this really true? Does the SQL Agent really set QUOTED_IDENTIFIER OFF; for T-SQL job steps? I did not find any mention of this in the MSDN...

Execute the command to do the backups from a query window (outside of the batch file) yourself.

Just this part:

EXEC master.dbo.sp_BackupDatabases @backupLocation='C:\SQLBackups\', @databaseName='RiskAliveDev', @backupType='F'

If you still get the error then...

Thanks but those don't really give the instances. And the other gives the version of SSMS.

But...going back to your original post, the problem was not finding the stored procedure....

So, I am confused as to which sql login, the REPORTUser_Example used in the Report Manager Datasource or the generic sql login within the datasource within the actual report (.rdl)...

briancampbellmcad (9/9/2016)

---

I have an Access front end and an ODBC SQL Server (2012) front-end seemingly with permissions issues in one specific table. In Access the user gets this message when...

It gives you a...

cp.ap.pp (9/7/2016)

---

Hello,

#EDIT# Since 10 people have looked at this and no suggestions I will pose yet another related question. As this server is a VM and I have seen what...

junk.mail291276 (9/9/2016)

---

Ok, here's my new string:

sqlcmd -U [domain]\[username] -P [password] -S (localdb)\ProjectsV12 -Q "EXEC master.dbo.sp_BackupDatabases @backupLocation='C:\SQLBackups\', @databaseName='RiskAliveDev', @backupType='F'"

A few things that are different:

* Using my Windows credentials.

* Connecting to (localdb)\ProjectsV12...

Just a quick thought -

It could just the the same issues hit when using the sp_MSForech stored procedures - objects can end up skipped due to changes in the...

USE YourDatabase

GO

SELECT OBJECT_NAME(object_id), definition

FROM...

If you want a way to do it from the command line, you can use sc query. If this is still for your local installation, you can use:

sc query "SSRS...

Have you tried fully qualifying the call to the stored procedure, i.e.

EXEC master.dbo.sp_BackupDatabases

Sue

Didn't realize you had duplicated this post and have info in another post.

Refer to: http://www.sqlservercentral.com/Forums/Topic1815590-3411-1.aspx

Sue