Raul! How's it going?

Nice question 🙂

Gaz

Hi Dan,

I've done option 2 successfully in the past, also a 3 - create a linked server in MS SQL & query/import the data through that.

I found 3 a bit...

Is Powershell an option?

Quick and dirty output to screen (or remove the # to output to a file) for one table:

$server = New-Object ('Microsoft.SqlServer.Management.Smo.Server')

$scripter = New-Object ('Microsoft.SqlServer.Management.SMO.Scripter') $server

$scripter.Options.ScriptSchema = $false;

$scripter.Options.ScriptData...

Ha, didn't expect that to be a real proc!

Renaming a report server database is not supported, you can try it though.

You'll need to find any references to the original name in any procs, functions, views etc in both...

Ha, I did not know you could do that!

Just wishful thinking 🙂

You can't add the identity property to an existing table/column.

If you script out the change through the table designer, you'll see the script actually creates a new table with the...

I used to do something like this to make sure I wasn't running an operation on live.

Not sure if it'd work for restore (does it have to be the only...

You might be able to get the information from the default trace:

DECLARE @tracefile nvarchar(1000)

SELECT @tracefile = CAST(value AS NVARCHAR(1000)) FROM ::fn_trace_getinfo(0) where traceid = 1 and property = 2;

PRINT @tracefile

SELECTgt.HostName,...

Been having the same problem myself, the reason why the restored db worked is explained here:

http://itknowledgeexchange.techtarget.com/sql-server/deleting-lob-data-and-shrinking-the-database/

Now to find a suitable maintenance window!

Gaz

Thanks Rob, SSMS does have arithabort on by default, I think SSRS has it off.

Any easy way to check if it could be responsible is to run this in SSMS:

SET...

Hi Steve,

I think you've got one too many ' after 10pm, you'll need to remove that and put one in after the last GO.

Not sure where the closing ) following...

Could be a difference in SET options between SSMS & SSRS? (I'm thinking ARITHABORT)

You can query the TimeDataRetrieval, TimeProcessing, and TimeRendering fields in ReportServer.dbo.ExecutionLog view to find what's taking all...

I don't think the data tools have different versions for Standard and Enterprise, and there's no licensing issues for tools as far as I'm aware...