well, a snapshot is a readonly version of the existing database at the point in time you create the snapshot;

so it's basically still the original database, but saying ignore...

You are on the right track, i'd say;

i would go with the backup-restore-delete specifics route, same as you are thinking.

it guarantees to not miss any objects, and there's always certain...

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...