kapil_kk (9/10/2013)

---

Danny Ocean (9/10/2013)

---

Just because of "Steppenwolf" having length 11. So...

Thanks will read up

I got the idea from here by the way

http://www.sqldbadiaries.com/2010/11/13/tempdb-please-allow-me-to-shrink-you/

Dennis Post (9/11/2013)

---

Are you able to increase the size of TempDB or add extra data files to it?

Correct me if I'm wrong people but, the Proccache is stored in memory...

GilaMonster (9/9/2013)

---

Doesn't when I test. It does however throw

Msg 16924, Level 16, State 1, Line 69

Cursorfetch: The number of variables declared in the INTO list must match that of...

Apologies

Msg 102, Level 15, State 1, Line 47

Incorrect syntax near '@cmd'.

its coming back with a syntax error at the print @cmd line :/ which makes me think thats why the script isnt doing anything.

If I declare all the variables just...

Updated script - the script runs fine but nothing seems to be happening? Any help would be appreciated. Cheers

CREATE TABLE #IndexFrag(

database_id int,

object_ID int,

index_id int,

name ntext,

avg_fragmentation_In_Percent...

GilaMonster (9/6/2013)

---

Yes, that's why I said 'Leaving it to you to change the variables, fetch statements, etc.'

If you change the cursor definition, you'll have to change the fetch statements, add...

Appologies, I set the variable but the cursor doesnt work

(0 row(s) affected)

Msg 16924, Level 16, State 1, Line 50

Cursorfetch: The number of variables declared in the INTO list must match...

Cheers for the fast response MarkusB

Second.

select @tablename = '[' + SCHEMA_NAME(t.schema_id) + '].[' + t.name + ']' FROM sys.indexes i INNER JOIN sys.tables AS t ON i.object_id = t.object_id WHERE i.name = @Result AND i.object_id...

Talib123 (9/5/2013)

---

Easily done Via SSRS configuration tools.

If you want to keep the original SSRS dbs for rollback.

1 Backup the dbs with copy.

1a Backup SSRS encryption keys\cert.

2. Restore the dbs...

Koen Verbeeck (9/4/2013)

---

1. You should be able to rename it. I haven't done it myself, but I saw Report databases at a client with different names.

2. You can specify a...

I was doing a migration from one instance which was soley for this application, to an instance which hosted multiple applications. One...

Also, if adding the SPs to all databases on your instance, be sure to add them to the model database so you do not have to go through this process...