Are the join predicates indexed in the underlying tables?

What does the execution plan show? Look for scans instead of seeks.

2. check for a trigger in child table with cascade option

I think it may be the only option....

That would work if I could export the embedded image to a file I can work with. How do you export an embedded image from SSRS to a file?

In Report properties, specify the maximum page size you want

Faster than what? FTP (and its secure cousin, SFTP) has been used for this sort of thing since 1971. Its the usual first choice.

FTP

So the numerics might have hyphens?

You can use LIKE with patterns. e.g.

WHERE somecolumn LIKE '%[0-9]%' AND somecolumn NOT LIKE '%[A-Za-z]%'

should match rows that have numbers but no alphabetical characters

This is kind of a trick question. The actual path is not stored in the schema at all. Rather the filetable path_locator is of data hierarchyid that identifies...

The error is here:

SET @Statement2 = 'database_principals.name = ''XYX''' <---Login account

Remove the less than sign (the '<')

Which of the subqueries are you having a problem with?

Koen Verbeeck (5/12/2014)

---

The link icon at the top is for inserting an hyperlink into existing text. So you highlight the text, click the icon and enter the URL.

Another option is...

Set CanGrow to false and explicity set the row height. Worked for me!

Each step has a unique id. Combine that with the run_time and you should have a unique running instance

Have you tried joining on the sysjobs and sysjobschedules tables (on job_id)