That's what I'm hoping for. I know PowerShell in 2012 added some new functionality and am just hoping someone can point me in the right direction.

Thanks.

I got the transaction to finish this time!!

I had to kill the processes from the other databases that were connected to the version store.

Interesting. So, my next question is...do all sessions from other databases need to be disconnected from the version store for versioning to be disabled? If so, this may...

The wait type is DISABLE_VERSIONING

SSRS doesn't support that. It's actually more of an IIS issue, as SSRS runs using IIS and so the entire Report Manager site is displayed in HTML format. ...

Yes, it's possible. Google around for how to setup a report subscription, then choose PDF as your report subscription format.

I've been on both extremes. I used to work for a major oil company, and we backed up hundreds of SQL servers across a WAN from Oklahoma City, OK...

There is no way to know exactly, unless a delete trigger was used to record the deletion.

Yes, that is the only drawback I could find.

However, I can tell you first hand that it does work, and it's a pretty flexible solution other than having to maintain...

I used this tutorial from Microsoft:

http://msdn.microsoft.com/en-us/library/ff928700.aspx

It actually works very well, and the only object type that is not supported is FileStream.

Use the Microsoft SYNC framework. Takes out the guesswork.

Well, I would reccomend the following steps:

1.) Detach all existing databases, making a note of the physical file locations of all MDF, NDF, LDF & FilesStream objects.

2.) Uninstall SQL Enterprise.

3.)...

Ok, 1 quick question.

So, I want to modify the partition function to be based on years...but is it really as simple as turning this:

create partition function pfDaily (datetime)

as RANGE...

I like that article, it looks just like what I need.

I'll study it, and use it as a baseline to write similar code without getting rid of any data.

Then, I'll...

Cool, I will give it a shot. Thanks.