The job is most likely being executed under the context of the SQL Agent Service user which, depending how setup, may not have permissions outside of the local machine. The...

Are you passing the variable to a stored procedure or to a dataset in the report?

Off the top of my head you could add an option in your multi select...

You can use the report viewer control in two ways - Remote which renders a report hosted on reporting services and local which renders an RDLC file locally - in...

ZZartin (10/3/2016)

---

Hmm... the interface for oracle is pretty primitive and very similar to mysql, I hope you like command line 🙂 But on the back end in terms of what...

Found the answer here:

https://www.microsoft.com/en-us/learning/mcse-certification.aspx

To recognize your efforts in keeping your existing MCSE certification up-to-date, all individuals with active MCSE certifications from the following list will earn the corresponding...

There is a truncation error. Because by default in SSIS truncation errors fail the component.

As shown below, without changing any other settings, taking a 100 char and converting it to...

If statement format for SSRS is below. In this case we are checking the value of a field in our dataset called cost.

=iif(Fields!cost.Value >0,"True","False")

Here is one way to do it assuming the number is always followed by a space or is at the end of the string.

SELECT SUBSTRING(col1, PATINDEX('%[0-9]%', col1), COALESCE(NULLIF(CHARINDEX(' ', col1,...

Just so you know as you are using separate try catch blocks, and also because you are only printing the error, then if your restore of the full backup fails...

If you get that error then I am assuming that the diff backup you are trying to restore isn't matched to the full backup you have restored. You can only...

lsalih (7/19/2016)

---

The one thing I learned is that I can't place restore inside begin/end transaction.

How can I set one batch program to start with doing restore in no recovery...

You can't carry out restores or backups within transactions.

You need to use the Windows scheduler. See the link below for details

https://support.microsoft.com/en-ca/kb/2019698

A linked report is a shortcut to another report. A linked report doesn't have an rdl file so you can't download anything. If you go into the properties of the...

So the problem seems to be you are calling the sp mulitple times in what you call a run and expecting the database to know what else has been inserted...