look in your code...

since you can only have ONE clustered index on a table, your idea will fail for any table with more than one index.

performance will not automagically improve due to a...

pretty sure you can't truncate a table if it's referenced by indexed views or foreign keys, or views or functions that were created WITH SCHEMABINDING either.

so you want to know if your SQL server is contained in a HyperV environment? is that the question?

i know @@version contains a string when it's in a VM:...

the cost of a developer edition license is in the range of fifty or so dollars on Amazon, and well worth the investment.

that will get you over your limitations imposed...

are you restoring a 2014 database on a 2012 instance? that's the error i'd expect.

Rick Astley.

every time i see a Celko post, i get a bit PO'd like I've been rick rolled.

OK for the folks who have bothered to follow this thread, a minor update, with a bunch of changes that i added myself,as well as some that were also contributed...

not an expert on powershell, but i certainly use it a bit.

i'd be thinking the issue is scope;

it looks to me like none of your functions accept parameters.(AcceptedFeatures,Process,ShowinOutGrid).

what specific variables...

i've used this project quite a few times:

https://ssrscatalogqueries.codeplex.com/

i had to enhance it quite a bit, and it's still not where i want it.

it downloads all the files into sub folders,...

Google, test, repeat until you find one you like, or adapt one that fits your specific needs.

ExecuteScalar will return a single value....that's what you want.

untested, but this is roughly what you want:

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click

myconnection.Open()

'define the command

Dim cmd As New...

my fast proof of concept: drop and recreate is definitely slower

in a measly 1000 iterations,these were my stats:

2113 milliseconds for Drop and Recreate

543 milliseconds for Truncate Existing Table

and my test...

this seems to get me most of the data sources in the current catalogs as a direct query:

WITH MyCTE

AS

(

select convert(varchar(max),CONVERT(varbinary(max),Content))As StrContent,*

from reportserver.dbo.Catalog

)

SELECT SUBSTRING(StrContent,p1.i,p2.i - p1.i),* FROM MyCTE

CROSS APPLY(SELECT...

reports change very rarely...can you simply restore the ReportServer database to the day before you stepped on the data source?

if not, can you restore the database as a different name,...