😛 I just realized something...converting a file from ANSI to UTF-8 is pretty much non-sensical unless you truly need the BOM. UTF-8 covers all 255 ANSI characters with the same...

...on hold...

You should be fine, i.e. after upgrading the Edition the build # should still be the same as what it was when you were on Standard, but check the build...

I am pretty sure I tried it before posting but that code has long since evaporated. I'll try it again though. Chances are I was using 2012 too so I'll...

When moving to the higher edition there is not too much to consider in the way of features since Enterprise has all features Standard does. The optimizer is a little...

The ? marks are a dead giveaway that non-printable ANSI characters are being pushed into an ANSI column or variable (i.e. VARCHAR or CHAR). The hollow squares might be a...

Why?

SQLTestUser (4/9/2013)

---

and i have to insert values into this table but ensure that the first column is always inserted with a value that is one more than the primary key...

This might help get you started:

$Instances = (Get-Content 'C:\Instances.txt') # Make a text file containing your instances, one on each line

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null

foreach ($instance in $Instances)

{

$sqlServer...

Data Flow Task containing:

1. OLE DB Source that selects the data you need to export as a single resultset, i.e. a SELECT statement

2. Conditional Split that evaluates the ID column...

ONLINE=ON is an Enterprise feature.

The rebuild operation, even with ONLINE=ON, can be blocked depending on the iso level and what is using that table...but 10 hours would be a seriously...

Envious...it must be quite a nice thing to have the opportunity to just walk up and ask one of our community's best questions like this once in a while :-)...

Not a great naming convention...

You do not need to...

Sergiy (4/9/2013)

---

Yes, this one looks very different. 🙂

They say - consider environment. Look at the name of the article...