If you are only doing daily log backups you should be in SIMPLE mode. Or, you should be doing TX Log backups on a more frequent basis. I...

Yes, DIR is the command C:\I386\ is the path and the rest are switches.

Yeah that would work, once he actually gets the commands working correctly to enumerate the files.

1. The result you are getting is an error returned by xp_cmdshell because you are not passing it a DOS command.

2. To correct this you need to revisit...

It sounds like your database is in Full recovery and you are not doing TX Log backups. Normally when first creating a database you estimate the space needed for...

IMO this is not the way to do it. A trigger fires once per batch so the trigger you have defined will only call the stored procedure for one...

Have you verified that the Named Pipes provider is enabled using SQL Server Configuration Manager?

Basic rule of thumb for logs is to make them 20% of the database size, then monitor growth and re-size accordingly.

As far as recovery models, the answer is, It Depends....

Yeah, I don't know Oracle, so you may need a from clause also I don't know if Oracle supports IF EXISTS. I also don't know if anything other than...

How about this code in the second parameter dataset:

[font="Courier New"]IF EXISTS (SELECT COMPID FROM DL WHERE ORGKEY IN (@ORG))

   BEGIN

       SELECT DISTINCT

           CompId

       FROM

           DL

       WHERE

           ORGKEY IN (@ORG)

   END

ELSE

  ...

Can you attach the RDL file so we can see how you have setup your parameters and datasets? It sounds like you have not mapped the parameter value from...

Yeah Matt, I thought that as well, but also thought the OP may not have posted all the logic needed so I tried to give an idea of the Case...

Here's another personal email about this issue that I will post so everyone can benefit or contribute to the answer:

"-- declare variables

declare @dir varchar(1000), @rowid int, @sqlcmd varchar(1000), @filename varchar(1000)

declare...

You just need to Grant Select on table to user/role instead of doing Grant All on Table to user/role.

What is your licensing mode for SQL Server?

Can you ping the SQL Server when you get the error?

Have you checked the Windows Event log on the server?

Is this happening at...