Let me try replicating the issue at my end. I'll revert once done.

Looks like logic is coded in a complicated way, too much use ot temp tables. Sorry for not looking in depth but you can create a dynamic query to execute...

OCTom (12/5/2013)

---

The first SQL server version I worked with was 2000. I got into the habit of declaring and setting in two statements and I still do that today. I...

I agree with Keith.

Some other process may be running at about the same time or the earlier process is now taking longer time to overlap with this. Try looking at...

Creating an hyperlink (Navigation - Jump to URL) for a pdf file worked for me. Below is the expression I used:

="file:\\fileserver\plant\Certificates\ICR_AER0190_01.pdf"

Hi,

I too have a similar requirement but it seems that it's not feasible.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/43385efd-b4ff-41ef-b24b-da911c155936/displaying-a-word-document-via-reporting-services?forum=sqlreportingservices

Are you trying to create a new text file and write to it within SQL query only?

Following would be a helpful snippet for how you may achieve that.

DECLARE @Text AS...

We have outsourced SQL Server maintenance to IBM. They look after our servers and all backup, performance related activities. We have internal team for application support who backs up individual...

And it's sometimes very tough to work on 2005 when you spend lot of time with 2008 onwards.

Things I would check:

1. The account you logged in as has administrator privileges on the machine.

2. That you typed in this account as the account with remote access.

3. That the...

Oops. It was an old post. You might have figured out the solution by now.

I'm sorry but what do you mean by Line Feed? Is it that the labels appear in a single column? If yes, try exporting the report to pdf and see...

This might help you:

How to relate Theme with Theme2? What is the relationship?

Shawn Melton (10/29/2013)

---

The error provided is not associated with SQL Server Agent not starting, you normally see it when trying to start the SQL Server Service.

You will likely find that...