Hi Lee,

You won't need to give reporting services the new location, just the database name on the server.

Add the user to the TargetServerRole database...

George Heinrich (3/25/2008)

---

Wow...that's insane. So it's not the select or insert statement at all that's doing it.

OK, so now for a super newbie question...how do I figure out the "real"...

I've identified one area that's useful in that output. I've made the useful bits bold to help.

Deadlock encountered .... Printing deadlock information|0

2008-03-25 09:06:12.14 spid4 |0

2008-03-25...

So do you want MyUser to execute the jobs or do you just want to schedule them but you find that you can't because MyUser owns the job?

I personally avoid...

Yep, that's right.

The only thing that makes me think...

I've just tested both on a table containing 4.7 million rows and I get the exact same io stats for both:

Scan count 5, logical reads 8283, physical reads 4, read-ahead...

I wouldn't use the READPAST locking hint as that could cause a considerable amount of problems. Even so, it will...

I've moved my reporting services databases by detaching/attaching without problems. Naturally, whilst you're moving the files reporting services won't be able to connect to the database and it won't...

Hi George,

I feel for you. No identity and a while loop?

How are you starting the serializable transaction - is it by set the transaction isolation level to serializable?

One thing...

I'm not sure I understand...

sampathsoft (3/25/2008)

---

Thanks Karl for your reply.

But i heared Cursurs are memory huter. So if i use cursors will it take more time or are there any othere way to do...

mick burden (3/25/2008)

---

Thanks Karl, the only problem I have is there are 96 fields at the moment and that could change to more at a later date, your solution, is...

Scott Holmes (3/25/2008)

---

Morning All

Id like to format a Date String to look like the following using T-SQL:

'Tue, 01 Jan 2002'

Could anyone give me a hand with the code im stuck?...

sampathsoft (3/25/2008)

---

Hello all,

I have to update more tables in same query using SQL. But i dont know how many tables i have to update. So anyone help me to do...