Do you need to retain changes made on the test system? Or just have a copy of live data to work on?

Open your browser as administrator - should allow you in & then you can set up relevant security (Site Settings if I recall correctly).

Only way I'd know is to estimate your average BLOB size.

Or for safety, find the maximum likely size and use that.

(Sorry if they're obvious suggestions).

Temp tables are fine in SSRS text type reports - that error just comes up in the visual query designer mode.

The SQL should execute with no problems.

Sorry if my terminology isn't clear - when I say SSRS I mean Report Manager 🙂

They're the same to my mind.

It needs databases to store info, but they can go...

If you've got 2 or more Report Manager instances pointing at the same RS databases, yes that's scale out. Wasn't sure if you already had RS installed or not on...

No need for scale out here as far as I can see.

Just install SQL database engine but not SSRS on the first machine, and SSRS on the other. The RS...

"It depends" was...

ChrisM@Work (1/23/2013)

---

Have you tried figuring out the filters and applying to the inner query? Something like this:

DECLARE @YEAR INT, @MONTH INT

SELECT @YEAR = 2005, @MONTH = 6

DECLARE @StartDate DATETIME, @EndDate...

dwain.c (1/23/2013)

---

Gazareth (1/23/2013)

---

dwain.c (1/22/2013)

---

Upon reflection, I realized that capturing the UserID that deleted the record is not possible in the TRIGGER itself.

So I went back and modified the code to...

lestatf4 (1/23/2013)

---

Here is the script, is should return a years worth of data from @month and @year.

Surely the column order in the query is irrelevant to the optimizer?

create view...

Are all the columns included in the where clause of the query? Could be that the order of columns in the index means the optimiser is disregarding it.

If you could...

I think the database owner is an invalid login - check in sys.databases.

If so, you can change it using ALTER AUTHORIZATION.

dwain.c (1/22/2013)

---

Upon reflection, I realized that capturing the UserID that deleted the record is not possible in the TRIGGER itself.

So I went back and modified the code to show you...

What's wrong with using ESCAPE?

You're along the right lines with the last approach - try using CHARINDEX instead though:

SELECT CHARINDEX('[[% SQL Server %]]', @string)